Deploy Postgres cluster with specific locale

Follow

Paulo Castro

• March 19, 2020 15:59

Hello!

I have the need to deploy a cluster and define a specific locale. Normally I would do

 

pg_createcluster --locale pt_PT.ISO-8859-1 11 main

 

How can this be achieved using clustercontrol to deploy the cluster with that specific locale?

 

Thank you!

0

• Official comment

  

  Ashraf Sharif

  • April 19, 2020 12:11

  Hi,

  Since ClusterControl does not use pg_createcluster to initialize the server, I believe the --locale option has to be specified when running initdb command.

  Unfortunately, ClusterControl runs the initdb command without the --locale option, and it's hardcoded. I can file a feature request to the dev team to support this. At the time being, you may create the cluster using pg_createcluster with the locale option (or initdb --locale=..), and then import them into ClusterControl via Import Existing Cluster function.

  Regards,
  Ashraf

  Comment actions Permalink
• 

  Johan

  • April 21, 2020 11:23

  Hello Paolo,

  I am just curious why you do not configure the entire server(s) to have this locale as default? 
  It would be very helpful to understand the use case here! 

   

  thanks and good luck  

  Johan

  0

  Comment actions Permalink

Please sign in to leave a comment.