Re: [GENERAL] Recovery problem with PostgreSQL

2006-05-11 Thread Shoaib Mir
That should be true about `/data1_node5/arch/0001.history'  since there may not be any timelines created by previous archiver recoveriesBut the messagecp: cannot stat  `/data1_node5/arch/00010007'' suggests that it was not able to restore one of the log files while doing the rec

Re: [GENERAL] Recovery problem with PostgreSQL

2006-05-11 Thread Tom Lane
"Shoaib Mir" <[EMAIL PROTECTED]> writes: > While running the recovery process I am getting the following errors for > cannot stat: > cp: cannot stat `/data1_node5/arch/0001.history': No such file or > directory What makes you think this is an error? As pointed out in the docs, the archive_re

[GENERAL] Recovery problem with PostgreSQL

2006-05-10 Thread Shoaib Mir
While running the recovery process I am getting the following errors for cannot stat: cp: cannot stat `/data1_node5/arch/0001.history': No such file or directory cp: cannot stat `/data1_node5/arch/00010007.02C4C530.backup': No such file or directory cp: cannot stat `/data1_node5

[GENERAL] recovery problem

2006-04-19 Thread jayati . biswas
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 e

[GENERAL] recovery problem

2006-04-19 Thread jayati . biswas
hello, I am trying to setup a "hot standby" on a second machine. I have created a "recovery.conf" file and started a restore with logs from the primary machine. everything was OK. now a have new transaction logs generated by the primary machine and I want to "play" them on the secondary one. I