Thanks everyone for all your help. After reboot the server, I was able to recreate user and database. I am done with the installation. Thanks, Tri. -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Tom Lane Sent: Thursday, March 20, 2008 3:57 PM To: Tri Quach Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: createuser: could not connect to database postgres: FATAL: could not open file "global/pg_database": No such file or directory "Tri Quach" <tquach@xxxxxxxxx> writes: > createuser: could not connect to database postgres: FATAL: could not open > file "global/pg_database": No such file or directory So is that file present (under /var/lib/pgsql/data)? What messages are in the postmaster's logfile? What PG version is this, and on what platform? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general ______________________________________________________________________ This email was scanned by the MessageLabs Security System contracted by the Hawaii Dept Of Education. If you receive suspicious/phish email, forward a copy to spamreport@xxxxxxxxx This helps us monitor suspicious/phish email getting thru. You will not receive a response from us, but rest assured the information received will help to build additional protection. For info about this service please visit http://www.messagelabs.com/email ______________________________________________________________________ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general