Re: Synch Replication - Mailing list pgsql-hackers

From Fujii Masao
Subject Re: Synch Replication
Date
Msg-id 3f0b79eb0902090616v25ca39c4m6d6262f986c04f9c@mail.gmail.com
Whole thread Raw
In response to Synch Replication - Synch rep 0114  ("Patil, Smita (NSN - IN/Bangalore)" <smita.patil@nsn.com>)
Responses Re: Synch Replication
Synch Replication: Synchronization of files between Primary & Standby
List pgsql-hackers
Hi Niranjan,

On Mon, Feb 9, 2009 at 10:39 PM, K, Niranjan (NSN - IN/Bangalore)
<niranjan.k@nsn.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


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS
Next
From: Amit Gupta
Date:
Subject: Re: Table Partitioning Feature