Re: Help setting up warm standby replication

From: Nico Sabbi <nsabbi(at)officinedigitali(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Help setting up warm standby replication
Date: 2007-04-16 15:23:46
Message-ID: 46239502.90706@officinedigitali.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Nico Sabbi wrote:

> Merlin Moncure wrote:
>
>>
>>
>> try link mode, not copy mode (-l). make sure you read about the -k
>> switch.
>>
>> merlin
>>
> replaced -c with -l, but the result was the same.
> I assume that with -k you mean the socket dir for postgres - since
> pg_standby doesn't
> seek to recognize that switch - but I didn't need it: I connected to
> -p 5433.
>
> Anyway, after having stopped the replication I had the same problem;
> in order to make the slave start I had to manually copy the log files
> from the
> archive to pg_xlog/ .
>
> Is pg_standby supposed to work with Postgres 8.2 ? or only with 8.1.?
>
>
update: touching the right trigger makes the replication stop, thus I
can connect to the server
and see the updated data.
Thanks a lot,
Nico

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2007-04-16 15:27:07 Re: autovacuum vacuums entire database...is this right?
Previous Message Tom Lane 2007-04-16 15:15:20 Re: Dump & restore required for x86 -> EM64T?