Postgres Pro
Downloads
Home   >   mailing lists

pg_dump does not include database-level user-defined GUC variables? - Mailing list pgsql-general

From Abelard Hoffman
Subject pg_dump does not include database-level user-defined GUC variables?
Date
Msg-id CACEJHMjW1Zb_aO_3vUUpo=Hcwz1TxjQ0LRJkTbJgSEcPtakfqQ@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump does not include database-level user-defined GUC variables?  (Kevin Grittner <kgrittn@ymail.com>)
List pgsql-general
Tree view
I have a user-defined GUC variable that was set at the db level. e.g.,

  ALTER DATABASE mydb SET myapp.user_id TO '1'

Works fine. When I do a pg_dump, however, that variable isn't included.
Is that expected? It's not really an attribute of the database?

Thanks.


pgsql-general by date:

Previous
From: Szymon Guz
Date:
Subject: Re: Why isn't Java support part of Postgresql core?
Next
From: Pete Hollobon
Date:
Subject: Re: Feature request: temporary schemas