BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters

From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5874: pg_dumpall CREATE DATABASE statements 'missing' parameters
Date: 2011-02-09 09:57:11
Message-ID: 201102090957.p199vBv2097307@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5874
Logged by: Jan-Peter Seifert
Email address: Jan-Peter(dot)Seifert(at)gmx(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Denis Feklushkin 2011-02-09 19:53:28 [Fwd: ERROR: cannot extract system attribute from minimal tuple]
Previous Message Tom Lane 2011-02-09 03:10:28 Re: BUG #5862: Postgres dumps core upon a connection attempt