| From: | Laurent FAILLIE <l_faillie(at)yahoo(dot)com> |
|---|---|
| To: | Pgsql-general List <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Looking for some help with HA / Log Log-Shipping |
| Date: | 2021-03-31 15:38:58 |
| Message-ID: | 166716532.2578826.1617205138799@mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Replying to myself :)
It seems pg_basebackup did all the tricks, even restarting the slave. And it is in standby mode.Do I have anything to do in addition ?
Thanks
Le mercredi 31 mars 2021 à 12:51:29 UTC+2, Laurent FAILLIE <l_faillie(at)yahoo(dot)com> a écrit :
Hello,
We are running Postgresql 12 and I'm trying to put in place streaming wal replication.
I followed officiale documentation ( https://www.postgresql.org/docs/12/warm-standby.html ) as well as this tutorial :
https://scalegrid.io/blog/managing-high-availability-in-postgresql-part-1/
What I did is :
* created the master db* create replication role* updated postgresql.conf* finally replicate everything on the salve node using pg_basebackup (with -R option)
But now I'm lost with §26.2.4 Setting up a standby server.
In which file I have to put the primary_conninfo and other options ?
Thanks
Laurent
ps: my goal is to install the PAF
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Radoslav Nedyalkov | 2021-03-31 15:51:48 | standby fails with out-of-order XID insertion |
| Previous Message | Mohan Radhakrishnan | 2021-03-31 15:18:15 | Re: Primary keys and composite unique keys(basic question) |