moving data with pg_dump/pg_restore between database with different locale

From: "Zwettler Markus (OIZ)" <Markus(dot)Zwettler(at)zuerich(dot)ch>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: moving data with pg_dump/pg_restore between database with different locale
Date: 2023-10-11 11:34:19
Message-ID: ZR0P278MB0105F9681BBCB546572AFD368BCCA@ZR0P278MB0105.CHEP278.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anthony Apollis 2023-10-11 11:46:35 No Data Being Inserted
Previous Message Laurenz Albe 2023-10-11 11:20:29 Re: Can not drop partition if exist foreign keys