Re: pg_standby instructions

[akp geek <akpgeek@xxxxxxxxx>]

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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general