Re: starting posgresql for the first time and most probably last :)

RM> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
RM> LOG: could not create IPv6 socket: Address family not supported by protocol
RM> LOG: database system was shut down at 2004-04-29 10:51:19 NZST
RM> LOG: checkpoint record is at 0/9B1058
RM> LOG: redo record is at 0/9B1058; undo record is at 0/0; shutdown TRUE
RM> LOG: next transaction ID: 536; next OID: 17142
RM> LOG: database system is ready

RM> AT THIS POINT I DID CTRL+Z AS NOTHING ELSE HAPPENED

RM> [1]+ Stopped /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data

RM> POSMASTER HAS STOPPED

RM> bash-2.05b$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
RM> FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
RM> HINT: Is another postmaster (PID 19495) running in data directory
RM> "/usr/local/pgsql/data"?
RM> bash-2.05b$

RM> UNABLE TO RESTART? ANOTHER INSTANCE OF POSTMASTER RUNNING? NO!!

I think your Postgres server is runing. After CTRL+Z write bg into the
console to run the postmaster process in background. And now you can
connect to the server.

DAQ