38 questions
0
votes
0
answers
47
views
IAM User with Predefined Role in PostgreSQL not functioning
After struggling with how to grant an IAM service account read/write permissions on my AlloyDB primary instance, Jack Wotherspoon responded to my inquiry on a GitHub issue. I realized that I can grant ...
- 61
1
vote
2
answers
181
views
NETWORK_NOT_PEERED trying to create an AlloyDB instance through gcloud CLI
I'm trying to create an AlloyDB instance using the gcloud CLI using these commands:
gcloud alloydb clusters create default \
--region=$LOCATION \
--password=postgres
gcloud alloydb instances ...
- 14.7k
0
votes
0
answers
33
views
Error while creating AlloyDB cluster using PITR for postgres user
I am currently working on creating a new AlloyDB cluster and primary instance using the Point-In-Time Recovery (PITR) option via Terraform. However, I am encountering an error when running terraform ...
- 61
1
vote
1
answer
349
views
[GCP]Error while trying to impersonate Service account and run auth print-access-token
I'm getting this error:
ERROR: (gcloud.auth.print-access-token) Failed to impersonate
[Runtime-ServiceAccountName]. Make sure the account that's trying to
impersonate it has access to the service ...
- 61
1
vote
1
answer
74
views
Is there a way to use Python connector for postgresql with alloydb Auth Proxy?
I'm able to run a query against an AlloyDB instance using AlloyDB auth proxy and python code(using SQLAlchemy library).
But I want to test the IAM authentication for AlloyDB and Python connector for ...
- 61
1
vote
0
answers
79
views
Which operations benifit from AlloyDB's columnar angine?
The AlloyDB documentation is confusing for me at this part. There it mentions the list of operations that benefit most from the columnar engine:
Aggregation functions
They only use the following ...
- 983
0
votes
1
answer
138
views
how to run alloydb auth proxy in background in a pipeline?
I want to start alloydb auth proxy in one of the steps in my pipeline. I'm using bash. The problem is that the proxy starts but then it never pass to the next step.
When I was using cloud sql proxy, I ...
- 61
1
vote
1
answer
483
views
AlloyDB: Batch Import of CSV Files from GCS Bucket using python
We need to design a process that efficiently imports large CSV files that are created by upstream processes on a regular base into AlloyDB. We'd like to use python for this task. What is the best ...
- 416
0
votes
0
answers
27
views
in nifi how to split multiple json data as one json data in one file
I have data coming from ingnition to nifi and than to alloydb. I'm succesfully getting data from ignition to nifi. the output I'm getting is one file with multiple json data into it. I want one json ...
0
votes
2
answers
696
views
Trouble connecting AlloyDB using GO lang application deployed to Cloud Run. Error "IAM check failed, caller does not have required permissions"
My client's controlled environment may be something missing?
Application details - GO Lang, Deployed to Cloud Run trying to connect to AlloyDB.
Cloud Run configuration
NETWORKING
"Send traffic ...
0
votes
3
answers
744
views
Issue with Installing AlloyDB Omni CLI via Dockerfile Due to Architecture Mismatch
I'm attempting to set up AlloyDB Omni locally using a Dockerfile following the guidelines provided in the official Google documentation.
Below is the Dockerfile configuration I'm using:
FROM ubuntu:...
- 999
1
vote
1
answer
614
views
I want to connect from my pgAdmin to ALLoyDB
I want to connect from my pgAdmin in my local pc to ALLoyDB in a GCP VPC and i can't find the way
I have read about AlloyDB AuthProxy but I'm still not convinced on the steps to follow or if it's ...
0
votes
0
answers
60
views
AlloyDB- CREATE DATABASE can not be run in a transaction block [duplicate]
Since AlloyDB does not support creating a database using terraform yet, I am trying to create it using Alembic and sqlAlchemy. I am using postgresql+psycopg2 as the driver.My code looks similar to the ...
- 1,760
0
votes
1
answer
121
views
Error in conditional database creation with AlloyDB
I am trying to create a database in alloyDB if it already doesn't exist. I am using the following query
CREATE DATABASE test WHERE NOT EXISTS (SELECT from pg_database WHERE datname=test);
This syntax ...
- 1,760
0
votes
1
answer
1k
views
Error in connecting to AlloyDB database with IAM user
For Postgre Cloudsql, we have to use google cloud-sql-python-connector to connect to DB. When we establish a connection using IAM user, we don't have to pass any password if we pass a flag ...
- 1,760
0
votes
1
answer
2k
views
What is GKE's default service account?
I'm connecting to an AlloyDB cluster from an autopilot GKE cluster. I'm deploying 2 containers (same pod), 1) the AlloyDB Auth Proxy in container form (gcr.io/alloydb-connectors/alloydb-auth-proxy:...
- 2,727
1
vote
1
answer
329
views
Unable to create to new AlloyDB database using Terraform
I have created a new AlloyDB cluster and instance on GCP AlloyDB using erraform. As per the docs, the default database name is postgres and I am able to connect successfully to it using psql command.
...
- 1,760
0
votes
2
answers
186
views
What are the alternatives to using ADCs to authenticate to AlloyDB from a Spring Boot Java app?
In this thread https://www.googlecloudcommunity.com/gc/Databases/AlloyDB-ORM-Support/m-p/537212 some engineer from Google said that AlloyDb doesn't have support to spring boot natively and open ...
- 2,390
0
votes
1
answer
405
views
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 ...
0
votes
1
answer
305
views
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 ...
- 31
0
votes
1
answer
757
views
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 ...
1
vote
3
answers
980
views
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....
- 31.3k
3
votes
1
answer
224
views
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 ...
- 131
0
votes
1
answer
669
views
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 ...
- 246
1
vote
1
answer
218
views
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,...
- 11
1
vote
1
answer
1k
views
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 ...
- 246
0
votes
0
answers
112
views
how to connect alloydb with cData?
enter image description hereHow to connect alloydb with cData?,
it is either showing connection time out or connection refused while connecting. in Cdata I am doing the basic settings providing the ...
2
votes
1
answer
571
views
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 ...
- 84.4k
1
vote
3
answers
1k
views
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 ...
- 3,162
1
vote
3
answers
1k
views
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/...
- 3,162
1
vote
1
answer
136
views
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 ...
- 23.3k
0
votes
1
answer
299
views
AlloyDB: Drop database
How could I drop an exisitng AlloyDB database programatically?
I'd like to run a test suite of our application on AlloyDB. I'm able to connect to the cluster using the proxy. However, when I try to ...
- 23.3k
1
vote
2
answers
4k
views
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 ...
- 437
0
votes
1
answer
920
views
Issues creating AlloyDB
Creating new AlloyDB instances has been failing for the past 24 hours. It was working fine a few days ago
# creating the cluster works
gcloud beta alloydb clusters create dev-cluster \
--password=$...
- 625
0
votes
1
answer
196
views
Can you Reuse Cluster ID and Instance ID on AlloyDB?
this is a very simple question. I've created an AlloyDB cluster & instance. However I think I don't need it yet for now. I want to delete the cluster & instance and I wonder is the Cluster ID ...
0
votes
1
answer
2k
views
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 ...
- 25
2
votes
2
answers
2k
views
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 = &...
0
votes
1
answer
152
views
WARNING: Failed to add policy job since the add condition is not satisfied
I'm trying to schedule automatic recommendation and population by following this doc.
I'm trying to run this query
SELECT google_columnar_engine_add_policy( 'RECOMMEND_AND_POPULATE_COLUMNS', 'EVERY', ...
- 7,116