On Thu, 2006-10-26 at 23:58 +0800, Peter Santiago wrote: > Hi, > > I'd like to post a question for all of you postgresql gurus. In a new > installation of postgresql, is it SOP to add a database called postgres?
no. the databases that are absolutely needed are template0 and template1, as template1 is the "template" database, while template0 serves as a backup to template1. > My situation is this. I require connecting to a remote postgresql > server and create/access databases remotely. When I use the createdb > command on the local machine like so: createdb -U sa -h 192.168.1.1 > testdb, this will return an error that the database postgres is not > found. The sa user is granted ability to breate databases. > > The maddening thing about this, is when you execute the same command on > the local machine with a Postgresql server running, just createdb -U sa > testdb, the database gets created with nary a squeak. > > The question is why is database postgres is required to be present on > the remote Postgresql server, before a regular user, with create > database permission, can create a database? -- Paolo Alexis Falcone <[EMAIL PROTECTED]> _________________________________________________ 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
