Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [postgresql]

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

0
votes
1answer
27 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 ...
0
votes
1answer
13 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 ...
0
votes
0answers
11 views

Permission issue with Persistent volume in postgres in Kubernetes

I know this question has been asked repeatedly but not fully answered. I have a postgres running in as root user in a container which is using the persistent volume. But it seems like there is ...
0
votes
0answers
28 views

Zabbix on docker containers

I want to build highly available Zabbix service for my infrastructure. I am considering it on VMs or in containers. I already know the case of running Zabbix in VM, yet I am not aware of pros, and ...
0
votes
0answers
147 views

There seems to be a postmaster servicing the old cluster. | Upgrade from postgres 9.3

I am working on upgrading postgres from version 9.3 to 10. I have encountered a lot of issues along the way since the install is way more custom done than it should be (People here LOVE complex and ...
1
vote
1answer
214 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 ...
1
vote
1answer
254 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- ...
0
votes
1answer
20 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 ...
0
votes
1answer
91 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 ...