Re: pg recovery

Giuseppe Broccolo <giuseppe.broccolo@xxxxxxxxxxxxxx> · Thu, 11 Jul 2013 10:55:50 +0200



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