From: | David Ghedini <david(at)davidghedini(dot)com> |
---|---|
To: | pavna <daryani(dot)bhawna(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: How do I exclude a schema , a function and a table from pg_backup |
Date: | 2018-07-13 11:38:51 |
Message-ID: | CANtbSM255KASgjZfrVaQcVhE426ufT=2JotiaN8QnG5Ae8QDMQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)bhawna(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Debraj Manna | 2018-07-13 12:12:19 | Upgrade to postgres 10 - Postmaster not getting shutdown |
Previous Message | pavna | 2018-07-13 02:31:06 | How do I exclude a schema , a function and a table from pg_backup |