Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication.
| От | Euler Taveira |
|---|---|
| Тема | Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication. |
| Дата | |
| Msg-id | CAHE3wggJkMEOUQ-=qGM0xaCTTqLd-mP7AuAUS0hLz5bHUfNn2Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] pg_dump ignoring information_schema tables which usedin Create Publication. (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
| Ответы |
[HACKERS] Re: pg_dump ignoring information_schema tables which used in CreatePublication.
|
| Список | pgsql-hackers |
2017-05-26 17:52 GMT-03:00 Peter Eisentraut <peter.eisentraut@2ndquadrant.com>:
You cannot publish a system catalog. But a user-created table in
information_schema is not a system catalog.
Replication of information_schema tables works. However, pg_dump doesn't include information_schema tables into CREATE PUBLICATION command (user-defined information_schema tables aren't included in pg_dump even *before* logical replication). IMO allow publish/subscribe of tables into information_schema is harmless (they aren't special tables like catalogs). Also, how many people would create real tables into information_schema? Almost zero. Let's leave it alone. Since pg_dump doesn't document that information_schema isn't dumped, I think we shouldn't document this for logical replication.
--
Euler Taveira Timbira - http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
В списке pgsql-hackers по дате отправления: