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 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

In response to

Responses

Browse pgsql-hackers by date

  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