BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters - Mailing list pgsql-bugs

From Jan-Peter Seifert
Subject BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters
Date
Msg-id 201102090957.p199vBv2097307@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
The following bug has been logged online:

Bug reference:      5874
Logged by:          Jan-Peter Seifert
Email address:      Jan-Peter.Seifert@gmx.de
PostgreSQL version: 8.4.7
Operating system:   Windows 7 64-Bit
Description:        pg_dumpall CREATE DATABASE statements 'missing'
parameters
Details:

Hello,

it's not really a bug ... but CREATE DATABASE statements for databases with
the same Locale/Encoding as the server miss the parameters ENCODING,
LC_COLLATE and LC_CTYPE. So you 'can't' migrate to a server with a different
Locale/Encoding setting.
I'd be very happy if one had the option to switch between OS specific names
e.g. German_Germany.28591 on Windows and de_DE on Linux automatically ( -b
WIN ) or manually ( -w German_Germany.28591,de_DE+...) as well.
I'd also be very happy if one could specify a comma separated list of
databases to skip (e.g. template1, postgres etc.)

Thank you very much,

Peter

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5862: Postgres dumps core upon a connection attempt
Next
From: Peter Eisentraut
Date:
Subject: Re: sort order (ORDER BY) hu_HU.UTF-8 locale with UTF-8 encoding is not working correctly on FreeBSD