pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow do I exclude a schema , a function and a table from pg_backup
2+ messages / 2 participants
[nested] [flat]
* How do I exclude a schema , a function and a table from pg_backup
@ 2018-07-13 02:31 pavna <daryani.bhawna@gmail.com>
2018-07-13 11:38 ` Re: How do I exclude a schema , a function and a table from pg_backup David Ghedini <david@davidghedini.com>
0 siblings, 1 reply; 2+ messages in thread
From: pavna @ 2018-07-13 02:31 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How do I exclude a schema , a function and a table from pg_backup
2018-07-13 02:31 How do I exclude a schema , a function and a table from pg_backup pavna <daryani.bhawna@gmail.com>
@ 2018-07-13 11:38 ` David Ghedini <david@davidghedini.com>
0 siblings, 0 replies; 2+ messages in thread
From: David Ghedini @ 2018-07-13 11:38 UTC (permalink / raw)
To: pavna <daryani.bhawna@gmail.com>; +Cc: pgsql-admin
--exclude-schema and --exclude-table for the function, you can place into
schema and exclude it.
On Fri, Jul 13, 2018 at 5:31 AM, pavna <daryani.bhawna@gmail.com> wrote:
> 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
>
>
--
Kind regards,
David Ghedini
*http://www.davidghedini.com* <http://www.davidghedini.com;
http://uk.linkedin.com/in/davidghedini
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2018-07-13 11:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2018-07-13 02:31 How do I exclude a schema , a function and a table from pg_backup pavna <daryani.bhawna@gmail.com>
2018-07-13 11:38 ` David Ghedini <david@davidghedini.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox