Re: pg_dump does not include triggers - should it?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump does not include triggers - should it?
Date: 2011-11-16 23:45:25
Message-ID: 24063.1321487125@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com> writes:
> We just noticed our pg_dumps (generated with
> "pg_dump -Fc -n public $our_db_name") does not
> include triggers on tables in database $our_db_name.

-n restricts the dump to objects in the named schema. It's impossible
to evaluate whether there is an issue here, since you have not told us
whether the trigger functions or the tables you are wondering about
are in that schema. In general, though, you should expect that
restricting the dump leads to an incomplete dump ...

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-11-17 00:02:11 Re: How could I find the last modified procedure in the database?
Previous Message David Johnston 2011-11-16 23:33:57 Re: insert locking issue for PG 9.0