Questions tagged [postgresql]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 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:...
codehitman's user avatar
0 votes
1 answer
34 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: ...
Sandeep Dhakal's user avatar
0 votes
1 answer
14 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 ...
Aleksa Ristic's user avatar
0 votes
0 answers
16 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
1 answer
216 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....
Tiim's user avatar
  • 11
1 vote
0 answers
19 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
1 answer
1k 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 ...
destan's user avatar
  • 113
1 vote
1 answer
314 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 ...
igiannak's user avatar
  • 220
4 votes
1 answer
8k 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 ...
Soerendip's user avatar
  • 241
1 vote
0 answers
181 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
4 votes
2 answers
619 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.?
Дмитрий's user avatar
2 votes
1 answer
1k 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 ...
peschü's user avatar
  • 131
1 vote
0 answers
99 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
  • 411
1 vote
1 answer
2k 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 ...
GauravEdekar's user avatar
3 votes
1 answer
138 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 ...
RainSear's user avatar
  • 131
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 ...
sir_olf's user avatar
-1 votes
1 answer
127 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 ...
mixnix's user avatar
  • 101
2 votes
1 answer
157 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 ...
hvannia's user avatar
  • 31
8 votes
2 answers
1k views

Blue Green Deployment DB transactions management

Imagining I have 2 sets of environment(Blue and Green) + | | | v +-------+---------+ | Proxy/LB | | | +--+----...
Veerendra K's user avatar
3 votes
1 answer
605 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 ...
Callam Delaney's user avatar
1 vote
1 answer
7k 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 ...
cjones's user avatar
  • 155
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: ...
Alessandro Rodríguez's user avatar
0 votes
1 answer
62 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 ...
omar amine's user avatar
1 vote
1 answer
72 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 ...
omar amine's user avatar
1 vote
1 answer
968 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?...
user avatar
6 votes
1 answer
11k 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 ...
Madden's user avatar
  • 213
0 votes
1 answer
29 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 ...
Michael Martone's user avatar
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 ...
user avatar
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- ...
Nouran S. Ahmad's user avatar
0 votes
1 answer
63 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 ...
user avatar
0 votes
1 answer
278 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 ...
CodeGnome's user avatar
  • 242