|
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 |
