DevOps Stack Exchange
DevOps Stack Exchange

Questions tagged [postgresql]

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

From PostgreSQL About page:

PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, macOS, Solaris), and Windows. It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL:2008 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.

Website: PostgreSQL

Related tags:

31 questions
8
votes
2 answers

Blue Green Deployment DB transactions management

Imagining I have 2 sets of environment(Blue and Green) + | | | v +-------+---------+ | Proxy/LB | | | +--+-------------++ | | +-----++ …
veerendra2
  • 133
  • 8
6
votes
1 answer

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 restart: always depends_on: - db This all…
Madden
  • 223
  • 1
  • 3
  • 6
5
votes
1 answer

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 sure how it works. Any suggestions?
Soerendip
  • 271
  • 1
  • 2
  • 7
4
votes
2 answers

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
  • 2
3
votes
1 answer

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- CrunchyData 3- Patroni I didn't find helm chart example…
Nouran S. Ahmad
  • 151
  • 9
3
votes
1 answer

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 access to developers (to avoid security…
RainSear
  • 131
  • 1
3
votes
1 answer

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 probably does not scale as well as 1 central pool. As…
Callam Delaney
  • 131
  • 1
2
votes
1 answer

Best strategy/architecture to deploy dozens websites with PostgreSQL in Kubernetes

I am working on a Kubernetes-based solution to host dozens of PHP websites (with future compatibility for Python/Node) using PostgreSQL as the database. The goal is to provide an environment similar to traditional hosting solutions like Plesk or…
mapedraza
  • 21
  • 1
2
votes
1 answer

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 on a read-only filesystem because of locking.) So I created…
peschü
  • 131
  • 4
2
votes
1 answer

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 found ?
hvannia
  • 31
  • 1
1
vote
1 answer

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 rights does the postgres user have? What is the upside…
omar amine
  • 21
  • 3
1
vote
1 answer

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

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 not match: old "C.UTF-8", new "en_US.UTF-8", I…
user8517
1
vote
0 answers

Why primary PostgreSQL server hangs on start with synchronous streaming replication

I'm a developer but I need to setup synchronous streaming replication for PostgreSQL server. I have two services defined in docker compose (for testing purpose): yams-poc-postgres: image: postgres:17 container_name: yams-poc-postgres …
Sarrus
  • 111
  • 1
1
vote
1 answer

Docker and host IP migration times out on Postgres import

I have a host machine running a postgresql docker container listening and exposing port 5432 on the host. I had a set of scripts that upload a large set of records from a CSV using PySpark and psycopg2 into the postgres container. When I modified…
Philoxopher
  • 111
  • 1
1
2 3