From: | jayati(dot)biswas(at)cmcltd(dot)com |
---|---|
To: | dmagick(at)gmail(dot)com |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | recovery problem |
Date: | 2006-04-19 07:03:06 |
Message-ID: | 53019.203.197.96.132.1145430186.squirrel@mail.cmcltd.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I want to prepare a backup machine (for disaster management) by
passing only the ARCHIVEDIR directory from another online machine - both
the machines have Postgresql installed. We have sent PGLOG and ARCHIVEDIR.
Previously it was working,but now,when I am issuing pg_ctl start,it is
giving error like this...
postmaster starting
postgres(at)carme:/usr/local/pgsql/data> LOG: database system was shut down
at 2006-04-19 11:56:35 IST
LOG: starting archive recovery
LOG: restore_command = "cp /mnt/server/archivedir/%f %p"
cp: cannot stat `/mnt/server/archivedir/00000001.history': No such file or
directory
LOG: restored log file "000000010000000000000000" from archive
LOG: record with zero length at 0/A70B28
LOG: invalid primary checkpoint record
LOG: restored log file "000000010000000000000000" from archive
LOG: record with zero length at 0/A70AEC
LOG: invalid secondary checkpoint record
PANIC: could not locate a valid checkpoint record
LOG: startup process (PID 7849) was terminated by signal 6
LOG: aborting startup due to startup process failure
Actually I can't take full data backup,everyday.For this reason,I was
using pg_xlog directory.
Please help me,in this stage.
Thanking you
Jayati Biswas
From | Date | Subject | |
---|---|---|---|
Next Message | Danish | 2006-04-19 07:14:32 | tomcat postgresql connectivity error |
Previous Message | Kris Jurka | 2006-04-19 06:42:28 | Re: catch SQLException, error code for Foeign key violation, |