Re: pg_standby instructions

From: akp geek <akpgeek(at)gmail(dot)com>
To: jd(at)commandprompt(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_standby instructions
Date: 2009-11-25 22:24:52
Message-ID: 2024a9fb0911251424o4980b62x353e839648e1e64d@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have been trying to use the PITR tools , I am running into the following
issue. I don't know how to resolve it. can you please help?
I tried to search the online blogs, I did not find much for the error.

NOTICE: check_config_func()
NOTICE: Performing standard archive
NOTICE: archive_func()
NOTICE: send_queue_func()
NOTICE: list_queue_func()
NOTICE: generate_slave_list_func()
NOTICE: Your slaves are: ['10.100.101.150']
Traceback (most recent call last):
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 343, in ?
archive_func()
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 254, in
archive_func
queue = send_queue_func()
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 219, in
send_queue_func
for host in list_queue_func():
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 202, in
list_queue_func
list_archives = os.listdir(queuedir)
OSError: [Errno 2] No such file or directory: '/opt/postgres/archive/
10.100.101.150'
LOG: archive command failed with exit code 1
DETAIL: The failed archive command was: cmd_archiver -C
/export/home/postgres/8.4/pitrtools/cmd_archiver.ini -F
pg_xlog/00000003000000010000007D
NOTICE: check_config_func()
NOTICE: Performing standard archive
NOTICE: archive_func()
NOTICE: send_queue_func()
NOTICE: list_queue_func()
NOTICE: generate_slave_list_func()
NOTICE: Your slaves are: ['10.100.101.150']
Traceback (most recent call last):
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 343, in ?
archive_func()
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 254, in
archive_func
queue = send_queue_func()
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 219, in
send_queue_func
for host in list_queue_func():
File "/export/home/postgres/8.4/pitrtools/cmd_archiver", line 202, in
list_queue_func
list_archives = os.listdir(queuedir)
OSError: [Errno 2] No such file or directory: '/opt/postgres/archive/
10.100.101.150'
LOG: archive command failed with exit code 1
DETAIL: The failed archive command was: cmd_archiver -C
/export/home/postgres/8.4/pitrtools/cmd_archiver.ini -F
pg_xlog/00000003000000010000007D

Regards

On Fri, Nov 20, 2009 at 12:23 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>wrote:

> On Fri, 2009-11-20 at 12:14 -0500, akp geek wrote:
> > Thanks for the response . I was not able to get back on this.. Our set
> > up is Solaris. will be there any thing that I can use on Solaris
>
> They should work on Solaris. It is just Python + Utilities you can
> already get (like rsync and ssh).
>
> >
> > Regards
> >
> > On Wed, Nov 18, 2009 at 4:58 PM, Joshua D. Drake <jd(at)commandprompt(dot)com>
> wrote:
> > > On Wed, 2009-11-18 at 16:46 -0500, akp geek wrote:
> > >> Hi All -
> > >>
> > >> I would like to know if any one has instructions on how
> > >> to setup pg_standby, if so can you please share?
> > >
> > > If you are on a *nix platform, I would suggest PITRTools which utilizes
> > > pg_standby but gives you a more complete solution. Check out:
> > >
> > > https://projects.commandprompt.com/public/pitrtools
> > >
> > > Its BSD licensed.
> > >
> > > Joshua D. Drake
> > >
> > >
> > > --
> > > PostgreSQL.org Major Contributor
> > > Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> > > Consulting, Training, Support, Custom Development, Engineering
> > > If the world pushes look it in the eye and GRR. Then push back harder.
> - Salamander
> > >
> > >
> >
>
>
> --
> PostgreSQL.org Major Contributor
> Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
> Consulting, Training, Support, Custom Development, Engineering
> If the world pushes look it in the eye and GRR. Then push back harder. -
> Salamander
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2009-11-25 22:37:30 Re: pg_standby instructions
Previous Message David Kerr 2009-11-25 22:19:09 Getting "duplicate key value violates unique constraint" on 2nd run of function.