Re: problema para sustituir una master con una replica

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 (
alvherre(at)2ndquadrant(dot)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