Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
titlePromote slave to master
linenumberstrue
root@pgsql1:~# touch /var/lib/postgresql/13/main/triggerfile
#root@pgsql1:~# sudo -u postgres -i psql
postgres=# ALTER SYSTEM RESET primary_conninfo;
ALTER SYSTEM
postgres=# ALTER SYSTEM RESET promote_trigger_file;
ALTER SYSTEM
postgres=# SELECT pg_reload_conf();
 pg_reload_conf 
----------------
 t
(1 row)

...