| 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 |