Re: pg recovery

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.broccolo@2ndQuadrant.it | www.2ndQuadrant.it