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:

33 questions
4
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
  • 241
  • 2
  • 7
0
votes
1 answer

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 regarding this setup: What is the default user of…
omar amine
  • 21
  • 3
0
votes
0 answers

Issues Setting Up PostgreSQL Read Replica Across Datacenters

I'm working on setting up a read replica for PostgreSQL across two datacenters over the internet. As part of the setup, I've modified the pg_hba.conf file on the primary server (server-a) to include the following: host replication …
Chris
  • 101