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