X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3FEF5538A8 for ; Thu, 7 Apr 2005 10:58:56 +0100 (BST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 07583-04 for ; Thu, 7 Apr 2005 09:58:52 +0000 (GMT) Received: from mail.eulerhermes.pl (mail.hermes-kredit.pl [217.153.119.83]) by svr1.postgresql.org (Postfix) with ESMTP id 0ABA15386B for ; Thu, 7 Apr 2005 10:58:51 +0100 (BST) Received: from [192.168.49.9] (helo=xterm.podsiec) by mail.eulerhermes.pl with esmtpa (Exim 4.42) id 1DJTmn-00069f-BA for pgsql-admin@postgresql.org; Thu, 07 Apr 2005 11:58:53 +0200 From: Marcin Giedz Organization: Euler Hermes To: pgsql-admin@postgresql.org Subject: Re: Problem with backup... Date: Thu, 7 Apr 2005 11:58:49 +0200 User-Agent: KMail/1.7.1 References: <200504071049.22677.marcin.giedz@eulerhermes.pl> In-Reply-To: <200504071049.22677.marcin.giedz@eulerhermes.pl> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-2" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200504071158.49996.marcin.giedz@eulerhermes.pl> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.098 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200504/97 X-Sequence-Number: 17110 Dnia czwartek, 7 kwietnia 2005 10:49, Marcin Giedz napisa=B3: > 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.t= ar > 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=20 found that pg data directory was world writable/readable - so "chmod -R=20 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