Hi Everyone,
I am using PostgreSQL and am having trouble starting the postmaster. For a period of time my install worked fine however it now will not start because it cannot find a file called server.crt in the data directory.
Could somebody please explain how to fix this problem? Below is a listing of the serverlog file. Please see the bottom section for the relevent problem, thanks.
LOG: database system was shut down at 2003-04-18 01:56:58 EST
LOG: checkpoint record is at 0/801A3C
LOG: redo record is at 0/801A3C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
LOG: fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 19:08:59 EST
LOG: checkpoint record is at 0/801A7C
LOG: redo record is at 0/801A7C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: smart shutdown request
LOG: statistics collector process (pid 701) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 20:01:28 EST
LOG: checkpoint record is at 0/809E78
LOG: redo record is at 0/809E78; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 495; next oid: 16978
LOG: database system is ready
FATAL: user "root" does not exist
LOG: smart shutdown request
LOG: statistics collector process (pid 701) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 20:19:45 EST
LOG: checkpoint record is at 0/8100C8
LOG: redo record is at 0/8100C8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 504; next oid: 16979
LOG: database system is ready
ERROR: CREATE DATABASE: database "PostgreSQL" already exists
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-29 20:22:01 EST
LOG: checkpoint record is at 0/810108
LOG: redo record is at 0/810108; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 508; next oid: 16979
LOG: database system is ready
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-29 20:38:16 EST
LOG: checkpoint record is at 0/810148
LOG: redo record is at 0/810148; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 508; next oid: 16979
LOG: database system is ready
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
[702] LOG: database system was shut down at 2003-04-29 21:32:41 EST
[702] LOG: checkpoint record is at 0/810188
[702] LOG: redo record is at 0/810188; undo record is at 0/0; shutdown TRUE
[702] LOG: next transaction id: 508; next oid: 16979
[702] LOG: database system is ready
[692] LOG: smart shutdown request
[692] LOG: statistics collector process (pid 700) exited with exit code 1
[1403] LOG: shutting down
[1403] LOG: database system is shut down
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
Thanks for your help.
Regards
Davo
I am using PostgreSQL and am having trouble starting the postmaster. For a period of time my install worked fine however it now will not start because it cannot find a file called server.crt in the data directory.
Could somebody please explain how to fix this problem? Below is a listing of the serverlog file. Please see the bottom section for the relevent problem, thanks.
LOG: database system was shut down at 2003-04-18 01:56:58 EST
LOG: checkpoint record is at 0/801A3C
LOG: redo record is at 0/801A3C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
LOG: fast shutdown request
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 19:08:59 EST
LOG: checkpoint record is at 0/801A7C
LOG: redo record is at 0/801A7C; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 480; next oid: 16976
LOG: database system is ready
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: smart shutdown request
LOG: statistics collector process (pid 701) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 20:01:28 EST
LOG: checkpoint record is at 0/809E78
LOG: redo record is at 0/809E78; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 495; next oid: 16978
LOG: database system is ready
FATAL: user "root" does not exist
LOG: smart shutdown request
LOG: statistics collector process (pid 701) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-24 20:19:45 EST
LOG: checkpoint record is at 0/8100C8
LOG: redo record is at 0/8100C8; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 504; next oid: 16979
LOG: database system is ready
ERROR: CREATE DATABASE: database "PostgreSQL" already exists
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-29 20:22:01 EST
LOG: checkpoint record is at 0/810108
LOG: redo record is at 0/810108; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 508; next oid: 16979
LOG: database system is ready
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
LOG: database system was shut down at 2003-04-29 20:38:16 EST
LOG: checkpoint record is at 0/810148
LOG: redo record is at 0/810148; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 508; next oid: 16979
LOG: database system is ready
LOG: smart shutdown request
LOG: statistics collector process (pid 700) exited with exit code 1
LOG: shutting down
LOG: database system is shut down
[702] LOG: database system was shut down at 2003-04-29 21:32:41 EST
[702] LOG: checkpoint record is at 0/810188
[702] LOG: redo record is at 0/810188; undo record is at 0/0; shutdown TRUE
[702] LOG: next transaction id: 508; next oid: 16979
[702] LOG: database system is ready
[692] LOG: smart shutdown request
[692] LOG: statistics collector process (pid 700) exited with exit code 1
[1403] LOG: shutting down
[1403] LOG: database system is shut down
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
/usr/local/pgsql/bin/postmaster: failed to load server certificate (/usr/local/pgsql/data/server.crt): No such file or directory
Thanks for your help.
Regards
Davo