On Fri, Oct 27, 2006 at 12:45:35AM +0800, Paolo Alexis Falcone wrote: > 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.
AFAICR, old versions don't have template0 database. It only got included in newer versions after it was determined in a pgsql-hackers discussion that some admins tend to break the "template" database. > > 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. This error usually appears when you issue psql command as postgres user without specifying a database name -- psql assumes the username as the database name if no database name is given. Do you also get this error with other postgres console tools on that remote server? If not, check the authenticity of createdb. On some postgresql versions, createdb is just a shell script calling psql with "CREATE DATABASE" sql. HTH -- $_=q:; # SHERWIN # 70;72;69;6e;74;20; 27;4a;75;73;74;20; 61;6e;6f;74;68;65; 72;20;50;65;72;6c; 20;6e;6f;76;69;63; 65;27;:;;s=~?(..); ?=pack q$C$,hex$1; ;;;=egg;;;;eval;;; _________________________________________________ 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
