Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group