BUenas noches Alvaro Mil gracias por la respuesta, actualice la versión de PostgreSQL 9.5 al ultimo release disponible (9.5.23) y repeti el ejercicio con el mismo resultado :-(
bash-4.2$ /opt/test/PostgreSQL/9.5/bin/psql -U postgres -p 6432 postgres psql (9.5.23) Type "help" for help. postgres=# checkpoint; CHECKPOINT postgres=# postgres=# \q bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_controldata /opt/test/master/ | grep 'Latest checkpoint location' Latest checkpoint location: F/7F001058 bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_controldata /opt/test/replica1/ | grep 'Latest checkpoint location' Latest checkpoint location: F/7F000ED0 bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_controldata /opt/test/replica2/ | grep 'Latest checkpoint location' Latest checkpoint location: F/7F000ED0 bash-4.2$ #replica1 bash-4.2$ /opt/test/PostgreSQL/9.5/bin/psql -U postgres -p 7432 postgres psql (9.5.23) Type "help" for help. postgres=# checkpoint; CHECKPOINT postgres=# \q bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_controldata /opt/test/replica1/ | grep 'Latest checkpoint location' Latest checkpoint location: F/7F001058 #replica2 bash-4.2$ /opt/test/PostgreSQL/9.5/bin/psql -U postgres -p 8432 postgres psql (9.5.23) Type "help" for help. postgres=# checkpoint; CHECKPOINT postgres=# \q bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_controldata /opt/test/replica2/ | grep 'Latest checkpoint location' Latest checkpoint location: F/7F001058 bash-4.2$ bash-4.2$ # bajo master bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_ctl -D /opt/test/master/ stop -m fast waiting for server to shut down.... done server stopped bash-4.2$ # promuevo replica1 bash-4.2$ /opt/test/PostgreSQL/9.5/bin/pg_ctl -D /opt/test/replica1/ promote server promoting # log replica1 FATAL: could not connect to the primary server: could not connect to server: Conexión rehusada Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 6432? LOG: received promote request LOG: redo done at F/7F001100 LOG: selected new timeline ID: 3 LOG: archive recovery complete LOG: MultiXact member wraparound protections are now enabled LOG: database system is ready to accept connections LOG: autovacuum launcher started # log replica2 bash-4.2$ tail -f /opt/test/replica2/pg_log/postgresql-Thu.log LOG: invalid record length at F/7F001170 LOG: restarted WAL streaming at F/7F000000 on timeline 1 LOG: replication terminated by primary server DETAIL: End of WAL reached on timeline 1 at F/7F001170. LOG: restarted WAL streaming at F/7F000000 on timeline 1 LOG: replication terminated by primary server DETAIL: End of WAL reached on timeline 1 at F/7F001170. LOG: restarted WAL streaming at F/7F000000 on timeline 1 LOG: replication terminated by primary server DETAIL: End of WAL reached on timeline 1 at F/7F001170. LOG: restarted WAL streaming at F/7F000000 on timeline 1 LOG: replication terminated by primary server DETAIL: End of WAL reached on timeline 1 at F/7F001170. El jue., 20 de ago. de 2020 a la(s) 16:39, Alvaro Herrera ( alvhe...@2ndquadrant.com) escribió: > Hellmuth Vargas escribió: > > Hola lista tengo un PostgreSQL 9.5.9 > > 9.5.23 es lo más reciente. La cantidad de errores que puede haberse > corregido en todo ese tiempo (tres años menos ocho días) no quiero ni > pensarlo. Actualiza todo y prueba de nuevo; si persiste nos cuentas. > > -- > Álvaro Herrera https://www.2ndQuadrant.com/ > PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services > -- Cordialmente, Ing. Hellmuth I. Vargas S. Esp. Telemática y Negocios por Internet Oracle Database 10g Administrator Certified Associate EnterpriseDB Certified PostgreSQL 9.3 Associate