Postgre Service Cant Start

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!

Browse pgsql-admin by date

  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