pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
4+ messages / 3 participants
[nested] [flat]
* PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
@ 2018-02-20 20:44 Telium Technical Support <support@telium.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Telium Technical Support @ 2018-02-20 20:44 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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)?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
@ 2018-02-20 21:44 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
parent: Telium Technical Support <support@telium.ca>
0 siblings, 1 reply; 4+ messages in thread
From: Peter Eisentraut @ 2018-02-20 21:44 UTC (permalink / raw)
To: Telium Technical Support <support@telium.ca>; pgsql-admin@lists.postgresql.org
On 2/20/18 15:44, Telium Technical Support wrote:
> 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)?
A lot has changed between 8.4 and 9.5. Hot standby, streaming
replication, replication slots, and so on. You can continue to use
pg_standby, but the new facilities are better in many ways.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
* RE: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
@ 2018-02-20 21:57 Telium Technical Support <support@telium.ca>
parent: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
0 siblings, 1 reply; 4+ messages in thread
From: Telium Technical Support @ 2018-02-20 21:57 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
I actually need the log shipping so I can decide whether or not I want the
standby to accept data from the master (In case of master corruption). I
have clients on ver 8.4 and 9.5 so I'm trying to figure out if I can share
config settings between clients.
-----Original Message-----
From: Peter Eisentraut [mailto:peter.eisentraut@2ndquadrant.com]
Sent: Tuesday, February 20, 2018 4:44 PM
To: Telium Technical Support <support@telium.ca>;
pgsql-admin@lists.postgresql.org
Subject: Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
On 2/20/18 15:44, Telium Technical Support wrote:
> 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)?
A lot has changed between 8.4 and 9.5. Hot standby, streaming replication,
replication slots, and so on. You can continue to use pg_standby, but the
new facilities are better in many ways.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
@ 2018-02-20 23:11 Jerry Sievers <gsievers19@comcast.net>
parent: Telium Technical Support <support@telium.ca>
0 siblings, 0 replies; 4+ messages in thread
From: Jerry Sievers @ 2018-02-20 23:11 UTC (permalink / raw)
To: Telium Technical Support <support@telium.ca>; +Cc: pgsql-admin@lists.postgresql.org
"Telium Technical Support" <support@telium.ca> writes:
> I actually need the log shipping so I can decide whether or not I want the
> standby to accept data from the master (In case of master corruption). I
> have clients on ver 8.4 and 9.5 so I'm trying to figure out if I can share
> config settings between clients.
Probably if your don't mind playing to the least version.
FYI that later versions such as 9.5 support a lag time as
recovery_min_apply_delay which might make unnecessary any external foo
to hold back WAL files till some ageing time.
>
> -----Original Message-----
> From: Peter Eisentraut [mailto:peter.eisentraut@2ndquadrant.com]
> Sent: Tuesday, February 20, 2018 4:44 PM
> To: Telium Technical Support <support@telium.ca>;
> pgsql-admin@lists.postgresql.org
> Subject: Re: PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5
>
> On 2/20/18 15:44, Telium Technical Support wrote:
>> 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)?
>
> A lot has changed between 8.4 and 9.5. Hot standby, streaming replication,
> replication slots, and so on. You can continue to use pg_standby, but the
> new facilities are better in many ways.
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2018-02-20 23:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-02-20 20:44 PostgreSQL recovery file syntax, ver 8.4 vs ver 9.5 Telium Technical Support <support@telium.ca>
2018-02-20 21:44 ` Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
2018-02-20 21:57 ` Telium Technical Support <support@telium.ca>
2018-02-20 23:11 ` Jerry Sievers <gsievers19@comcast.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox