Thread: moving data with pg_dump/pg_restore between database with different locale

moving data with pg_dump/pg_restore between database with different locale

From

"Zwettler Markus (OIZ)"

Date:

11 October 2023, 14:34:19

hi,

if you want to retrieve data by means of pg_dump / pg_restore from a database with locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any other things to consider than the behavior implications mentioned in the documentation:

https://www.postgresql.org/docs/current/locale.html#LOCALE-BEHAVIOR

Thanks,

Markus

Re: moving data with pg_dump/pg_restore between database with different locale

From

Laurenz Albe

Date:

11 October 2023, 19:49:23

On Wed, 2023-10-11 at 11:34 +0000, Zwettler Markus (OIZ) wrote: 
> if you want to retrieve data by means of pg_dump / pg_restore from a database with
> locale de_CH.UTF8 into a database with locale en_US.UTF8 are there any other things
> to consider than the behavior implications mentioned in the documentation:

The sort order will change, the language of error messages and the log file
will change (unless you set lc_messages differently), some format letters in
to_timestamp(), to_number() and to_char() will change semantics (unless you
set lc_numeric and lc_time differently).

That's about it.

Yours,
Laurenz Albe