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
Last activity: Jun 25, 2024, 05:19 PM