Postgres Pro
Downloads
Home   >   mailing lists

How do I exclude a schema , a function and a table from pg_backup - Mailing list pgsql-admin

From pavna
Subject How do I exclude a schema , a function and a table from pg_backup
Date
Msg-id 1531449066819-0.post@n3.nabble.com
Whole thread Raw
Responses Re: How do I exclude a schema , a function and a table from pg_backup  (David Ghedini <david@davidghedini.com>)
List pgsql-admin
Tree view 
I need to exclude a schema, few tables and functions defined in public
schema. How do i exclude them from the backup ? I know how to exclude schema
and tables. is there a way to exclude 1 or more functions?


sudo -u postgres  pg_dump -Fc -exclude-schema=schema1 --exclude-table=table1
--disable-triggers -f DB.dump database1



--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

pgsql-admin by date:

Previous
From: Mario de Frutos Dieguez
Date:
Subject: Re: row is too big: size 8168, maximum size 8160
Next
From: David Ghedini
Date:
Subject: Re: How do I exclude a schema , a function and a table from pg_backup