Questions tagged [postgresql]

PostgreSQL is a powerful, open source object-relational database system.

Filter by
Sorted by
Tagged with
10 votes
8 answers
14k views

Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT

While trying to launch pgAdmin4, I receive the following error: Failed to launch pgAdmin4. Error: Error: spawn /usr/pgadmin4/venv/bin/python3 ENOENT This is the runtime environment: Python Path: &...
1 vote
2 answers
2k views

Installing postgresql. Last line says: 'could not change directory to "home/user": Permission denied'

I am getting ready for a coding bootcamp and have followed certain instructions to install Linux (Ubuntu v22.04). The installation went fine but then I am told to enter the following command into the ...
7 votes
3 answers
9k views

How to install and configure the latest ODBC driivers for both MYSQL & PostgreSQL in 18.04

I'm currently trying to get access to some MYSQL and PostgreSQL databases via an ODBC connection via an ODBC Administrator GUI as I had on Windows. After searching around, I have only found scattered ...
0 votes
1 answer
5k views

Can't read and change original pg_hba.conf in PostgreSQL 12

I can't to connect to aws remote ubuntu server where installed postgresql. And i want to connect from my pc to postgres on ubuntu i cant do that: Unable to connect to server: FATAL: no pg_hba.conf ...
0 votes
1 answer
6k views

how to fix Error: Port conflict: another instance is already running

I fired two command sudo apt-get update sudo apt-get upgrade It will give me error after upgrade(after press "Y") Setting up postgresql-9.1 (9.1.19-0ubuntu0.12.04) ... * Starting ...
0 votes
0 answers
29 views

Postgresql 12 unable to start on Ubuntu 20.04

I am trying to start postgresql 12 on an ubutu 20.04 server using the following command: pg_ctlcluster start 12 main I get the following error from journalctl: A start job for unit postgresql@12-main....
2 votes
1 answer
5k views

How to Backup a PostgreSQL Database From a Docker Container Using DBeaver?

I have a Postgres database running in a docker container in my machine (running Ubuntu 20.04 Beta) and I need to make a backup of it. I'm using DBeaver 7.0.2 to manage the database, but when I try to ...
0 votes
1 answer
182 views

Could not connect to PostgreSql Server (computer) from a client (Raspberry PI)

I followed the instructions as: https://ubuntu.com/server/docs/databases-postgresql This is what I did: Postgresql-server (On my Ubuntu desktop computer) # Installed the Postgresql server # Went to ...
0 votes
2 answers
19k views

How to create .s.PGSQL.5432?

I installed postgresql 9. By mistake,I deleted the .s.PGSQL.5432. Now i cant able to add server from pgAdmin. I don't have any server in on . How to create .s.PGSQL.5432? No such file or directory ...
3 votes
1 answer
5k views

Cannot get authorization to run pg_dumpall

All I am trying to do is backup my existing database cluster in order to upgrade from Postgresql 9.4.8 to 9.5. I am on Ubuntu 16.04. I am aware of this post: Postgres password authentication fails. ...
0 votes
1 answer
4k views

How to run and configure postgres when installed from snap?

Having installed postgres how do I now use it? postgres@mordor:~$ postgres@mordor:~$ whoami postgres postgres@mordor:~$ postgres@mordor:~$ pwd /home/postgres postgres@mordor:~$ postgres@mordor:~$ ...
1 vote
1 answer
1k views

directory permission error with postgresql

hello I installed postgres in WSL Ubuntu 22.04.1 and every time I log in get this error could not change directory to "/home/<user>": Permission denied how do I fix the denied ...
1 vote
2 answers
235 views

Partition UUID was changed automatically

I have an EC2 running on AWS cloud with the following specifications: Operating System: Ubuntu 22.04.1 LTS AMI ID: ami-07651f0c4c315a529 AMI Name: ubuntu/images/hvm-ssd/ubuntu-jammy-22.04-amd64-server-...
4 votes
1 answer
429 views

Running the command sudo -u postgres createuser -d -R -S $USER I get the message could not change directory to "/home/odoo": Access denied in Ubuntu22

I am trying to install postgresql on Ubuntu 22.04 and to do so I run the following command sudo apt install postgresql postgresql-client followed by that (in the next prompt) I execute the following ...
0 votes
0 answers
2k views

psql: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused

I checked a lot on the Internet to fix the problem but couldn't do anything. First of all, I changed my configuration based on here. listen_addresses = '*' port= 5432 data_directory = '/var/lib/...
0 votes
0 answers
652 views

psql: error: connection to server at "localhost" (127.0.0.1), port 5432 failed: Connection refused

I had a problem here psql: error: connection to server on socket Hello Everyone, I checked a lot on the Internet to fix the problem but couldn't do anything. First of all, I changed my configuration ...
0 votes
0 answers
33 views

my postgresql service is started but i am unbale start the server

root@raakeshmongo:~# psql -U postgres psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: No such file or directory Is the server running locally and ...
0 votes
2 answers
7k views

Postgresql refusing TCP/IP connection after ubuntu restart

This one has me baffled. I rebooted my ubuntu server and now I try to connect with pgadmin and I get the following: could not connect to server: Connection timed out (0x0000274C/10060) Is the server ...
1 vote
1 answer
5k views

Installed pgadmin4-apache2 package post-installation script subprocess returned error exit status 1

I'm trying to install pgAdmin4 desktop mode, Facing this Issue. It show pgAdmin4 and pgadmin4-apache2 installed. but while opening the pgAdmin4 application it display an error on popup Failed to ...
0 votes
1 answer
12k views

Postgres pg_hba.conf Configuration

I'm trying to develop a python application using Postgres. Unfortunately everytime I do a db.session.commit() I get this as an error: OperationalError: (OperationalError) fe_sendauth: no password ...
33 votes
3 answers
51k views

How do I set which PostgreSQL version is to be used by default?

I have 2 different versions of PostgreSQL installed on my system (Ubuntu Lucid): /var/lib/postgresql/8.4 /var/lib/postgresql/9.0 By default, when I run a PostgreSQL command such as createdb or psql, ...
1 vote
2 answers
28k views

Cannot use psql "sudo: unknown user" "sudo: unable to initialize policy plugin"

I've been working on a bot for Discord which utilizes a PostgreSQL database and I'm trying to install it on a Vultr server (Ubuntu 20.04). Everything is working fine until I get to the part where I'm ...
0 votes
1 answer
1k views

psql: error: connection to server on socket

After installation, I try to run the program also I tried many suggestions that have been published here but couldn't fix the problem :( Ubuntu 20.04 root@root:~$ psql psql: error: connection to ...
9 votes
3 answers
17k views

How to upgrade PostgreSQL from 14 to 15 on Ubuntu 22.04?

I have Ubuntu 22.04. I currently have PostgreSQL 14.6. I want to upgrade PostgreSQL to 15. I tried running: sudo apt-get update && sudo apt install postgresql but I got the following message: ...
4 votes
1 answer
6k views

Re-install of pgAdmin4 on Ubuntu 18.04 does not prompt for user/password and local pgAdmin site not found

I initially followed instructions to install postgres and pgadmin4 from https://tecadmin.net/install-pgadmin4-on-ubuntu/ successfully. I seemed to be able to get to the site at http://localhost/...
0 votes
0 answers
202 views

What's the port 5433 in postgres

The PostgreSQL default port is 5432, but I found two ports in Ubuntu, one is 5432, the other is 5433. # ss -nlapt | grep postgres LISTEN 0 200 127.0.0.1:5432 ...
0 votes
2 answers
193 views

How to drop a PostgreSQL tablespace

I'm just starting setting up PosgreSQL 12 on Xubuntu 20.04, so I have created some things as experiments, and I want to delete them and start over. Hopefully without destroying everything, because ...
0 votes
0 answers
499 views

Problem connecting to PostgresSql from Docker container

I have two Ubuntu Servers 20.04 with an external IP of 185.253.74.227 The first server has a local IP 192.168.1.30 on which I have nginx running and I host my Docker containers on it. The second ...
21 votes
5 answers
74k views

Install postgresql. Why is initdb unavailable?

I'm following these instructions, however I can only get to step 17.2. Despite installing postgresql successfully via the sudo apt-get install postgresql command, upon running initdb -D /usr/...
1 vote
1 answer
83 views

I was following a blog post to install postgresql and start getting this error while updating my OS [duplicate]

N: Ignoring file 'pgdg.listsudo' in directory '/etc/apt/sources.list.d/' as it has an invalid filename extension
0 votes
1 answer
210 views

postgres was not the same version as pg_ctl in PostgreSQL 12

As per the log files, I am getting the below errors. The program "postgres" was found by "/usr/lib/postgresql/12/bin/pg_ctl" but was not the same version as pg_ctl. Check your ...
0 votes
0 answers
354 views

I can't connect to pgAdmin, my password is right but telling to me some issue

connection failed: :1), port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? connection to server at "localhost" (127.0.0.1), port 5432 ...
1 vote
2 answers
1k views

How to import multiple postgres databases using single file in another ubuntu installation?

Is there a way to move all databases from Pgadmin 3 one ubuntu installation to another. I have created a big dump (a single file to export all database from one system). Now I want to import that big ...
3 votes
1 answer
26k views

ImportError: No module named gevent

I am new to the Python application development in Ubuntu. I would try to be concise but please forgive and ask me if my explanations are too unclear to understand. I would be appreciated for your ...
0 votes
1 answer
117 views

DbDriver warning & error for trying connection PostgreSQL & onlyoffice

I'm trying to connect my PostgreSQL database with the Onlyoffice System on my Ubuntu 22.04.3 LTS system. I use the instruction from https://helpcenter.onlyoffice.com/installation/docs-community-...
1 vote
1 answer
234 views

Make pg_createcluster create the config dir even though the data dir exists

We have an Ansible playbook that sets up PostgreSQL 15. It creates a new cluster using pg_createcluster, makes some changes to the config files that pg_createcluster creates (in /etc/postgresql/15/...)...
1 vote
0 answers
39 views

apt-get remove wants to remove and upgrade at the same time

I updated an installation of postgresql-14 following this document: https://www.kostolansky.sk/posts/upgrading-to-postgresql-15/ Everything worked fine until I entered sudo apt-get remove postgresql-...
0 votes
1 answer
238 views

Postgres SQL always returns error string

I have been having alot of postgresSQL issues mostly due to me not really understanding how it works very well, if at all. Whenever I try anything interacting with PostgresSQL i get this return psql: ...
0 votes
1 answer
538 views

postgresql 14 - s.PGSQL.5432 no such file

Installed ubuntu 22.04, postgresql v 14.9 - everything worked correctly. Rebooted the system, got an error: "connection to server on socket "/var/run/postgresql//.s.PGSQL.5432" failed: ...
0 votes
0 answers
70 views

postgresql with 5432 not able to connect remotely

I have the following configuration done: root@testubuntu:~# cat /etc/postgresql/14/main/postgresql.conf | grep -i listen listen_addresses = '*' # what IP address(es) to listen on; root@...
0 votes
0 answers
103 views

psql version incorrectly showing 15 instead of 14

psql version shows 15 but we have the version 14 cluster online, while 12 and 15 are down. 12 main 5433 down postgres /var/lib/postgresql/12/main /var/log/postgresql/postgresql-12-main.log 14 ...
1 vote
1 answer
294 views

Can't install PostrgreSQL 9.6 - Couldn't find any package by glob 'postgresql-9.6'

Given Ubuntu 22.04 I try to install PostgreSQL 9.6 (I need exact this version) like this: sudo apt-get update sudo apt-get upgrade sudo apt-get install postgresql-9.6 But get error: sudo apt-get ...
0 votes
0 answers
2k views

Error while install postgresql 15 [duplicate]

i have problem while installing postgresql on my ubuntu 22.04.03 , i was follow step-by-setp guide on postgresql page, and youtube but still have this problem Reading package lists... Done Building ...
9 votes
1 answer
34k views

Starting PostgreSQL server, postgres user unknown

I am trying to start a PostgreSQL server (9.3) on Ubuntu 14.04. I am following this standard tutorial: https://help.ubuntu.com/community/PostgreSQL After updating to from 13.10 to 14.04 I purged the ...
22 votes
11 answers
118k views

Postgresql server doesn't start

[Ubuntu 16.04] I installed postgresql 9.5 along with dependencies: sudo sh -c "echo 'deb http://apt.postgresql.org/pub/repos/apt/ xenial-pgdg main' > /etc/apt/sources.list.d/pgdg.list" wget --...
52 votes
3 answers
172k views

pg_ctl: command not found, what package has this command?

I have installed pgadmin using the ubuntu software center and am trying to access a local database (recently downloaded from the internet). I have tried to run the pg_ctl command (running as postgres) ...
1 vote
0 answers
48 views

Apache stopping

I am running Ubuntu22.04 on an EC2 VM. I have created a module to run under Apache, but there are 2 strange things happening. First, is that although it works fine during the day, overnight at some ...
147 votes
3 answers
167k views

How to install psql without Postgres?

I need the psql command line tools, but I don't need the actual Postgres RDBMS. This is to work with a package which supports a psql interface. Is it possible to install just psql? (Ubuntu 16.04)
2 votes
2 answers
24k views

How to install libpq-dev (14.0-1) on ubuntu 21.10?

I already have the postgresql of latest version(14.0-1.pgdg21.04+1). I want to setup dev environment for psycopg2(https://github.com/psycopg/psycopg2/) library locally and it requires libpq-dev for ...
2 votes
2 answers
2k views

postgresql-contrib-14 missing

Now that postgresql 15 is newly released, I'm scrambling to lock my many servers at 14. Does anyone know where the postgresql-contrib-14 package may be (Ubuntu Server 22.04)? There's a postgresql-...

1
2 3 4 5
14