Thread: Postgre Service Cant Start
I wrote an application that copy data from Oracle to Postgre 8.3 using COPY. During this import privileges to directory base/22904/ has been changed. After that in couple of seconds postgre service stopped (windows allowed to change privileges to that directory). Now i cant start service. In logs i found:
%t LOG: database system was interrupted while in recovery at 2009-06-17 15:21:09 CEST
%t HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
%t LOG: database system was not properly shut down; automatic recovery in progress
%t LOG: redo starts at 5F/6804BD60
%t FATAL: could not create relation 1663/22904/623510509: File exists
%t CONTEXT: xlog redo insert: rel 1663/22904/623510509; tid 853987/20
%t DZIENNIK: startup process (PID 3336) exited with exit code 1
%t DZIENNIK: aborting startup due to startup process failure
Is there any possibility to start database and restore data. I assume that file 623510509 contains data from one table. I can loose that but i cant loose the rest of my data as there is about 1 bilion records in about 40 tables. I dont have any backup. Please help!
%t LOG: database system was interrupted while in recovery at 2009-06-17 15:21:09 CEST
%t HINT: This probably means that some data is corrupted and you will have to use the last backup for recovery.
%t LOG: database system was not properly shut down; automatic recovery in progress
%t LOG: redo starts at 5F/6804BD60
%t FATAL: could not create relation 1663/22904/623510509: File exists
%t CONTEXT: xlog redo insert: rel 1663/22904/623510509; tid 853987/20
%t DZIENNIK: startup process (PID 3336) exited with exit code 1
%t DZIENNIK: aborting startup due to startup process failure
Is there any possibility to start database and restore data. I assume that file 623510509 contains data from one table. I can loose that but i cant loose the rest of my data as there is about 1 bilion records in about 40 tables. I dont have any backup. Please help!