Re: pg recovery

From: Giuseppe Broccolo <giuseppe(dot)broccolo(at)2ndquadrant(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg recovery
Date: 2013-07-11 08:55:50
Message-ID: 51DE7316.2040907@2ndquadrant.it
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Jayadevan,

Il 11/07/2013 09:39, Jayadevan M ha scritto:
>
> Hi,
>
> I have postgresql streaming replication set up. I forgot to add an
> entry for trigger_file in recovery.conf. So I added that entry and did
> a pg_ctl reload. Is there a way to confirm that the entry has been
> read by the server? Any view/function?
>

The only way to be sure that your configuration file is read is to stop
and restart the PostgreSQL service.

Regards,

Giuseppe.

--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe(dot)broccolo(at)2ndQuadrant(dot)it | www.2ndQuadrant.it

In response to

Browse pgsql-general by date

  From Date Subject
Next Message giozh 2013-07-11 09:01:05 function query error: column does not exist
Previous Message Michael Paquier 2013-07-11 08:30:14 Re: pg recovery