ALTER DATABASE vs pg_dump - Mailing list pgsql-hackers

From Richard Huxton
Subject ALTER DATABASE vs pg_dump
Date
Msg-id 4864F001.50909@archonet.com
Whole thread Raw
Responses Re: ALTER DATABASE vs pg_dump  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Is it desirable that pg_dump doesn't dump config settings set via ALTER 
DATABASE?

http://archives.postgresql.org/pgsql-novice/2008-04/msg00016.php

I just got bitten by a DateStyle not being restored on my test DB (I 
usually set it client-side in the app). I could see someone without my 
steel trap of a mind letting something like this slip through. Obvious 
problem settings would be: datestyle, locale, default-text-search

Is this a deliberate behaviour of pg_dump or just an unscratched itch?

--   Richard Huxton  Archonet Ltd


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ecpg generated files ignorable?
Next
From: Gregory Stark
Date:
Subject: Re: Hint Bits and Write I/O