[google-cloud-sql-discuss] Re: CSV export with replication

Hi Olu:

My comment below.

Thanks 

El jueves, 9 de abril de 2020, 15:36:57 (UTC+2), Olu escribió:

Hello, Rafael

There are a number of reasons why the error may have been returned. In fact, a similar issue reported in the past was traced to the amount of workloads on the CloudSQL instance at the time. Also, the issue sometimes was found to be transient as there were times observed in the past that restarting the Instance resolves the issue. For better troubleshooting of the issue, which may involve reviewing configurations on your Project, I recommend you contact the GCP Support Engineers[1] or if you think this issue is a bug and you are using the appropriate User account but it is failing, then open an issue using this link[2]. 

I already fixed the error were the permissions. But I'll check the links and take note for future problems 

About the flag, hot_standby_feedback, from the information provided on this CloudSQL for Postgres page[3], the flag is actually supported. I did a test on my test environment and I was able to successfully add the flag without any additional access or permission. If you can't change the flag, can you provide information about your experience? Do you have an error reported or the field is grayed out? 

 i thing was an alter table "ALTER SYSTEM SET hot_standby_feedback TO on"  maybe need to execute the command.

This information will be helpful to understand what may be the cause of your inability to change the flag and possibly, the same reason may be responsible for the failing export using your user account.  

[1]https://cloud.google.com/support-hub

[2]https://developers.google.com/issue-tracker/#public_users

[3]https://cloud.google.com/sql/docs/postgres/flags#postgres-h

--
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/a20eaf52-cf8f-4106-a231-c41ce00474bc%40googlegroups.com.