Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id A86399F9EED for ; Mon, 11 Dec 2006 10:11:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 63859-04 for ; Mon, 11 Dec 2006 10:10:22 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id E73B09FA334 for ; Mon, 11 Dec 2006 10:10:32 -0400 (AST) Received: from [213.146.143.243] (port=15679 helo=[172.16.208.165]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1GtlrS-0002eo-PA for pgsql-admin@postgresql.org; Mon, 11 Dec 2006 14:10:30 +0000 Message-ID: <457D672F.5060302@mailnetwork.co.uk> Date: Mon, 11 Dec 2006 14:11:59 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: how to recover database back from /data folder [ Possibly References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/146 X-Sequence-Number: 23938 > I think the above messages support the fact that the database was > shutdown > properly before the filesystem level backup. > Can anyone kindly confirm it ? "LOG: database system is ready" Says it all - if it hadn't been, you'd have gotten "LOG: database system was not shut-down cleanly, recovering" or along those lines. > > I listed the tables and did some selects the data seems to be there. > I think postgres was not starting for some peripheral issues > not because that data folder was corrupted. > > BTW > when i first started postmaster it gave an error related to > too liberal permissions. Probably the original poster was doing > the same mistake. > > Regds > mallah. > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > !DSPAM:37,457d667230861609539772! > > -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834