Farhan Khan wrote: > > Because of some OS failure I have to reinstall linux and > postgres and now database start gives me following error > message. Any pointers will be apprciated ... > > testuser@machine:postgresql-8.2.5$ > /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data > LOG: database system was shut down at 2007-10-23 16:30:49 PDT > LOG: checkpoint record is at 0/42C408 > LOG: redo record is at 0/42C408; undo record is at 0/0; shutdown TRUE > LOG: next transaction ID: 0/593; next OID: 10820 > LOG: next MultiXactId: 1; next MultiXactOffset: 0 > LOG: database system is ready > FATAL: database "db_test1" does not exist > FATAL: database "db_test1" does not exist > FATAL: database "db_test1" does not exist > FATAL: database "db_test1" does not exist > > " db_test1" was one the databases I was using before > reinstalling everything. Note during re-installation, I have > formatted the harddrive which has erased the > /usr/local/pgsql/bin/postgres folder ... but there were some > stuff that persisted as it was on NFS (this includes the > installer for postgres) ... > > BTW, where does postgres saves all db related information > which is used at db start time. Is there a utility to edit > this information?? Your cluster data are stored in /usr/local/pgsql/data. That is also where your databases live unless you defined them in a tablespace somewhere else. Does the server start so that you can connect to database "postgres"? The correct thing to do for you would be to restore from a backup, but I guess you know that. Yours, Laurenz Albe ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
