Re: Help setting up warm standby replication - Mailing list pgsql-general

From Nico Sabbi
Subject Re: Help setting up warm standby replication
Date
Msg-id 46239502.90706@officinedigitali.it
Whole thread Raw
In response to Re: Help setting up warm standby replication  (Nico Sabbi <nsabbi@officinedigitali.it>)
List 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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Dump & restore required for x86 -> EM64T?
Next
From: Chris Browne
Date:
Subject: Re: autovacuum vacuums entire database...is this right?