Thread: createuser: could not connect to database postgres: FATAL: could not open file "global/pg_database": No such file or directory

Hi All,

I need your help to fix this problem.

When I ran initdb, I got the warning error below.

Then I tried to create a user.  I got error “createuser: could not connect to database postgres: FATAL:  could not open file "global/pg_database": No such file or directory”.  Please see the out put below.

Thank you for your help.

Tri.

-bash-2.05b$ initdb --lc-collate=C

The files belonging to this database system will be owned by user "postgres".

This user must also own the server process.

The database cluster will be initialized with locales

  COLLATE:  C

  CTYPE:    en_US.UTF-8

  MESSAGES: en_US.UTF-8

  MONETARY: en_US.UTF-8

  NUMERIC:  en_US.UTF-8

  TIME:     en_US.UTF-8

The default database encoding has accordingly been set to UTF8.

creating directory /var/lib/pgsql/data ... ok

creating subdirectories ... ok

selecting default max_connections ... 100

selecting default shared_buffers/max_fsm_pages ... 24MB/153600

creating configuration files ... ok

creating template1 database in /var/lib/pgsql/data/base/1 ... ok

initializing pg_authid ... ok

initializing dependencies ... ok

creating system views ... ok

loading system objects' descriptions ... ok

creating conversions ... ok

setting privileges on built-in objects ... ok

creating information schema ... ok

vacuuming database template1 ... ok

copying template1 to template0 ... ok

copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections

You can change this by editing pg_hba.conf or using the -A option the

next time you run initdb.

Success. You can now start the database server using:

    postgres -D /var/lib/pgsql/data

or

    pg_ctl -D /var/lib/pgsql/data -l logfile start

-bash-2.05b$ pg_ctl -D /var/lib/pgsql/data -l logfile start

server starting

-bash-2.05b$ createuser -A -D -P nssb

Enter password for new role:

Enter it again:

Shall the new role be allowed to create more new roles? (y/n) n

createuser: could not connect to database postgres: FATAL:  could not open file "global/pg_database": No such file or directory