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 13:39:49 |
Message-ID: | 39C6C93FC1236641B94D3648B96E3BE70299302C@inbhexc001.nsn-intra.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
> [postgres(at)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 | Content-Type | Size |
---|---|---|
walreceiver_trace.out | application/octet-stream | 21.0 KB |
postmaster.log | application/octet-stream | 251.8 KB |
standby_login.log | application/octet-stream | 162 bytes |
tcpdump.log | application/octet-stream | 5.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Mihai Criveti | 2009-02-09 14:06:50 | 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 | Martijn van Oosterhout | 2009-02-09 13:38:27 | Re: WIP: fix SET WITHOUT OIDS, add SET WITH OIDS |