Problem with backup... - Mailing list pgsql-admin

From Marcin Giedz
Subject Problem with backup...
Date
Msg-id 200504071049.22677.marcin.giedz@eulerhermes.pl
Whole thread Raw
Responses Re: Problem with backup...  (Marcin Giedz <marcin.giedz@eulerhermes.pl>)
List pgsql-admin
Hello...


Here is procedure of making everyday online backup:
1) select pg_start_backup('xxx');
2) tar -cf backup-xxx.tar /mnt/db/pg1
3) select pg_stop_backup();
rm all archived WAL files before special one taken from backup_log
4) tar -cf var-xx.tar /mnt/db/var

Next I'd like to use this copy on my test machine. So I copy backup-xxx.tar
and var-xxx.tar and untar these files. Directories structure on test are the
same like on production machine. But when I try to run pg_ctl only empty log
file is created but postmaster doesn't run.
Can anyone please tell me what I'm doing wrong?

Thx,
Marcin




pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: delete to slow
Next
From: Marcin Giedz
Date:
Subject: Re: Problem with backup...