Re: Maintenance DB

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Chris Velevitch" <chris(dot)velevitch(at)gmail(dot)com>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Maintenance DB
Date: 2006-04-05 07:40:11
Message-ID: E7F85A1B5FF8D44C8A1AF6885BC9A0E4011C9A29@ratbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Chris Velevitch
> Sent: 05 April 2006 07:37
> To: pgadmin-support(at)postgresql(dot)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.

Browse pgadmin-support by date

  From Date Subject
Next Message Chris Velevitch 2006-04-05 07:59:55 Re: silently fails to connect to remote server
Previous Message Dave Page 2006-04-05 07:35:31 Re: silently fails to connect to remote server