Thread: pg_standby instructions

Hi All -

              I would like to know if any one has instructions on how
to setup pg_standby, if so can you please share?

Thanks for the help

Regards

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

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

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

Regards

On Wed, Nov 18, 2009 at 4:58 PM, Joshua D. Drake <jd@commandprompt.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
>
>

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@commandprompt.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

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@commandprompt.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

On Wed, 2009-11-25 at 17:24 -0500, akp geek wrote:
> 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.

> 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

Did you run cmd_archiver -I ?

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

On Wed, 2009-11-25 at 17:24 -0500, akp geek wrote:
> OSError: [Errno 2] No such file or directory: '/opt/postgres/archive/
> 10.100.101.150'

Did you see this message?
--
Devrim GÜNDÜZ, RHCE
Command Prompt - http://www.CommandPrompt.com
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org  Twitter: http://twitter.com/devrimgunduz

On Wed, 2009-11-25 at 17:24 -0500, akp geek wrote:
> 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.

> 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

Did you run cmd_archiver -I ?

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

On Fri, Nov 27, 2009 at 14:19, akp geek <akpgeek@gmail.com> wrote:

[...]
> TypeError: iteration over non-sequence

> I am not able to interpret any thing from the above message. Can you please
> give me some thoughts

I can't say anything about the application itself, but the cryptic
message means that the variable "filenames" is expected to be a
sequenced typed variable. A sequence in Python is a string, a list or
a tuple. To get the above error message requires the variable to be
something else, like an integer or something. One possible cause for
the problem is a configuration error. Perhaps a line contains a
non-string, as in foo = bar, instead of foo = "bar".

But again, I don't know about the application so I cannot give any
better guess, but the above is what the error is about.


--
- Rikard - http://bos.hack.org/cv/