From: | Fabrízio de Royes Mello <fabrizio(at)timbira(dot)com(dot)br> |
---|---|
To: | PegoraroF10 <marcos(at)f10(dot)com(dot)br> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Refresh Publication takes hours and doesn´t finish |
Date: | 2019-05-21 17:27:01 |
Message-ID: | CAPfkCSDB-vfYyJmmTgoQvJ=-J2n4DAhWMPDb3d5V2FTpKWb5Gg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Em ter, 21 de mai de 2019 às 14:17, PegoraroF10 <marcos(at)f10(dot)com(dot)br>
escreveu:
>
> Restart Postgres means exactly what ? We tried just restart the service
but
> we tried to refresh publication the old view was used because it took
2hours
> and gave us a timeout.
>
As I said before to change system catalog you should set
"allow_system_table_mods=on" and restart PostgreSQL service.
After that you'll able to recreate the "pg_catalog.pg_publication_tables"
system view. (You can use the Tom's suggestion using LATERAL)
Regards,
--
Fabrízio de Royes Mello Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
From | Date | Subject | |
---|---|---|---|
Next Message | Rich Shepard | 2019-05-21 17:27:12 | Re: Bulk inserts into two (related) tables |
Previous Message | Adrian Klaver | 2019-05-21 17:25:44 | Re: Bulk inserts into two (related) tables |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2019-05-21 17:38:57 | Re: New EXPLAIN option: ALL |
Previous Message | Andres Freund | 2019-05-21 17:17:53 | Re: POC: Cleaning up orphaned files using undo logs |