Search Postgresql Archives

Re: pg_dump does not include triggers - should it?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Aleksey Tsalolikhin <atsaloli.tech@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux