From: | Hellmuth Vargas <hivs77(at)gmail(dot)com> |
---|---|
To: | Martín Marqués <martin(dot)marques(at)gmail(dot)com> |
Cc: | Lista Postgres ES <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: problemas replica 9.4 con slot |
Date: | 2015-12-16 14:38:25 |
Message-ID: | CAN3Qy4qAaRE1p-v6BbQaz1fXcdU-0fP55i4mawwdXyHqbZLiMA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola Martin
Muchas gracias por responder, verifique la replica y no tiene configurados
slot:
postgres=# select * from pg_replication_slots
postgres-# ;
slot_name | plugin | slot_type | datoid | database | active | xmin |
catalog_xm
in | restart_lsn
-----------+--------+-----------+--------+----------+--------+------+-----------
---+-------------
(0 rows)
postgres=# select * from pg_stat_replication;
pid | usesysid | usename | application_name | client_addr |
client_hostname | c
lient_port | backend_start | backend_xmin | state | sent_location |
write_locati
on | flush_location | replay_location | sync_priority | sync_state
-----+----------+---------+------------------+-------------+-----------------+--
-----------+---------------+--------------+-------+---------------+-------------
---+----------------+-----------------+---------------+------------
(0 rows)
mmm por el momento voy a desactivar los slot y continuare con archive
y wal_keep_segments
El 16 de diciembre de 2015, 08:15, Martín Marqués<martin(dot)marques(at)gmail(dot)com>
escribió:
> Buenas,
>
> El día 9 de diciembre de 2015, 13:57, Hellmuth Vargas
> <hivs77(at)gmail(dot)com> escribió:
> >
> >
> > master:
> >
> > [postgres(at)bd-1 data]# du -h pg_xlog/
> > 4,0K pg_xlog/archive_status
> > 1,8G pg_xlog/
> >
> >
> > replica retrasada sin motivo:
> >
> > bash-4.1$ du -h pg_xlog
> > 512K pg_xlog/archive_status
> > 137G pg_xlog
>
> Revisa el archive_status, y si no tenes algun slot en el standy.
>
> --
> Martín Marqués
> select 'martin.marques' || '@' || 'gmail.com'
> DBA, Programador, Administrador
>
--
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
From | Date | Subject | |
---|---|---|---|
Next Message | Gilberto Castillo | 2015-12-16 14:44:41 | Re: [MASSMAIL]Re: postgresql vmware |
Previous Message | FRANCISCO JOSE PALAO VILLANUEVA | 2015-12-16 14:31:45 | Re: postgresql vmware |