Re: Maintenance DB

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Chris Velevitch
> Sent: 05 April 2006 07:37
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Maintenance DB
>
> I'm using Windows version 1.4.2 on Win XP Sp1.
>
> I'm trying to add a new server for a remote server and I
> don't understand what the 'Maintenance DB' attribute is.
> Manual says nothing about it.

Wow, not sure how that got missed. Will fix.

The Maintenance DB is the database that pgAdmin first connects to.
Unlike some DBMSs, all PostgreSQL connections must be made to a
database, you cannot connect and then select a database. This database
is normally 'postgres' in PostgreSQL 8.1+, prior to that, template1 was
generally used.

Regards, Dave.