7 questions
1
vote
0
answers
92
views
Cloud SQL mysql database became very slow after disk got full and upgrade to add more space
the web service was working well before the mysql database instance in Cloud SQL went unavaialable because the disk got full. After adding more space, enough space , the db and the web service start ...
- 12.2k
-1
votes
1
answer
245
views
How to create a trigger in CloudSQL PostgreSQL that sends an HTTP POST request?
I have a table in a CloudSQL PostgreSQL database, and I want to create a trigger that sends an HTTP POST request whenever a new record is inserted into the table.
I know that PostgreSQL supports the ...
0
votes
0
answers
41
views
gcloud sql export --parallel gives "invalid byte sequence for encoding "UTF-8"" when restoring with pg_restore to local postgres database
I ran an export on my database with
gcloud sql export sql "${INSTANCE_NAME}" "${GCS_BUCKET_URI}/${INSTANCE_NAME}_${TIMESTAMP}" --database=postgres --offload --async --clean --...
- 11
1
vote
1
answer
98
views
Is it possible to use federated queries from GCP Dataform?
I'd like to query tables in CloudSQL from Dataform.
I set up an external connection to the CloudSQL database in bigquery, and am able to get query results when I run the federated query from BigQuery.
...
- 1,281
0
votes
1
answer
44
views
Timestamp comparison and conversion to application server timezone issue with CloudSQL DB
Since cloudsql by default stores timestamp values in UTC format, how can we make the conversion of the timestamp between the application layer and DB.
The application server is MST time zone based and ...
0
votes
2
answers
344
views
extension pg_cron on PostgreSQL DB on Google Cloud Platform Cloud SQL not working on monthly and weekly schedule
I installed pg_cron extension (v.1.4 ) on GCP Cloud SQL PostgreSQL (v.14) .
I instaleld it on postgres database and it works smoothly on daily schedule
E.G.
SELECT cron.schedule('test cron OK', '21 18 ...
1
vote
1
answer
511
views
Installing ODBC Driver 18 for SQL Server on pythonanywhere
I am using Google Cloud SQL for a telegram bot and apart from all the pip installations like
pyTelgramBotAPI, pyodbc, requests, I need the ODBC Driver for it to work. Since, I did not find any ...
