Search Results
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 |
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 …
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 …
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.
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 …
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 …
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 …