Questions tagged [postgresql]

For questions about PostgreSQL, an open-source object-relational database system (RDBMS).

6 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1 vote
0 answers
18 views

Docker Postgres images with data

I have a bunch of DB backups used for QA and Integration Testing. From time to time, the schema of these DBs gets updated. I thought of Building Images for each DB instance and commit changes after ...
xvan's user avatar
  • 111
1 vote
0 answers
160 views

in k8s cant load dump db to postgres for init it

I have a k8s cluster for educational purposes. It has postgres one pod, but I can't load or dump db to postgres to initialise it. I added a pv and pvc for /docker-entrypoint-initdb.d and added locate ...
gerefig191's user avatar
1 vote
0 answers
89 views

Postgres initdb does nothing on Windows 2019?

I'm using Ansible to install Postgres 13 on a Windows 2019 machine. I downloaded the binaries from here and unzipped it to C:\PostgreSQL\13\pgsql, and added the path to the system path, all via ...
Chris F's user avatar
  • 384
0 votes
0 answers
12 views

Error running PostgreSQL Deployment in Kubernetes: "No such file or directory" for data directory

I am trying to deploy a PostgreSQL database using Kubernetes and encountered an error related to the data directory. Below is my YAML configuration for the Deployment: apiVersion: apps/v1 kind: ...
Ed Black's user avatar
0 votes
0 answers
14 views

Assigning new role to already existing user in RDS

"We have an RDS instance hosted for Aurora PostgreSQL, specifically using the 'db.r5.xlarge' instance type. When we initially set up the RDS instance, a default user named 'rdsadmin' was ...
Naresh Barule's user avatar
0 votes
0 answers
79 views

psql connection to postgis db in docker -failing all though db is running and accessible

After installing https://github.com/qwc-services/qwc-docker I am not able to connect to the postgis db that's created. I see the following f89d540947ca sourcepole/qwc-demo-db:v2022.09.03 "...
GeorgeC's user avatar
  • 101