Sample Header Ad - 728x90

pg_dump --exclude-table not working on one specific table

1 vote
2 answers
6334 views
Wanting to exclude a few very large table in a pg_dump, I use the -T option multiple times, like this: pg_dump --clean clientportal -T article_plain -T callstats -T cdrviewer_cdr -T calls -T cdrviewer_datasource -T django_sesssion -T django_admin_log article_plain however still gets included in the dump. Using --schema-only here for demonstration purposes: postgres@server:~/bin$ pg_dump -s --clean clientportal -T article_plain -T callstats -T cdrviewer_cdr -T calls -T cdrviewer_datasource -T django_sesssion -T django_admin_log | grep article_plain ALTER TABLE ONLY otrs.article_plain DROP CONSTRAINT fk_article_plain_create_by_id; ALTER TABLE ONLY otrs.article_plain DROP CONSTRAINT fk_article_plain_change_by_id; ALTER TABLE ONLY otrs.article_plain DROP CONSTRAINT fk_article_plain_article_id_id; DROP INDEX otrs.article_plain_article_id; ALTER TABLE ONLY otrs.article_plain DROP CONSTRAINT article_plain_pkey; ALTER TABLE otrs.article_plain ALTER COLUMN id DROP DEFAULT; DROP SEQUENCE otrs.article_plain_id_seq; DROP TABLE otrs.article_plain; -- Name: article_plain; Type: TABLE; Schema: otrs; Owner: sg1admin CREATE TABLE article_plain ( <----- there is article_plain ALTER TABLE article_plain OWNER TO sg1admin; ... Why is that?
Asked by Julien Lamarche (131 rep)
May 13, 2021, 06:11 PM
Last activity: Jun 25, 2024, 05:19 PM