pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedrecovery.conf
7+ messages / 4 participants
[nested] [flat]
* recovery.conf
@ 2016-09-05 09:50 Poul Kristensen <bcc5226@gmail.com>
2016-09-05 10:08 ` Re: recovery.conf Simon Riggs <simon@2ndquadrant.com>
2016-09-05 12:24 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 2 replies; 7+ messages in thread
From: Poul Kristensen @ 2016-09-05 09:50 UTC (permalink / raw)
To: pgsql-admin
It is not obvious to me what is the minimum configuration of the
recovery.conf?
The online manuals does not give the exact minumum.
Can anyone help?
Thanks.
--
Med venlig hilsen / Best regards
Poul Kristensen
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
@ 2016-09-05 10:08 ` Simon Riggs <simon@2ndquadrant.com>
1 sibling, 0 replies; 7+ messages in thread
From: Simon Riggs @ 2016-09-05 10:08 UTC (permalink / raw)
To: Poul Kristensen <bcc5226@gmail.com>; +Cc: pgsql-admin
On 5 September 2016 at 10:50, Poul Kristensen <bcc5226@gmail.com> wrote:
> It is not obvious to me what is the minimum configuration of the
> recovery.conf?
>
> The online manuals does not give the exact minumum.
>
> Can anyone help?
The docs are written to describe how to setup various use cases.
The minimal config varies depending on what you are trying to achieve.
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
@ 2016-09-05 12:24 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-06 08:41 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
1 sibling, 1 reply; 7+ messages in thread
From: Albe Laurenz @ 2016-09-05 12:24 UTC (permalink / raw)
To: 'Poul Kristensen *EXTERN*' <bcc5226@gmail.com>; pgsql-admin
Poul Kristensen wrote:
> It is not obvious to me what is the minimum configuration of the recovery.conf?
>
> The online manuals does not give the exact minumum.
>
> Can anyone help?
None of the settings in recovery.conf must be specified.
One that you will almost always have for recovery is "restore_command", but if all
the WAL you need is in pg_xlog, you don't have to specify that either.
And you don't need it for streaming replication.
Some settings are necessary for point-in-time-recovery, and some
for streaming replication, which are two different use cases for the same recovery mechanism.
Maybe that's what's confusing you.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-05 12:24 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
@ 2016-09-06 08:41 ` Poul Kristensen <bcc5226@gmail.com>
2016-09-06 09:53 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-23 01:51 ` Re: recovery.conf Bruce Momjian <bruce@momjian.us>
0 siblings, 2 replies; 7+ messages in thread
From: Poul Kristensen @ 2016-09-06 08:41 UTC (permalink / raw)
To: Albe Laurenz <laurenz.albe@wien.gv.at>; +Cc: pgsql-admin
Thanks a lot for fast responce.
Do you have any idea of why PostgreSQL don't use cluster like normally used
e.g
One common disk for both master and nodes?
Thanks.
Poul
2016-09-05 14:24 GMT+02:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
> Poul Kristensen wrote:
> > It is not obvious to me what is the minimum configuration of the
> recovery.conf?
> >
> > The online manuals does not give the exact minumum.
> >
> > Can anyone help?
>
> None of the settings in recovery.conf must be specified.
>
> One that you will almost always have for recovery is "restore_command",
> but if all
> the WAL you need is in pg_xlog, you don't have to specify that either.
> And you don't need it for streaming replication.
>
> Some settings are necessary for point-in-time-recovery, and some
> for streaming replication, which are two different use cases for the same
> recovery mechanism.
> Maybe that's what's confusing you.
>
> Yours,
> Laurenz Albe
>
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-05 12:24 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-06 08:41 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
@ 2016-09-06 09:53 ` Poul Kristensen <bcc5226@gmail.com>
2016-09-06 12:13 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
1 sibling, 1 reply; 7+ messages in thread
From: Poul Kristensen @ 2016-09-06 09:53 UTC (permalink / raw)
To: ; +Cc: pgsql-admin
Sorry for asking a lot.
pg_replication_slots.
is this meant to be a slot like a ethernetcard and controller in a physical
server.
Thanks a lot.
/Poul
2016-09-06 10:41 GMT+02:00 Poul Kristensen <bcc5226@gmail.com>:
> Thanks a lot for fast responce.
>
> Do you have any idea of why PostgreSQL don't use cluster like normally
> used e.g
> One common disk for both master and nodes?
>
> Thanks.
>
> Poul
>
> 2016-09-05 14:24 GMT+02:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
>
>> Poul Kristensen wrote:
>> > It is not obvious to me what is the minimum configuration of the
>> recovery.conf?
>> >
>> > The online manuals does not give the exact minumum.
>> >
>> > Can anyone help?
>>
>> None of the settings in recovery.conf must be specified.
>>
>> One that you will almost always have for recovery is "restore_command",
>> but if all
>> the WAL you need is in pg_xlog, you don't have to specify that either.
>> And you don't need it for streaming replication.
>>
>> Some settings are necessary for point-in-time-recovery, and some
>> for streaming replication, which are two different use cases for the same
>> recovery mechanism.
>> Maybe that's what's confusing you.
>>
>> Yours,
>> Laurenz Albe
>>
>
>
>
> --
> Med venlig hilsen / Best regards
> Poul Kristensen
> Linux-OS/Virtualizationexpert and Oracle DBA
>
--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-05 12:24 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-06 08:41 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-06 09:53 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
@ 2016-09-06 12:13 ` Albe Laurenz <laurenz.albe@wien.gv.at>
0 siblings, 0 replies; 7+ messages in thread
From: Albe Laurenz @ 2016-09-06 12:13 UTC (permalink / raw)
To: 'Poul Kristensen *EXTERN*' <bcc5226@gmail.com>; +Cc: pgsql-admin
Poul Kristensen wrote:
> Sorry for asking a lot.
>
> pg_replication_slots.
>
> is this meant to be a slot like a ethernetcard and controller in a physical server.
No, it is a data structure with which the PostgreSQL replication master can keep track how
far behind a replication slave is.
That way it can avoid discarding WAL that is needed by to replication slave to catch up.
Yours,
Laurenz Albe
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: recovery.conf
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-05 12:24 ` Re: recovery.conf Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-06 08:41 ` Re: recovery.conf Poul Kristensen <bcc5226@gmail.com>
@ 2016-09-23 01:51 ` Bruce Momjian <bruce@momjian.us>
1 sibling, 0 replies; 7+ messages in thread
From: Bruce Momjian @ 2016-09-23 01:51 UTC (permalink / raw)
To: Poul Kristensen <bcc5226@gmail.com>; +Cc: Albe Laurenz <laurenz.albe@wien.gv.at>; pgsql-admin
On Tue, Sep 6, 2016 at 10:41:39AM +0200, Poul Kristensen wrote:
> Thanks a lot for fast responce.
>
> Do you have any idea of why PostgreSQL don't use cluster like normally used
> e.g
> One common disk for both master and nodes?
You can read our opinion of that solution here:
https://www.postgresql.org/message-id/flat/ncotsa$lhg$1@pye-srv-01.telemetry.co.uk#ncotsa$lhg$1@pye-...
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2016-09-23 01:51 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2016-09-05 09:50 recovery.conf Poul Kristensen <bcc5226@gmail.com>
2016-09-05 10:08 ` Simon Riggs <simon@2ndquadrant.com>
2016-09-05 12:24 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-06 08:41 ` Poul Kristensen <bcc5226@gmail.com>
2016-09-06 09:53 ` Poul Kristensen <bcc5226@gmail.com>
2016-09-06 12:13 ` Albe Laurenz <laurenz.albe@wien.gv.at>
2016-09-23 01:51 ` Bruce Momjian <bruce@momjian.us>
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