Search Postgresql Archives

recovery problem

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




 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@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





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux