| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Jeff Frost <jeff(at)frostconsultingllc(dot)com> |
| Cc: | Gerhard Wiesinger <lists(at)wiesinger(dot)com>, "Raymond O'Donnell" <rod(at)iol(dot)ie>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Full backup - pg_dumpall sufficient? |
| Date: | 2009-01-30 02:39:37 |
| Message-ID: | 22796.1233283177@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
>> I guess I could pg_dumpall -s | grep "ALTER DATABASE" to grab that stuff.
> That seems silly. Is this the best way to find this data:
> SELECT name, setting FROM pg_settings where source = 'database' ORDER BY
> name;
No, you'd miss anything overridden locally in your session.
I'd think about getting it out of pg_database.datconfig, instead.
Or really the easiest way is to tweak the logic in pg_dumpall about
what to dump when ...
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2009-01-30 03:37:11 | Re: Pet Peeves? |
| Previous Message | Jeff Frost | 2009-01-30 02:34:04 | Re: Full backup - pg_dumpall sufficient? |