question on warm standby

From: "Mark Steben" <msteben(at)autorevenue(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: question on warm standby
Date: 2008-11-13 21:26:23
Message-ID: 77785C387FC44102BF108D152DC501C2@dei26g028534
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
My problem probably is that I need to look at the forest but am
hyper-focusing on a maple twig. I have been looking at this for 2 days now
And would appreciate some feedback...

I am running postgres 8.3.4 on master(mymachine) and slave(hummer). I am
attempting to implement warm standby.
1. On mymachine I have the following archive_command:
Scp %p postgres(at)hummer:/var/backups/archlog/%f
(scp has been set up with ssh keys so that password
Is not required for postgres user)
This works fine. Copies wal logs to the /var/backups/archlog directory.

2. Before I attempt pg_standby or some other wait script on hummer I have
Used a simple cp command in my recovery.conf file to manually restore
My first set of updates:

restore_command = 'cp /var/backups/archlog/%f %p'

From the doc I am assuming that %f should be the file name(s) of the
Wal log in /var/backups/archlog/ to be copied into the
/*/*/*/*/pg_xlog directory referenced by %p
But %f seems to be referencing current wal log names in
/*/*/*/*/pg_xlog. I am getting messages like:

cp: cannot stat `/var/backups/archlog/0000000600000003000000D2':
No such file or directory

0000000600000003000000D2 is an actual wal log in hummer's
/*/*/*/*/pg_xlog directory.

How do I get the %f macro to reference the file names in the
/var/backups/archlog directory?

Once I get past this, then I can play around with pg_standby and get
Real warm_standby started.

Thanks for your help,

Committed to Creating @utoEnthusiasts. Please provide us with your feedback.

________________________________

Mark Steben│Database Administrator│ @utoRevenueT
95 Ashley Ave. West Springfield, MA., 01089
413-243-4800 x1512 (Phone) │ 413-732-1824 (Fax)
A Division of Dominion Enterprises





Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2008-11-14 03:05:48 Re: question on warm standby
Previous Message Isabella Ghiurea 2008-11-13 21:10:15 db restore question/issue