Search Postgresql Archives

Re: Looking for some help with HA / Log Log-Shipping

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> 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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux