CloudSQL Postgres Read Replica Issues | C2C Community
Question

CloudSQL Postgres Read Replica Issues

  • 2 February 2023
  • 2 replies
  • 40 views

Userlevel 2

Hi everyone, we’re noticing some errors on our CloudSQL read replica replication process which has been working fine for over a year. Without making any major changes, CloudSQL is starting to log the following error

db=cloudsqladmin,user=cloudsqladmin ERROR:  cannot execute CREATE TABLE in a read-only transaction

To my understanding, this a largely GCP CloudSQL managed process as we just configured a read replica. Any advice and where to debug would be great - thanks so much in advance!


2 replies

Userlevel 7
Badge +12

@snorlax I just that you examine the service account for cloudsql to verify it has the appropriate permission to create tables

Badge +1

redownload cloudsql

Reply