Questions tagged [postgresql]
For questions about PostgreSQL, an open-source object-relational database system (RDBMS).
28
questions
8
votes
2
answers
2k
views
Blue Green Deployment DB transactions management
Imagining I have 2 sets of environment(Blue and Green)
+
|
|
|
v
+-------+---------+
| Proxy/LB |
| |
+--+----...
- 133
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
4
votes
1
answer
15k
views
How to quickly test if postgres database is accessible?
I whished there were a tool like ping for databases? I just want to ping the database and see if it is accessible from a remote server from Linux command line (bash).
I read about telnet, but I am not ...
- 251
4
votes
2
answers
745
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
3
votes
1
answer
667
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
3
votes
1
answer
2k
views
Stolon vs CrunchyData for HA Postgresql
I'm using helm charts with kubernetes and I'm trying to deploy High Availability Postgresql database and found this article mentioning three project that provide HA Postgresql:
1- Stolon
2- ...
- 151
3
votes
1
answer
152
views
What are the best practices for sharing production Postgres access with developers?
We're a small SaaS startup (~10 person team; mostly engineers).
We use Postgres on AWS and GCP in production.
We have signed contracts with some customers that prohibit us from giving full production ...
- 131
2
votes
1
answer
223
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
2
votes
1
answer
2k
views
mounting overlayfs within kubernetes POD - "cannot mount overlay read-only"
I try to "manually" mount an overlayfs within a Kubernetes POD, to create a copy-on-write layer on top of a shared persistent volume.
(For running a read-only postgres - postgres cannot run ...
- 131
1
vote
1
answer
8k
views
Can't get either Postgres permissions or PVC working in AKS
These are pretty much the steps I have followed in order. Basically what is outlined in the documentation:
https://docs.microsoft.com/en-us/azure/aks/azure-files-dynamic-pv
azure-storage-claim.yaml
...
- 155
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
1
vote
1
answer
1k
views
How to use port 5433 with Azure managed postgres
We are looking to use Azure managed postgres but I am having some issues with connecting on port 5433 I can connect on port 5432 fine. I need just port 5433 to work, is there a way to access that port?...
user8517
1
vote
1
answer
2k
views
What is IPC:BufferIO in managed postgresql metrics on AWS
I have a managed postgresql instance on AWS.
Sometimes the database session load seems excessive
in RDS > Databases > [instance] page
Then in the metrics I see the following graph:
My question ...
- 113
1
vote
1
answer
76
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 ...
- 21
1
vote
1
answer
406
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
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
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
0
votes
1
answer
285
views
Why won't InSpec admit that port 5432 is listening inside a PostgreSQL container?
Background
I'm trying to test a PostgreSQL container with InSpec 2.1.10, but I cannot get a simple port check to return true, even though Docker, netstat, and psql all report that the port is ...
- 242
0
votes
1
answer
53
views
Is the data shared between two pods database deployment k8s
I have a structure like shown in the image below: cluster with two nodes and service for the database (postgres).
Is the data shared between those two pods of postgres images or is it possible to set ...
- 101
0
votes
1
answer
330
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....
- 11
0
votes
1
answer
73
views
Which system user should I use to run Postgres?
I am using a postgres docker image configured with the following environment:
image: healthcheck/postgres:alpine
environment:
POSTGRES_USER: postgres
I have the following questions ...
- 21
0
votes
1
answer
67
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
0
votes
0
answers
30
views
I can't reach out the database from my pod
I have two servers A with private ip address 10.1.0.2 and B with private ip address 10.1.0.4 on server A I have a docker container that runs postgres database On server B have a pod that tries to ...
- 1
0
votes
0
answers
275
views
Postgres pod not creating user despite the `env` variable `POSTGRES_USER`
I have the following pod setup:
Secret:
apiVersion: v1
kind: Secret
metadata:
name: postgres-secret
labels:
app: postgres
type: Opaque
data:
postgres_user: <base64>
postgres_password:...
- 101
0
votes
1
answer
511
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
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: ...
0
votes
1
answer
32
views
One time database update process as part of applying a patch
I have a PostgreSQL database that requires a server side script to be executed (client prefers php) to:
Perform some intelligent data modifications to records that will be
identified only during the ...
-1
votes
1
answer
174
views
Minimum postgresql + spring + react hardware requirements
I have to deploy my postgresql + spring + react fullstack application on premise so cloud is out of the question. It's going to be used by around 15 users at a time. But I have to specify what ...
- 101