pg_dump does not include triggers - should it?

From: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Cc: Aleksey Tsalolikhin <atsaloli(dot)tech(at)gmail(dot)com>
Subject: pg_dump does not include triggers - should it?
Date: 2011-11-16 23:19:45
Message-ID: CA+jMWoeq7bYrPZmnhvm-Leqg8Fv7oKY1r6pPYaoYfw6swGni_A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are using Postgres 8.4.8 and it is a very fine database.

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.
Should it? (We'd like it to, we are counting on pg_dump to
backup all our data, including the triggers.)

Thanks again for a great product!

Best,
-at

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Johnston 2011-11-16 23:33:57 Re: insert locking issue for PG 9.0
Previous Message Ben Chobot 2011-11-16 22:48:13 insert locking issue for PG 9.0