Re: PostgresSQL 9.5 and systemd autorestart but without replication.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
From: Poul Kristensen <bcc5226@xxxxxxxxx>
Date: Wed, 26 Oct 2016 17:11:22 +0200
Cc: Scott Mead <scottm@xxxxxxxxxxx>, pgsql-admin@xxxxxxxxxxxxxx
In-reply-to: <17712.1477489163@sss.pgh.pa.us>
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> <17712.1477489163@sss.pgh.pa.us>

No, it is turned off.

Nothing in the "standby section" in postgresql.conf is turned on.

Thanks.

Poul

2016-10-26 15:39 GMT+02:00 Tom Lane <tgl@xxxxxxxxxxxxx>:

Poul Kristensen <bcc5226@xxxxxxxxx> 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

Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

Follow-Ups:
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Tom Lane

References:
- PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Hunley, Douglas
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Scott Mead
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Tom Lane
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Poul Kristensen
- Re: PostgresSQL 9.5 and systemd autorestart but without replication.
  - From: Tom Lane

Prev by Date: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Next by Date: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Previous by thread: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Next by thread: Re: PostgresSQL 9.5 and systemd autorestart but without replication.
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]