Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options answers only not deleted user 7119

A widely-used open-source operating system that is particularly popular on servers.

0 votes

PostgreSQL/ Linux, way to have DNS forward to a port/cluster?

The "friendly name" functionality is available client-side through the Connection Service File: The file uses an "INI file" format where the section name is the service name and the parameters …
Daniel Vérité's user avatar
14 votes
Accepted

How do I access Postgres when I get an error about "/var/run/postgresql/.s.PGSQL.5432"?

psql: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"? This error gene …
Daniel Vérité's user avatar
8 votes

Easy Postgresql master/slave replication with automatic failover on Linux?

Have a look at repmgr. It's a free software product that is meant to manage failovers and switchovers with PostgreSQL built-in replication.
Daniel Vérité's user avatar
5 votes
Accepted

psql \set an environment variable from the existing shell environment

psql version 15 provides the \getenv metacommand to do this efficiently: \getenv psql_var env_var Gets the value of the environment variable env_var and assigns it to the psql variable psql_var. If e …
Daniel Vérité's user avatar
3 votes
Accepted

pg_dump is not the same version as psql

The output of pg_lsclusters indicates that Postgres 12 binaries were uninstalled without removing the Postgres 12 instance first. Notice how the Status column says binaries_missing. The removal script …
Daniel Vérité's user avatar
2 votes
Accepted

Issue working with Postgres on Windows

The PSQL Console in pgadmin3 consists of opening a terminal and running psql --username yourname [other options] dbname inside it for you, with yourname and dbname being taken from what you've used to …
Daniel Vérité's user avatar