Re: Synch Replication

Hi,

Now, the active and standby database are up & running even after the
execution of the SQL (create table). What was the problem?

But when I logged in the standby instance by executing 'psql -d
replication', I did not see the table that was created on the primary.
I have few questions:

- I'am not sure whether the replication is done but I'am not able to
view? Will I be able to view the replication by logging inside to
standby instance? Hotstandby patch will allow to read from standby. Is
this patch integrated in sync replication patch?

- I brought down the active instance by executing 'pg_ctl -D
/home/postgres/postgresHSB/actdata stop' hoping that trigger file will
enable failover. But I was not able to login to standby instance. Not
sure why?

regards,
Niranjan

> -----Original Message-----
> From: ext Fujii Masao [mailto:masao(dot)fujii(at)gmail(dot)com]
> Sent: Monday, February 09, 2009 7:53 AM
> To: K, Niranjan (NSN - IN/Bangalore)
> Cc: PostgreSQL-development
> Subject: Re: Synch Replication
>
> Hi Niranjan,
>
> On Fri, Feb 6, 2009 at 10:17 PM, K, Niranjan (NSN -
> IN/Bangalore) <niranjan(dot)k(at)nsn(dot)com> wrote:
> >
> > Hi,
> >
> >> * server log
> >> * <installation_directory>/sbydata/walreceiver_trace.out
> >> * tcpdump -i lo -n tcp
> >>
> > Please refer attachments.
>
> Please try the updated synch-rep, which probably fixes the
> problem, I hope.
> If the same trouble was reproduced, please report the logs.
>
> http://senduit.com/c21db5
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source
> Software Center
>