| 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: | Whole Thread | Raw Message | 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 |