From: | "Patryk Sosinski" <patryk(dot)sosinski(at)gmail(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Postgre Service Cant Start |
Date: | 2009-06-17 15:54:24 |
Message-ID: | 002001c9ef63$e3f49eb0$0a00000a@SMDVQ |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Marc Fromm | 2009-06-17 16:51:49 | error: duplicate key |
Previous Message | Iñigo Martinez Lasala | 2009-06-17 14:28:28 | Re: Yum upgrade of PostgreSQL 8.4 from to rc1 rendered dataunusable |