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 ...
