Re: Synch Replication

From: "K, Niranjan (NSN - IN/Bangalore)" <niranjan(dot)k(at)nsn(dot)com>
To: "ext Fujii Masao" <masao(dot)fujii(at)gmail(dot)com>
Cc: "PostgreSQL-development" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Synch Replication
Date: 2009-02-09 06:08:12
Message-ID: 39C6C93FC1236641B94D3648B96E3BE702992700@inbhexc001.nsn-intra.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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
>

Attachment Content-Type Size
postmaster.log application/octet-stream 295.0 KB
tcpdump.log application/octet-stream 4.6 KB
walreceiver_trace.out application/octet-stream 15.2 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mihai Criveti 2009-02-09 06:22:18 Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)
Previous Message Andrew Dunstan 2009-02-09 02:37:16 Re: 64 bit PostgreSQL 8.3.6 build on AIX 5300-09-02-0849 with IBM XL C/C++ 10.1.0.1 - initdb fails (could not dump unrecognized node type: 650)