PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – In Google Cloud SQL Postgres how do I avoid log_min_messages as not superuser?

There’s no way in google cloud sql postgres to make a superuser. So I get:

psql --version
psql (PostgreSQL) 16.3 (Postgres.app)
psql postgres://postgres:password@ip/db
FATAL: permission denied to set parameter "log_min_messages"

when I try and connect. I’ve set this flag to "info" but still when I connect it tries and change the value and this error is fatal. Without making a superuser how can I get around this?

  • "Superuser restrictions and privileges
    Cloud SQL for PostgreSQL is a managed service, so it restricts access to certain system procedures and tables that require advanced privileges. In Cloud SQL, customers cannot create or have access to users with superuser attributes."

https://cloud.google.com/sql/docs/postgres/users

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    I did

    brew install postgresql@15

    and that somehow fixed it for me. Even though I'm still using my original psql (PostgreSQL) 16.3 (Postgres.app). I can now login without that FATAL error but no idea why this fixed it.


  2. 0

    These are called "database flags". You can change the settings by using your Google Cloud Console

    After a change you have to restart the instance to activate the new flag.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search