On 04/10/2010 17:36, Marie-Claude QUIDOZ wrote:
Hello
By default, pgAdmin connects to the postgres database. With "by
default" I mean that you didn't change the maintenance DB in the
server dialog.
Yes I haven't change because I don't know what to put. I have the
choice between postgres, edb or template1 and I don't find any
documentation to help me to understand. I don't understand what is
"maintenance DB"
The "maintenance DB" is just a database to which pgAdmin connects by
default, before you click some other one which you're going to work on.
There's nothing special about it - it's usually an empty database.
This is necessary because PostgreSQL doesn't have the concept of just
"connecting to the server" - you *have* to connect to a specific
database as well. In a normal PostgreSQL installation, the "postgres"
database is provided as a convenience for this purpose.
I presume that "edb" is the equivalent in EnterpriseDB - the EDB folks
here will be able to confirm.
"template1" is what was used in older versions of PostgreSQL. However,
template1 is also used as a default template when new databases are
created, so having a separate "postgres" database keeps things tidy.
I hope that this makes sense. :-)
Ray.
--
Raymond O'Donnell :: Galway :: Ireland
r...@iol.ie
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
