From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Imre Oolberg <imre@auul.pri.ee>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: Mon, 03 Jan 2011 14:37:56 -0600
Message-ID: <4D21DF440200002500038F6B@gw.wicourts.gov> (raw)
In-Reply-To: <4D222E45.2080701@auul.pri.ee>
References: <AANLkTikY_XJ0Ok7bLGVxXXfGgenfnzJ4RnSiM_H40FCM@mail.gmail.com>
<4D2213EB.7090700@auul.pri.ee>
<42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com>
<22500.1294080152@sss.pgh.pa.us>
<E486B5B1-EC5F-4615-8633-D89CF6665663@elevated-dev.com>
<22730.1294081008@sss.pgh.pa.us>
<4D222E45.2080701@auul.pri.ee>
Imre Oolberg <imre@auul.pri.ee> wrote:
> I am starting to think more in the direction what Kevin Grittner
> suggested that i miss something in my procedure and instead
> following so to say recovery path i am doing something else which
> strangely ends up with working database process but actually
> misses some data.
Did you keep the pg_xlog/archive_status directory and its *.backup
files?
It sounds like maybe it's not finding the recovery.conf file. Are
the permissions right? Do you have spaces or other special
characters in the directory path to your cluster data directory? (I
notice you didn't use quoting around the path.)
Did you delete (or avoid copying) the postmaster.pid file?
Making sure to start with an empty log file and/or directory
(depending on how you log), what shows up in the log on your
recovery attempt?
-Kevin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Kevin.Grittner@wicourts.gov, imre@auul.pri.ee, tgl@sss.pgh.pa.us, scott_ribe@elevated-dev.com
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
In-Reply-To: <4D21DF440200002500038F6B@gw.wicourts.gov>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox