Thread: Maintenance DB

Maintenance DB

From
"Chris Velevitch"
Date:
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.


Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au


Re: Maintenance DB

From
"Dave Page"
Date:

> -----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.