Re: How do I exclude a schema , a function and a table from pg_backup

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

In response to

Browse pgsql-admin by date

  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