Richard Huxton wrote:
> At present it means you can't reliably do:
> DROP DATABASE foo;
> pg_restore --create foo.dump
> I'd then have to either hand edit the dumpall dump or wade through a
> bunch of errors checking that none of them were relevant.
Actually, I'm not sure pg_dumpall does them either.
tracker=> SELECT name,setting,source FROM pg_settings WHERE name =
name | setting | source
DateStyle | SQL, DMY | database
pg_dumpall -U postgres -p 5483 -g > tracker.global.schema
pg_dump -U postgres -p 5483 --schema-only > tracker.schema
grep -i datestyle tracker*schema
That's with 8.3.3
Am I doing something stupid here?
In response to
pgsql-hackers by date
|Next:||From: Alvaro Herrera||Date: 2008-06-27 16:52:10|
|Subject: Re: Vacuuming leaked temp tables (once again)|
|Previous:||From: Tom Lane||Date: 2008-06-27 16:43:51|
|Subject: Re: Vacuuming leaked temp tables (once again) |