Postgres Pro
Downloads
Home   >   mailing lists

pg_dump does not include triggers - should it? - Mailing list pgsql-general

From Aleksey Tsalolikhin
Subject pg_dump does not include triggers - should it?
Date
Msg-id CA+jMWoeq7bYrPZmnhvm-Leqg8Fv7oKY1r6pPYaoYfw6swGni_A@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump does not include triggers - should it?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Ben Chobot
Date:
Subject: insert locking issue for PG 9.0
Next
From: "David Johnston"
Date:
Subject: Re: insert locking issue for PG 9.0