On Tue, Sep 16, 2014 at 12:39 PM, Adrian Klaver <adrian.kla...@aklaver.com>
wrote:

> On 09/16/2014 10:33 AM, Michael Paquier wrote:
>
>> On Tue, Sep 16, 2014 at 8:43 AM, Pavel Stehule <pavel.steh...@gmail.com>
>> wrote:
>>
>>> 2014-09-16 17:39 GMT+02:00 Kevin Grittner <kgri...@ymail.com>:
>>>
>>>> Abelard Hoffman <abelardhoff...@gmail.com> wrote:
>>>>
>>>>> 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?
>>>>>
>>>>
>>>> That sort of information *about the database* is stored at the
>>>> cluster level, not in the database itself.  Take a look at
>>>> pg_dumpall.
>>>>
>>> [snip]

>
> If I am looking to recreate a database I am not getting the same one. At
> the least it should be accessible via pg_dumpall -g so you could do
> individual database dumps and get the database guc without having to dump
> the entire cluster.


Yes, that's exactly what bit me.  I was trying to figure out why a restore
of a db was failing all tests, and discovered the missing GUCs in the dump.
There may be reasons for it living at the cluster level, but I suspect most
users will expect pg_dump to include them.

AH

Reply via email to