Re: Synch Replication

Hi,

Thanks. Now it works.

Few questions:
1) Do you have an idea by when the Hot standby patch and Sync
replication patch will be integrated?
2) I have used 1 physical machine to try current patch of synchronous
replication. Is it OK for me to try with 2 separate machines for Primary
& Standby servers
3) Do you have test programs that can used for synchronous replication
testing?
4) I'am thinking of trying load/performance tests as well. What do you
feel? Will it be too early to do this test?

regards,
Niranjan

> -----Original Message-----
> From: ext Fujii Masao [mailto:masao(dot)fujii(at)gmail(dot)com]
> Sent: Monday, February 09, 2009 7:47 PM
> To: K, Niranjan (NSN - IN/Bangalore)
> Cc: PostgreSQL-development
> Subject: Re: Synch Replication
>
> Hi Niranjan,
>
> On Mon, Feb 9, 2009 at 10:39 PM, K, Niranjan (NSN -
> IN/Bangalore) <niranjan(dot)k(at)nsn(dot)com> wrote:
> > But after I login to replication database (note the active I had
> > brought it down earlier & created a finish.trigger), I still cannot
> > see the table that was created on the primary.
> > Also please note that the LSN had changed after replication
> in the ps
> > command.
>
> Did you create the table in 'replication' database? If not,
> please connect to the correct database which includes the table.
> In log-shipping, the database objects are basically identical
> between the primary and the standby server.
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source
> Software Center
>