Missing database flags

141 vues
Accéder directement au premier message non lu

Leonel Franchelli

non lue,
28 juil. 2018, 12:25:1028/07/2018
à Google Cloud SQL discuss
Hi, i've noticed that i can't configure ( server wide ) the following 

Parameters:
  1. lc_messages
  2. lc_monetary
  3. lc_numeric
  4. lc_time
i can edit them with the common "CREATE DATABASE ... " SQL command, but that is not what i want.

I've also traied to use the "ALTER SYSTEM" SQL command, to change the "postgresql.conf" params, but the user created doesn't have "superuser" rights.

The ability of editing those parameters, is important for us, because whe have all our server with the locale 'es_AR.UTF-8'

Thx and apologies for my english.

George (Cloud Platform Support)

non lue,
30 juil. 2018, 14:48:4730/07/2018
à Google Cloud SQL discuss
You are right, the list of unsupported features for PostgreSQL in GCP includes any features that require SUPERUSER privileges. An exception to this rule is made for the CREATE EXTENSION statement, but only for supported extensions. You may read more related detail on the "Cloud SQL for PostgreSQL Features" page

You state that editing the mentioned parameters by way of the "CREATE DATABASE" command is unsatisfactory. Why do you find this feature unsatisfactory? What new feature implementation would be satisfactory for you, by contrast? How would you describe the desired feature in more detail? A well-described use-case would help, preferably structured in step-by-step manner. 
Répondre à tous
Répondre à l'auteur
Transférer
0 nouveau message