Unix and Linux Stack Exchange
Unix and Linux Stack Exchange

Questions tagged [postgresql]

PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.

It implements the majority of the SQL:2008 standard, is ACID-compliant, is fully transactional (including all DDL statements), has extensible data types, operators, index methods, functions, aggregates, procedural languages, and has a large number of extensions written by third parties.

338 questions
103
votes
4 answers

Command to list PostgreSQL user accounts?

There are createuser & dropuser commands: createuser - define a new PostgreSQL user account dropuser - remove a PostgreSQL user account Is there a corresponding way to list the user accounts? These two commands do not require the user to invoke…
CW Holeman II
  • 3,654
  • 5
  • 31
  • 49
102
votes
3 answers

Install PostgreSQL client (psql) only on CentOS

Simple question, but no resources found about this. Is there any way to install only a PostgreSQL client, the terminal-based one, psql, on a CentOS7 system, without installing the complete PostgreSQL server? There is no dedicated postgresql-client…
Aleksandar Stojadinovic
  • 1,155
  • 2
  • 8
  • 7
43
votes
7 answers

Couldn't find postgresql.conf & pg_hba.conf files in my postgresql installation

Following all the instructions from UNIXMEN, installed postgresql-9.4 in CentOS 6.4. Everything went well, started the service and could access pgsql screen. But when I try to configure the phpPgAdmin, I couldn't find the files postgresql.conf …
GIRI
  • 877
  • 3
  • 13
  • 17
22
votes
4 answers

Unable to start posgtresql, the reason isn't clear

I've installed postgresql by pacman. Now I'm trying to run it: $ sudo systemctl start postgresql Job for postgresql.service failed because the control process exited with error code. See "systemctl status postgresql.service" and…
Matudi
  • 403
  • 1
  • 5
  • 6
22
votes
3 answers

What network protocols does a Postgres database server use?

I have a postgres 9.1 server running on the default port 5432 on an Ubuntu 12.04 cloud server. I want to open up the port, so I can make remote queries -- but I have to open the port on IP tables, which requires that I specify a protocol. This doc…
bernie2436
  • 6,505
  • 22
  • 58
  • 69
20
votes
3 answers

Systemd postgresql start script

I'm in the process of installing postgresql onto a second server Previously I installed postgresql and then used the supplied script ./contrib/start-scripts/linux Placed into the correct dir # cp ./contrib/start-scripts/linux…
TheLovelySausage
  • 4,183
  • 9
  • 30
  • 49
14
votes
1 answer

Docker postgres "psql: FATAL: role "root" does not exist"

I started a postgres docker container using sudo docker run --name some-postgres -d postgres and then attempted to connect to it using sudo docker run -it --rm --link some-postgres:postgres postgres psql -h postgres which gives the error psql:…
Qwertie
  • 1,234
  • 3
  • 14
  • 28
14
votes
1 answer

Why does `postgres` require a shell?

In my Debian Wheezy systems, I noticed that the postgres user 'postgres', the "PostgreSQL administrator", uses /bin/bash as shell. However, I cannot figure out why this is needed. Changing this to /bin/false still allows me to use the command…
timothymctim
  • 356
  • 1
  • 7
13
votes
2 answers

How to change the path of shared libraries shown by ldd?

I am trying to make the postgis extension work on my system and it always spits out "$libdir/postgis2.2" no such file or directory error. For my curiosity I executed "ldd postgis-2.2.so" and it spits out the following result : linux-vdso.so.1 =>…
AnkitSablok
  • 303
  • 1
  • 2
  • 7
12
votes
3 answers

"psql: could not connect to server: No such file or directory"

Actually, I installed PostgreSQL 9.4 (with postGIS extension), and when installed, everything used to work fine. As said on many tuts, I've set the /data folder, checked configuration files, and so on. Worked on other projects so I did not work on…
Julo0sS
  • 255
  • 1
  • 3
  • 7
9
votes
3 answers

Unable to locate package postgresql-server-dev?

I am trying to install the following packcage postgresql-server-dev-9.5. Using sudo apt-get install postgresql-server-dev-9.5 Now, after I run this command I get this error: Unable to locate package postgresql-server-dev-9.5. Couldn't find any…
Keselme
  • 223
  • 1
  • 2
  • 6
9
votes
1 answer

How do I configure postgres's authorization settings in nixos?

On nixos, I face a postgres error psql: FATAL: Peer authentication failed for user "postgres" similar error to this question, and would like to edit the authentication settings to resolve the issue as described in an answer there: edit pg_hba.conf…
mherzl
  • 1,409
  • 2
  • 18
  • 31
8
votes
5 answers

pg_dump version mismatch on Debian

I'm running PostgreSQL on Debian Unstable/Sid. I've got the current versions (9.1) of postgresql, postgresql-client, postgresql-client-common (143) installed. The problem I'm having is trying to run pg_dump. I'm getting this error: pg_dump: server…
supercheetah
  • 864
  • 2
  • 8
  • 13
8
votes
2 answers

Why can't I connect to Postgres in Docker?

I used docker-compose from the Openpoiservice project.  Both Docker containers were launched successfully. kshnkvn@kshnkvn-vb:~$ docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS …
kshnkvn
  • 207
  • 1
  • 4
  • 8
8
votes
3 answers

install postgresql-12 in CentOS-8 got No match for argument: postgresql12

I am trying to install postgresql-12 in CentOS-8 I added the postgresql repository according to postgresql.org website https://www.postgresql.org/download/linux/redhat/ dnf install…
Cloud-Lover
  • 183
  • 1
  • 1
  • 4
1
2 3
…
22 23