Questions tagged [postgresql]
For questions about PostgreSQL, an open-source object-relational database system (RDBMS).
32 questions
0
votes
1
answer
36
views
How to run only the initialisation step of the Docker official PostgreSQL image without starting the database?
I want to separate the database initialisation from the actual runtime of PostgreSQL in a Docker Compose project.
The Docker official PostgreSQL image (I'm using postgres:18-alpine) automatically runs ...
- 101
2
votes
1
answer
62
views
Best strategy/architecture to deploy dozens websites with PostgreSQL in Kubernetes
I am working on a Kubernetes-based solution to host dozens of PHP websites (with future compatibility for Python/Node) using PostgreSQL as the database. The goal is to provide an environment similar ...
- 21
1
vote
1
answer
62
views
Docker and host IP migration times out on Postgres import
I have a host machine running a postgresql docker container listening and exposing port 5432 on the host. I had a set of scripts that upload a large set of records from a CSV using PySpark and ...
- 111
0
votes
1
answer
805
views
Postgresql container automatically dropping database after some time in Docker Compose setup
I have a Docker Compose setup for a PostgreSQL container like below:
version: '3'
services:
#PostgreSQL Service
um-db:
image: postgres:15
container_name: um-db
tty: true
ports:
...
- 101
1
vote
2
answers
484
views
Ansible Connecting to remote Docker container over SSH
I have the following situation: I have a remote server that runs docker with a Postgres container. The Postgres instance is only reachable through a docker network, not directly from the remote server....
- 21
1
vote
1
answer
507
views
How crunchydata Postgresql operator and Service works
We have deployed a PostgreSQL with crunchydata operator.
We followed the link https://access.crunchydata.com/documentation/postgres-operator/v5/quickstart/#connect-using-a-port-forward and connected ...
- 220
4
votes
2
answers
894
views
Postgresql in DevOps skills
What are the basic skills and requirements a DevOps candidate should have when working with PostgreSQL?
How to monitor it, deploy, etc.?
- 41
1
vote
1
answer
3k
views
Autoscaling Postgres Database using Kubernetes
Is it possible to autoscale a Postgres Database using Kubernetes ?
I usually run a Docker container with very specific settings to install a postgres database for my application. Does using Kubernetes ...
- 133
0
votes
1
answer
2k
views
Include curl commands in a PostgreSQL Docker environment
Using COPY table FROM PROGRAM 'curl "www.example.com/data.csv"'; I am able to copy a CSV directly from the web into a psql table.
However, when I am running the same command from inside a ...
- 1
2
votes
1
answer
303
views
get value of default_statistics_target on postrgesql
I want to see the value of default_statistics_target on postgresql before running
SET default_statistics_target=1000
Its most likely the default (100) but would like to see it.
Where it can be ...
- 31
3
votes
1
answer
731
views
Where does PGBouncer sit on a Kubernetes Cluster
I'm wanting to deploy some sort of connection pooling within my applications across multiple nodes. Python naturally provides some pooling with the SQLAlchemy implementation; but obviously this ...
- 131
0
votes
1
answer
1k
views
How to connect to postgres container from a node container using docker-compose?
I'm trying to connect from a node app container to a postgresql container using docker-compose but I'm not able to do it.
This is my docker-compose.yml file:
version: '3.7'
services:
db:
image: ...
1
vote
1
answer
95
views
i have questions about docker-compose
postgres:
image: healthcheck/postgres:alpine
environment:
POSTGRES_USER: postgres
What is the default user of postgresql?
How does hardcoding the postgres user improve security?
What special rights ...
- 21
6
votes
1
answer
12k
views
Best practice for Postgres setup with docker-compose
I have a docker-compose script which starts a Postgres container and an app container like so
db:
image: postgres:10.6
restart: always
ports:
- 5432:5432
app:
image: test_app:latest
...
- 223
1
vote
1
answer
3k
views
lc_collate values for database "postgres" do not match: old "C.UTF-8", new "en_US.UTF-8"
I am working on testing a method for postgres 9.3 to 10 upgrade. I currently am at the dry run phase and ran into a few issues. The current blocking one is lc_collate values for database "postgres" do ...
user8517
0
votes
1
answer
88
views
Planning a backup system using postgress, chef and vault
As the title says I am working on planning a way to backup postgres using chef and vault. Idea is that we already encrypt the backups from postgres using a key (random binary string) and we would like ...
user8517