Questions tagged [postgresql]
For questions about PostgreSQL, an open-source object-relational database system (RDBMS).
22
questions
0
votes
0answers
27 views
How to configure postgres service for netdata on kubernetes
I'm using netdata to monitor metrics of my k8s cluster. However, when trying to add database metrics (I have a remote postgres database), I couldn't find any directives as to how to configure the helm ...
0
votes
0answers
7 views
How to purge selected data on request from PostgreSQL backups stored on S3?
One of our partners has a requirement that we be able to delete any data sourced from them on request, including from backups. The backups are taken daily, and are stored on S3 for up to a year.
It ...
0
votes
0answers
107 views
Why are my Alpine Docker images failing to build with postgresql-dev randomly with 'BAD signature' warnings?
I am trying to build a Docker image based on the Evennia image, which has an Alpine base. However, I need to install postgresql-dev so that my image can interact with a Postgres container. I am ...
0
votes
0answers
49 views
How can I investigate an issue with cgroup inside Minikube on Docker
I have an issue with deploying VMWare Tanzu Greenplum for Kubernetes (it's based on PostgreSQL) on the Minikube cluster. I wanted to use Minikube on Docker but for some reason, it does not work with ...
2
votes
1answer
29 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 ...
0
votes
0answers
35 views
Azure DevOps for Azure PostgreSQL
How can we configure Azure DevOps for PaaS offering of Azure PostgreSQL Database Please help.
Know someone who can answer?
0
votes
1answer
244 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
votes
1answer
16 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 ...
1
vote
1answer
23 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 ...
6
votes
2answers
503 views
Blue Green Deployment DB transactions management
Imagining I have 2 sets of environment(Blue and Green)
+
|
|
|
v
+-------+---------+
| Proxy/LB |
| |
+--+----...
2
votes
0answers
134 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 ...
0
votes
1answer
2k 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
...
0
votes
1answer
379 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
1answer
39 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 ...
1
vote
1answer
53 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 ...
1
vote
1answer
237 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?...
5
votes
1answer
10k 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
21 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
vote
1answer
2k 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 ...
3
votes
1answer
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- ...
0
votes
1answer
47 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
211 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 ...
