Re: [GENERAL] WAL shipping question

2007-12-06 Thread Alvaro Herrera
SHARMILA JOTHIRAJAH wrote: > How do you install pg_standby. I get the following error when i try the > Makefile > > [EMAIL PROTECTED]:~/postgres8.3/pgsql> > /export/home/sj/postgresql-8.3beta3/contrib/pg_standby/Makefile The Makefile is not a shell script. Run just "make" and then "make insta

Re: [GENERAL] WAL shipping question

2007-12-06 Thread SHARMILA JOTHIRAJAH
>The main thing that's improved in 8.3 is the integration of pg_standby as >a more rugged restore_command than most people were coding on their own: >http://www.postgresql.org/docs/8.3/static/pgstandby.html >You should use it instead of the example restore.sh included in the >message I refe

Re: [GENERAL] WAL shipping question

2007-12-05 Thread Greg Smith
On Wed, 5 Dec 2007, SHARMILA JOTHIRAJAH wrote: I see the archive directory in standby server getting filled up, but there are no log messages generated. Whay? What am I missing here? If you're using pg_standby, you can pass it -d to have it log more information about what's going on, which ma

Re: [GENERAL] WAL shipping question

2007-12-05 Thread Erik Jones
On Dec 5, 2007, at 1:39 PM, SHARMILA JOTHIRAJAH wrote: > This basically archives the data in the primary server itself...right!!! > But how can I set up continuous archiving from primary to a directory > (WAL archive directory) on the stand-by server ? >>The closest thing to a worked out

Re: [GENERAL] WAL shipping question

2007-12-05 Thread SHARMILA JOTHIRAJAH
> This basically archives the data in the primary server itself...right!!! > But how can I set up continuous archiving from primary to a directory > (WAL archive directory) on the stand-by server ? >>The closest thing to a worked out example of how to do this I'm aware of >>is at http://ar

Re: [GENERAL] WAL shipping question

2007-12-04 Thread SHARMILA JOTHIRAJAH
> This basically archives the data in the primary server itself...right!!! > But how can I set up continuous archiving from primary to a directory > (WAL archive directory) on the stand-by server ? The closest thing to a worked out example of how to do this I'm aware of is at http://archive

Re: [GENERAL] WAL shipping question

2007-12-04 Thread Greg Smith
On Tue, 4 Dec 2007, SHARMILA JOTHIRAJAH wrote: This basically archives the data in the primary server itself...right!!! But how can I set up continuous archiving from primary to a directory (WAL archive directory) on the stand-by server ? The closest thing to a worked out example of how to do

Re: [GENERAL] WAL shipping question

2007-12-04 Thread Richard Huxton
SHARMILA JOTHIRAJAH wrote: Im trying to play a bit with log shipping between 2 servers primary and standby. These servers are running versions 8.3betat3. I had set up continuous archiving at the primary server. The manuals' example of archive_command is archive_command = 'cp -i %p /mnt/serve

Re: [GENERAL] WAL shipping question

2007-12-04 Thread SHARMILA JOTHIRAJAH
> Im trying to play a bit with log shipping between 2 servers primary and standby. These servers are running versions 8.3betat3. I had set up continuous archiving at the primary server. The manuals' example of archive_command is > archive_command = 'cp -i %p /mnt/server/archivedir/%f > This b

Re: [GENERAL] WAL shipping question

2007-12-04 Thread Richard Huxton
SHARMILA JOTHIRAJAH wrote: Hi, Im trying to play a bit with log shipping between 2 servers primary and standby. These servers are running versions 8.3betat3. I had set up continuous archiving at the primary server. The manuals' example of archive_command is archive_command = 'cp -i %p /mnt/serv