The following bug has been logged online: Bug reference: 5874 Logged by: Jan-Peter Seifert Email address: jan-peter.seif...@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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs