Justin Jereza wrote:
The postgres DB was added in 8.1. Createdb, createuser, and the like
were modified to use postgres instead of the old template1 because of
locking issues when template1 is in use while trying to create a DB.
To quote the changelog:
* Make initdb create a new standard database called postgres, and
convert utilities to use postgres rather than template1 for
standard lookups (Dave)
In prior releases, template1 was used both as a default connection
for utilities like createuser, and as a template for new databases.
This caused "CREATE DATABASE" to sometimes fail, because a new
database cannot be created if anyone else is in the template
database. With this change, the default connection database is now
postgres, meaning it is much less likely someone will be using
template1 during "CREATE DATABASE".
_________________________________________________
Philippine Linux Users' Group (PLUG) Mailing List
[email protected] (#PLUG @ irc.free.net.ph)
Read the Guidelines: http://linux.org.ph/lists
Searchable Archives: http://archives.free.net.ph
Thanks for the update. This was the info I was looking for.
-- Peter Santiago [EMAIL PROTECTED] My website: www.psinergybbs.com My spamtrap address: [EMAIL PROTECTED]
smime.p7s
Description: S/MIME Cryptographic Signature
_________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
