From: amit@parascadd.com
To: pgsql-admin@postgresql.org
Subject: RE: [HELP] Issue with standby server using WAL archive
Date: Fri, 3 Jul 2020 11:40:06 +0530
Message-ID: <00b301d65100$9a9627b0$cfc27710$@parascadd.com> (raw)
In-Reply-To: <20200702152608.GQ3125@tamriel.snowman.net>
References: <CANSiNp6iAACN_4HjHUqFEmTOd_0QvdBiE5W1XXjwFniNwUWAYQ@mail.gmail.com>
<20200702141444.GJ3125@tamriel.snowman.net>
<CANSiNp6y1tm08Z=mDj6RL33iUjM1ozw6DtKY7Dz6FofxLvFNqA@mail.gmail.com>
<20200702152608.GQ3125@tamriel.snowman.net>
I do not wish to get emails from these. Kindly remove me from mailing list.
-----Original Message-----
From: Stephen Frost <sfrost@snowman.net>
Sent: 02 July 2020 20:56
To: Praveen Kumar K S <praveenssit@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: [HELP] Issue with standby server using WAL archive
Greetings,
* Praveen Kumar K S (praveenssit@gmail.com) wrote:
> I'm using 9.6
That's quite old- I'd strongly recommend that you look at using a newer
version.
> I have 3 servers. Let us call it pg1,pg2,pg3
>
> pg1 is master
> pg2 is hot stand by
> pg3 is a DR server which doesn't serve any requests. hot_standby is
> not enabled in postgresql.conf on DR server.
If hot_standby isn't enable then you won't be able to connect- which is
entirely fine, but if that's what you want then I'm not sure what the error
is that you're concerned about..?
> pg1 and pg2 are in the same network and are in sync.
Ok. Note that having only one replica when you're using syncronous
replication will lead to a situation where, if either node fails, the
database system won't accept writes.
> I followed official documentation and used the cp command. Are there
> any other best approaches ?
The documentation provides an example of how to use the command, using 'cp'
isn't actually recommended. I'd strongly suggest you look at proper
backup/archiving solutions for PostgreSQL like pgbackrest to use instead.
Thanks,
Stephen
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: amit@parascadd.com
Subject: RE: [HELP] Issue with standby server using WAL archive
In-Reply-To: <00b301d65100$9a9627b0$cfc27710$@parascadd.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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