Wednesday, November 10, 2021

[google-cloud-sql-discuss] Update conf file with ALTER SYSTEM SET on Postgres

I want to update the conf file of my server because I need to have more workers for my queries but setting max_logical_replication_workers = 8.
But I get error that its not allowed when running this:

ALTER SYSTEM SET max_logical_replication_workers = 8;

ERROR: must be superuser to execute ALTER SYSTEM command

I saw from the docs that I canot have superuser permissions. 

Is there a way to update this fields? its seems very weird to me that I canot scale my server.
I tested my server by getting 16vCPU to work but each query is capped to 4 workers so getting bigger machines does nothing.

--
You received this message because you are subscribed to the Google Groups "Google Cloud SQL discuss" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-cloud-sql-discuss+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/google-cloud-sql-discuss/7d0a9a6a-aa88-419e-be6a-74543068fe34n%40googlegroups.com.

No comments:

Post a Comment