Postgres Pro
Downloads
Home   >   mailing lists

Re: URGENT issue: pg-xlog growing on master! - Mailing list pgsql-performance

From bricklen
Subject Re: URGENT issue: pg-xlog growing on master!
Date
Msg-id CAGrpgQ9mc+jwqj_ZK4MCFmx7RaSifdPDsCRaw0qT=bG0RTLMVg@mail.gmail.com
Whole thread Raw
In response to URGENT issue: pg-xlog growing on master!  (Niels Kristian Schjødt <nielskristian@autouncle.com>)
Responses Re: URGENT issue: pg-xlog growing on master!
List pgsql-performance
Tree view
On Mon, Jun 10, 2013 at 4:29 AM, Niels Kristian Schjødt <nielskristian@autouncle.com> wrote:

2013-06-10 11:21:45 GMT FATAL:  could not connect to the primary server: could not connect to server: No route to host
                Is the server running on host "192.168.0.4" and accepting
                TCP/IP connections on port 5432?

Did anything get changed on the standby or master around the time this message started occurring?
On the master, what do the following show?
show port;
show listen_addresses;

The master's IP is still 192.168.0.4?

Have you tried connecting to the master using something like:
psql -h 192.168.0.4 -p 5432 -U postgres -d postgres
 
Does that throw a useful error or warning?

pgsql-performance by date:

Previous
From: Ghislain ROUVIGNAC
Date:
Subject: Re: Not same plan between static and prepared query
Next
From: Niels Kristian Schjødt
Date:
Subject: Re: URGENT issue: pg-xlog growing on master!