FATAL ERROR: database does not exist in the system catalog - Mailing list pgsql-admin
From | Linda Fousek |
---|---|
Subject | FATAL ERROR: database does not exist in the system catalog |
Date | |
Msg-id | 75A358176DADD411A8380002B31538B6169E7F@MONA Whole thread Raw |
List | pgsql-admin |
I had a database up and running for a couple of weeks on a windows 2000 machine, and had a web application accessing it remotely with no problems. I had to restart the computer with the postgresql server and had trouble getting the postmaster started again. I finally got the postmaster started after deleting the files '/tmp/.s.PGSQL.5432.lock', '/tmp/.s.PGSQL.5432' and '/usr/local/pgsql/data/postmaster.pid', but when I try to start the web application that uses the database, I get the error "FATAL 1: Database "newtestdb" does not exist in the system catalog". I was also using pgaccess with the postgres user account to administer the database remotely, but when I try to connect with pgaccess now I get the error "FATAL 1: User "postgres" does not exist". The system logfile from today is: Lock file "/tmp/.s.PGSQL.5432.lock" already exists. Is another postmaster (pid 2060) using "/tmp/.s.PGSQL.5432"? /usr/local/pgsql/bin/postmaster: cannot create UNIX stream port DEBUG: database system was shut down at 2002-02-19 10:22:58 DEBUG: checkpoint record is at 0/113640 DEBUG: redo record is at 0/113640; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 89; next oid: 16556 DEBUG: database system is ready FATAL 1: Database "newtestdb" does not exist in the system catalog. FATAL 1: Database "firsttestdb" does not exist in the system catalog. DEBUG: database system was interrupted at 2002-03-05 10:44:50 DEBUG: checkpoint record is at 0/113640 DEBUG: redo record is at 0/113640; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 89; next oid: 16556 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: ReadRecord: record with zero length at 0/113680 DEBUG: redo is not required DEBUG: database system is ready FATAL 1: Database "firsttestdb" does not exist in the system catalog. FATAL 1: user "postgres" does not exist FATAL 1: user "administrator" does not exist Found a pre-existing shared memory block (ID 128) still in use. If you're sure there are no old backends still running, remove the shared memory block with ipcrm(1), or just delete "/usr/local/pgsql/data/postmaster.pid". DEBUG: database system was interrupted at 2002-03-05 10:48:49 DEBUG: checkpoint record is at 0/113680 DEBUG: redo record is at 0/113680; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 89; next oid: 16556 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: ReadRecord: record with zero length at 0/1136C0 DEBUG: redo is not required DEBUG: database system is ready FATAL 1: Database "newtestdb" does not exist in the system catalog. FATAL 1: Database "firsttestdb" does not exist in the system catalog. FATAL 1: Database "newtestdb" does not exist in the system catalog. FATAL 1: Database "firsttestdb" does not exist in the system catalog. DEBUG: statistics collector process (pid 1372) exited with exit code 1 0 [main] postmaster 1812 sync_with_child: child 1780(0x284) died before initialization with status code 0x80 76636 [main] postmaster 1812 sync_with_child: *** child state waiting for longjmp PGSTAT: fork(2): Resource temporarily unavailable DEBUG: server process (pid 1780) exited with exit code 255 DEBUG: terminating any other active server processes DEBUG: all server processes terminated; reinitializing shared memory and semaphores 3189629 [main] postmaster 1812 sync_with_child: child 1444(0x358) died before initialization with status code 0x80 3206101 [main] postmaster 1812 sync_with_child: *** child state waiting for longjmp DEBUG: could not launch startup process (fork failure): Resource temporarily unavailable DEBUG: database system was interrupted at 2002-03-05 11:55:49 DEBUG: checkpoint record is at 0/1136C0 DEBUG: redo record is at 0/1136C0; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 89; next oid: 16556 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: ReadRecord: record with zero length at 0/113700 DEBUG: redo is not required DEBUG: database system is ready FATAL 1: Database "firsttestdb" does not exist in the system catalog. FATAL 1: Database "firsttestdb" does not exist in the system catalog. FATAL 1: Database "firsttestdb" does not exist in the system catalog. DEBUG: database system was interrupted at 2002-03-05 14:05:20 DEBUG: checkpoint record is at 0/113700 DEBUG: redo record is at 0/113700; undo record is at 0/0; shutdown TRUE DEBUG: next transaction id: 89; next oid: 16556 DEBUG: database system was not properly shut down; automatic recovery in progress DEBUG: ReadRecord: record with zero length at 0/113740 DEBUG: redo is not required DEBUG: database system is ready FATAL 1: Database "firsttestdb" does not exist in the system catalog. FATAL 1: Database "newtestdb" does not exist in the system catalog. FATAL 1: user "postgres" does not exist ----- the database "firsttestdb" is the database I had been connecting to for the last couple of weeks, and the database "newtestdb" is a new database I created this morning, and connections to both worked for a while this morning, before the server was restarted. And the postgres user is the owner of both databases. Any idea why the remote systems can't access the database anymore? Thanks, Linda
pgsql-admin by date: