CloudSQL Postgres Read Replica Issues | C2C Community

CloudSQL Postgres Read Replica Issues

  • 2 February 2023
  • 1 reply

Userlevel 1

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!

1 reply

Userlevel 6
Badge +6

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