pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Poul Kristensen <bcc5226@gmail.com>
Cc: Scott Mead <scottm@openscg.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Date: Wed, 26 Oct 2016 09:39:23 -0400
Message-ID: <17712.1477489163@sss.pgh.pa.us> (raw)
In-Reply-To: <CAAOuvVoMpaXNm32n=3QHG2vdmMfCMpeWFx=YzCJF8bAu_h1VLw@mail.gmail.com>
References: <CAAOuvVq+_UNO2su0eEzKSQsZzVqZ2MaXqo=nceGB1VFgh8Z5CQ@mail.gmail.com>
	<CAAD=pwEvuFc513-yrqxb6d9m4rw1Yzh4Xg4AW317aTWOynzBiA@mail.gmail.com>
	<CAAOuvVp5pck9C6x7ycvBnbkx6nW_cZce1gOeWURuDT-4fdquPw@mail.gmail.com>
	<CAAOuvVpAGBfDXtkg5ChVgHAw6Drt4+Z4B5ejV7+HOJ=O13uxwQ@mail.gmail.com>
	<CAKq0gvJwjMD28XFPrzCf-XD0GBYmYwH8X6dCOuCcsN5fSfY1iw@mail.gmail.com>
	<CAAOuvVqm1m=n0OUfypxQBeKsTtvgg-0H3BbQFq3dQE=7VOm7sA@mail.gmail.com>
	<CAAOuvVpXUfvNYNzutqAd4udpAUOA6ekZ=MnqcBRV+-=ZvFc_mw@mail.gmail.com>
	<CAAOuvVoGURYNASEbxgftWUwefDkrrPUwwEWbR4vmYDXjG=dJUQ@mail.gmail.com>
	<CAAOuvVpnHRN0xqjPp6xOWu=x+XE+dMfFB74oM54-JAJX7_Byvg@mail.gmail.com>
	<CAAOuvVoZofQj+3w5cz0Jwgue_6HdSa5geCYUX-0H3pWZ=YyHXg@mail.gmail.com>
	<16413.1477487449@sss.pgh.pa.us>
	<CAAOuvVoMpaXNm32n=3QHG2vdmMfCMpeWFx=YzCJF8bAu_h1VLw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

Poul Kristensen <bcc5226@gmail.com> writes:
> It  IS the standby server:
> Result of pg_isready:

> /usr/pgsql-9.6/bin/pg_isready -h /tmp -p 5432
> /tmp:5432 - rejecting connections

Hm, you do have hot_standby turned on in its postgresql.conf?

			regards, tom lane


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



view thread (16+ messages)  latest in thread

Message-ID: <17712.1477489163@sss.pgh.pa.us>
Permalink:  ../17712.1477489163@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/17712.1477489163@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, bcc5226@gmail.com, scottm@openscg.com
  Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  In-Reply-To: <17712.1477489163@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox