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
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? |