current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 8 down vote favorite
3

Apparently there is a database "postgres" that is created by default on each postgresql server installation. Can anyone tell me or point me to documentation what it is used for?

share|improve this question
add comment

3 Answers

up vote 6 down vote accepted

It appears that it does not really have a well-defined purpose. According to the docs:

Creating a database cluster consists of creating the directories in which the database data will live, generating the shared catalog tables (tables that belong to the whole cluster rather than to any particular database), and creating the "template1" and "postgres" databases.

[...]

The postgres database is a default database meant for use by users, utilities and third party applications.

(Source: http://www.postgresql.org/docs/8.2/interactive/app-initdb.html )

share|improve this answer
 
OK, that works for me. ;) Thanks! –  dareios Mar 3 '10 at 11:30
add comment
up vote 20 down vote

When a client application connects to a Postgres server, it must specify which database that it wants to connect to. If you don't know the name of a database (within the cluster serviced by the postmaster to which you connect), you can find a list of database names with the command:

 psql -l

When you run that command, psql connects to the server and queries pg_database for a list of database names. However, since psql is a Postgres client application, it can't connect to the server without knowing the name of at least one database: Catch-22. So, psql is hard-coded to connect to a database named "postgres" when you run "psql -l".

-- Korry
share|improve this answer
 
Interesting, thanks for the additional info! –  dareios Mar 10 '10 at 16:47
add comment
up vote 8 down vote

There is also the database template0, your safety net when you screw up all others.

  1. postgres is your default database to connect with.
  2. template1 is your default for creating new databases, these are created just like template1
  3. template0 is usefull when template1 is corrupted (wrong settings etc.) and you don't want to spend a lot of time to fix this. Just drop template1 and create a new template1 using the database template0.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.