Dnia czwartek, 7 kwietnia 2005 10:49, Marcin Giedz napisał: > 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? OK .... I will answer myself ;) I've turned on postmaster with debug mode and found that pg data directory was world writable/readable - so "chmod -R 700 /mnt/db/pg1" and postmaster have run OK ;) Thx, Marcin > > Thx, > Marcin > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq