PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5 - Mailing list pgsql-admin

From Telium Technical Support
Subject PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
Date
Msg-id 000301d3aa8b$a70c17c0$f5244740$@telium.ca
Whole thread Raw
Responses Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-admin

In postgreSQL version 8.4 it seems that you can place the db server into warm standby mode with the following setting in recovery.conf

 

    restore_command = 'pg_standby archiveDir %f %p %r'

 

In postgreSQL version 9.5 I see the same option, but I also see what appears to be an alternative syntax in recovery.conf:

 

   standby_mode = (boolean)

   trigger_file = (string)

 

So is this new syntax an alternative to the old syntax (both are accepted by PGSQL)? Any benefit to the new syntax?

Does the new syntax mean that I can use the restore_command setting as well (to use my own copy command)?

 

pgsql-admin by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Script to find out 'Page Corruption' and 'Fragmentation' inPostgreSQL.
Next
From: Peter Eisentraut
Date:
Subject: Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5