Postgres Pro
Downloads
Home   >   mailing lists

Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)
Date
Msg-id 332.1219374325@sss.pgh.pa.us
Whole thread Raw
In response to Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)  (Bruce Momjian <bruce@momjian.us>)
Responses Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <bruce@momjian.us> writes:
> ALTER DATABASE ... SET seems to be something that doesn't fit in
> anywhere;  I am thinking pg_dump -g should dump it.

The upthread conclusion was that pg_dump -C should do it.
I am not sure how you come to the conclusion that -g is an
appropriate place, seeing that -g will not create the database(s)
that it'd be trying to apply ALTER to.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Does anything dump per-database config settings? (was Re: ALTER DATABASE vs pg_dump)
Next
From: "D'Arcy J.M. Cain"
Date:
Subject: Re: Proposal: new border setting in psql