Re: Synch Replication - Mailing list pgsql-hackers

From K, Niranjan (NSN - IN/Bangalore)
Subject Re: Synch Replication
Date
Msg-id 39C6C93FC1236641B94D3648B96E3BE70299302C@inbhexc001.nsn-intra.net
Whole thread Raw
In response to Re: Synch Replication  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Hi,

> [postgres@node1 ~]$ psql -d replication
> psql: could not connect to server: No such file or directory
>         Is the server running locally and accepting
>                 connections on Unix domain socket
> "/tmp/.s.PGSQL.5432"?
> ---------------------------
>
> I think that your standby postmaster is running under port =
> 5433, so please specify "-p 5433".

It was silly that I missed this. :-(

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.

I have attached the logs.

regards,
Niranjan

Attachment

pgsql-hackers by date:

Previous
From: "K, Niranjan (NSN - IN/Bangalore)"
Date:
Subject: Re: Synch Replication
Next
From: Tom Lane
Date:
Subject: Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS