WAL replication wrong collate

From: basti <mailinglist(at)unix-solution(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: WAL replication wrong collate
Date: 2017-08-14 18:52:51
Message-ID: 98d61dfb-ee70-dd94-1e89-906979654882@unix-solution.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

i try to replicate my database. what i have done?

- create a cluster on slave (UTF8, en_US.utf8 collate/c_type)
- stop cluster and cleanup datadir
- do basebackup from master
- start db-cluster

Master has utf8, en_us.uft8 collate/c_type
Now my db on slave has UTF8, c.utf8 collate/c_type.
Whats wrong here?

master and slave had set the same locales.
I dont unterstand that i can create a database in en_us.utf8 and then
when i did the basebackup it's change to c locale.
I cant find any option for pg_basebackup to set locale/collate.
I use this howto https://wiki.postgresql.org/wiki/Streaming_Replication
and had install an other cluster in the past with successful.

How can help please?

Best regards,
basti

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-08-14 19:24:12 Re: Queries for Diagramming Schema Keys
Previous Message stimits 2017-08-14 18:46:13 Queries for Diagramming Schema Keys