Stack Overflow
Stack Overflow

Questions tagged [google-alloydb]

20 questions
2
votes
1 answer

AlloyDB read pool data appears to be stale

We have an AlloyDB instance set up with a read pool. Inside our application, we route database queries to either the primary node or the read pool, depending on whether the operation itself is a SELECT or not. This has been working well; however, we…
Daniel Rearden
  • 80,636
  • 11
  • 185
  • 183
1
vote
3 answers

Does AlloyDB support authenticating to Postgres databases with IAM service accounts like Cloud SQL does?

I'm really confused about how IAM login works with AlloyDB. I don't see anything in the docs about mapping postgres users to IAM service accounts. With Cloud SQL Postgres I can do this: https://cloud.google.com/sql/docs/postgres/authentication I…
red888
  • 27,709
  • 55
  • 204
  • 392
1
vote
1 answer

Using OpenVPN or Cloud VPN to connect to AlloyDB Instance

TLTR; - Want to connect to google Alloydb using OpenVPN A little bit more detailed: I'm trying to connect from my local to Alloydb so that we are able to perform some queries on AlloyDB but it's only reachable in a privat IP. I have it working using…
Nino Matos
  • 91
  • 9
1
vote
1 answer

How can I change for automated-backup retention count in AlloyDB?

I tried to change for automated-backup retention count by gcloud command below. gcloud alloydb clusters update XXXXXXXX\ --automated-backup-days-of-week="MONDAY,TUESDAY,WEDNESDAY,THURSDAY,FRIDAY,SATURDAY,SUNDAY" \ …
ggk-1
  • 11
  • 2
1
vote
1 answer

How can I deploy and connect to a postgreSQL instance in AlloyDB without utilizing VM?

Currently, I have followed the google docs quick start docs for deploying a simple cloud run web server that is connected to AlloyDB. However, in the docs, it all seem to point towards of having to utilize VM for a postgreSQL client, which then is…
funtkungus
  • 238
  • 1
  • 2
  • 12
1
vote
3 answers

Datastream Troubleshoot: "An unknown error occurred. Please try again. If the error persists, contact Google support"

We are trying to replicate data from AlloyDB to Bigquery using Datastream. We Get "An unknown error occurred. Please try again. If the error persists, contact Google support." In the Datastream console --> objects list, we see all source tables with…
N.N.
  • 3,094
  • 21
  • 41
1
vote
2 answers

How to configure federated query from Google BigQuery to Google AlloyDB?

I am trying to configure a connection between Google BigQuery to Google AlloyDB (I want to query AlloyDB from Bigquery). Trying to follow these instructions: https://cloud.google.com/bigquery/docs/cloud-sql-federated-queries with no much success...…
N.N.
  • 3,094
  • 21
  • 41
1
vote
1 answer

Error on CREATE DATABASE: "INTERNAL: num blocks cache out of memory"

I'm creating multiple databases in AlloyDB to run tests in parallel. I create the first one (test) using the DDL statements and then - I'm cloning it using it as a template. After creating a few databases I'm starting to get following errors: …
mrzasa
  • 22,895
  • 11
  • 56
  • 94
1
vote
1 answer

How to connect to AlloyDB using Auth Proxy and Python?

I am trying to connect to the AlloyDB in google cloud via alloydb-auth-proxy. I am not able to connect to it successfully. I am getting error while trying to do this. I followed the instruction mentioned in…
Pritam Sinha
  • 309
  • 6
  • 11
1
vote
1 answer

what is AlloyDB read pool used for? is it just the same as replicas?

i was moving to alloyDB thinking that it'll be smart enough to separate my read and write to the database, so the load of my primary CPU will not be overloaded like i used to face when i was using postgreSQL CloudSQL. i was wondering what is the…
Alex chai
  • 21
  • 4
1
vote
2 answers

AlloyDB tcp:5433 timeout

dial tcp:5433 timeout on the auth proxy end when trying connect local private IP address of the AlloyDB instance i/o timeout failed to connect to instance: Dial error: failed to dial (instance URI =…
Diego Cumbicus
  • 19
  • 4
0
votes
1 answer

Migrate alloydb database to another alloydb instance in a different VPC in Google Cloud

Migrating an alloydb instance to another one in a different VPC doesn't work. I have tried using the Database Migration Service but I was unable to do so, and I am not sure it is because it may not be compatible to migrate. Being in different…
Alejandro de la Cruz López
  • 1
  • 1
0
votes
1 answer

How to enable AlloyBD Omni columnar engine?

Using AlloyDB Omni 0.2.0 installed locally (followed docs) on Ubuntu 22.04. The DB is up and running, so I loaded some data and wanted to add a table to the column store, like here. Unfortunately, I got an error saying google_columnar_engine module…
ajron
  • 31
  • 4
0
votes
1 answer

AlloyDB Update/Patch strategy?

We are evaluating the AlloyDB service and don't really understand how updates/patches are rolled out. Basically there are two scenarios: Primary instance update: What happens when the primary instance is updated? Will there be a restart or…
Richard Jentzsch
  • 1
0
votes
1 answer

Why can't 1 cloud run service (client) connect to another (backend) cloud run service when ingress is controlled?

I'm currently running two Cloud Run services (static web + web server). The web server is connected to AlloyDB instance, which is all through a VPC. I have also set up Ingress Control to allow traffic from the vpc. However, when I do set this…
funtkungus
  • 238
  • 1
  • 2
  • 12
1
2