Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [postgresql]

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

Filter by
Sorted by
Tagged with
-1 votes
1 answer
108 views

when i run pgadmin4 it gives this error: The pgAdmin 4 server could not be contacted: Ubuntu 24.04 LTS

I get this error every time I run pgAdmin4: Erorr: pgAdmin Runtime Environment Python Path: "/usr/pgadmin4/venv/bin/python3" Runtime Config File: "/home/diyorbek/.config/pgadmin/...
Diyorbek Saidov's user avatar
-1 votes
0 answers
57 views

Can't update or upgrade after I tried installing PostgreSQL

I can't update or upgrade after I tried installing PostgreSQL on my Ubuntu Conflicting values set for option Signed-By regarding source https://apt.postgresql.org/pub/repos/apt/ focal-pgdg: /usr/share/...
daniel boakye's user avatar
-1 votes
0 answers
21 views

My apt is broken after I tried to install Postgre SQl, now I am getting errors as listed [duplicate]

Title: Post gre broke my apt-get, getting Error: "Conflicting values set for option Signed-By regarding source" when trying to install packages I am not able to install any packages and I am ...
Viral Prajapati's user avatar
-1 votes
0 answers
19 views

How to install PostgreSQL 13.x or 14.x or 15.x in Ubuntu 24.04 [duplicate]

The default version of PostgreSQL in Ubuntu 24.04 is 16. I want to install PostgreSQL version 13 / 14 in Ubuntu 24.04 for a particular purpose. Please guide me.
Vimal Kumar Vazhappally's user avatar
0 votes
0 answers
12 views

How can I create a Postgres database installer for Ubuntu without internet access?

How can I create a Postgres database installer for Ubuntu without internet access? Or can I install a PostgreSQL database in Ubuntu without the internet?
Sagar Asane's user avatar
0 votes
0 answers
83 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....
M_K_'s user avatar
  • 1
4 votes
1 answer
602 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 ...
Enmanuel Otero Montano's user avatar
0 votes
0 answers
3k 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/...
Abol's user avatar
  • 43
0 votes
0 answers
56 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 ...
Rakesh's user avatar
  • 1
0 votes
0 answers
956 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 ...
Abol's user avatar
  • 43
0 votes
1 answer
2k 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 ...
Abol's user avatar
  • 43
0 votes
0 answers
330 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 ...
stackbiz's user avatar
  • 337
0 votes
0 answers
673 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 ...
malboro_way's user avatar
0 votes
1 answer
322 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 ...
Anubhav Ranjan's user avatar
0 votes
0 answers
413 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 ...
Jackie's user avatar
  • 1
0 votes
1 answer
148 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-...
Snorlax's user avatar
1 vote
0 answers
42 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-...
OrbImp's user avatar
  • 11
1 vote
1 answer
323 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/...)...
EM0's user avatar
  • 229
0 votes
1 answer
284 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: ...
Fluffery's user avatar
0 votes
1 answer
757 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: ...
fresco's user avatar
  • 1
0 votes
0 answers
99 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@...
Javeed Basha Shaik's user avatar
1 vote
2 answers
288 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-...
Kent Ho's user avatar
  • 11
0 votes
0 answers
104 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 ...
opensource-developer's user avatar
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 ...
Firman ismail Hariri's user avatar
1 vote
2 answers
3k 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 ...
Nick's user avatar
  • 11
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 ...
David Buch's user avatar
1 vote
0 answers
51 views

npm package connect-pg-simple webpack issue while creating session

Getting issue with [email protected] package while building app using webpack Line of code generating below issue "ERROR in ./node_modules/connect-pg-simple/index.js 82:4 Module parse ...
Amanpreet Singh Khanna's user avatar
2 votes
1 answer
18k views

unable to connect to server: connection failed: connection refused is the server running on that host accepting tcp/ip connections?

I have postgres 13.10 and PGAdmin4 7.1 installed on Ubuntu 22.04 In PGAdmin4 UI, I want to "add new server" with these configurations name postgres-local username postgres pw postgres ...
Tms91's user avatar
  • 395
0 votes
1 answer
6k views

"Unable to connect to server: connection failed: FATAL: password authentication failed" on brandly installed postgres and PGAdmin4

I want to create a new server and a new postgres database from the PGAdmin4 UI just-installed on Ubuntu 22.04 I already did this before but I don't remember how did I do id. The server I created last ...
Tms91's user avatar
  • 395
3 votes
1 answer
334 views

sudo apt update: Malformed entry 1 in list file /etc/apt/sources.list.d/pgdg.list

I have been trying to install pgadmin4 for a while, (but no success) so I can have a GUI to navigate postgresql server. Don't why but simple update command is also failing now. What did I do? where is ...
Mainland's user avatar
  • 133
0 votes
1 answer
215 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 ...
Mainland's user avatar
  • 133
-3 votes
1 answer
170 views

Configure postgresql from CUBIC chroot

I'm customizing a Lubuntu 22.04 image to have a ready-to-use environment after installation. One of the points - I need to have postgresql installed and configured, means that a database is created ...
meridbt's user avatar
  • 101
1 vote
0 answers
675 views

WSL Ubuntu: Sometimes postgresql won't start but the next day it would start again

This is my wsl -l -v NAME STATE VERSION * Ubuntu Stopped 2 lsb_release -a output: No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.04.1 LTS ...
JS3's user avatar
  • 111
0 votes
0 answers
115 views

My Postgres always shutdown in a while (around 1 hour)

I have a problem about Postgres and Ubuntu VPS. My service always shutdown without no reason. Below is Postgres's log. Could anyone take a look at this situation please? (Click image to enlarge)
Tim Dang's user avatar
9 votes
3 answers
22k 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: ...
vvvvv's user avatar
  • 628
0 votes
0 answers
191 views

PostgreSQL installation hangs after password prompt

I am trying to install PostgreSQL on an AWS cloud CPU instance (instance type: c5.24xlarge, Ubuntu 20.04 LTS). I have tried both sudo apt install postgresql postgresql-contrib, as well as installing ...
Stormlight's user avatar
1 vote
0 answers
100 views

Ubuntu XWiki Tomcat Upgrade

System Information: Description:    Ubuntu 22.04.1 LTS Release:        22.04 Codename:       jammy Server version: Apache Tomcat/9.0.58 (Ubuntu) Server built:   Jan 6 1970 15:09:28 UTC Server number:  ...
Daniel's user avatar
  • 11
0 votes
1 answer
5k views

Trouble using pg_restore or psql or pgAdmin4 to restore a postgres db backup

This is low stakes and just a practice run for when I urgently need to do it, and also to confirm that pg_dump worked to satisfaction. I am trying to use psql or pg_restore to restore my copy of a ...
plutownium's user avatar
1 vote
1 answer
340 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 ...
Alexei's user avatar
  • 111
0 votes
1 answer
1k views

my postgreSQL doesn't give me password option when installing

postgreSQL application doesn't ask me for a password when installing it to my machine. I don't know if that is why none of password i entered in my terminal is being rejected. Please how do i solve ...
Eze's user avatar
  • 3
1 vote
1 answer
697 views

How access db postgres with other user

I'm new to postgres. I created a postgres docker container; when I access through the command "psql -U postgres" I access regularly and the prompt becomes like this: postgres=#. (At the ...
Erica9595's user avatar
4 votes
2 answers
11k views

apt-get install postgresql-client says I'm upto date but I'm not

I'm running Ubuntu 18.04 on an AWS box. I have postgresql 10.22. We just update the rds and, apparently, 10.22 is not compatible with pg server version 14. So I want to upgrade. I ran $ sudo apt-get ...
davemenc's user avatar
0 votes
1 answer
468 views

Using PostgreSQL 12.12 pg_ commands in Ubuntu 20.04 not working

I've installed PostGreSQL 12.12 with: sudo apt install postgresql postgresql-contrib libpq-dev But I'm seeing errors with pg_ commands. For example, this is the error when trying to setup ...
ronald's user avatar
  • 39
0 votes
0 answers
136 views

Error connecting to postgressql after moving to new drive

Real head scratcher today that I am hoping someone might be able to help out with. I have an Ubuntu 22.04 LTS server and I am trying to install and configure postgressql on the server. The intent is ...
FRALEWHALE's user avatar
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-...
richard coleman's user avatar
0 votes
0 answers
3k views

Unmet dependencies error when installing postgresql 13 in Ubuntu 20.04

I am using this tutorial to install postgresql on my VM but when i am running https://www.how2shout.com/linux/how-to-install-postgresql-13-on-ubuntu-22-04-lts-linux/ sudo apt install postgresql-13 I ...
Himanshu Chugh's user avatar
-1 votes
1 answer
45 views

in which Ubuntu package is pgsql? [closed]

I would like to install pgsql without PostgreSQL. Is it possible? When I search the web, pgsql looks like lemmified to postgresql.
lalebarde's user avatar
  • 141
1 vote
1 answer
145 views

connecting pgadmin4 to the local postgresql through a unix socket

I installed pgadmin4 following the instructions found here I'd like to connect it to the locally running postgresql service through a Unix socket I have $ sudo ls -lha /var/run/postgresql/14-main....
Adriano Peluso's user avatar
12 votes
9 answers
16k 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: &...
Magsad Novruzov's user avatar
0 votes
0 answers
3k views

postgres 12 suddenly stop accepting connection: connection to server on socket "var/run/postgresql/.s.pgsql.5432 failed no such file or directory

I don't know whats going on, my database just stop running. suddenly when I want to run postgres using user postgres ($postgres psql), it gives me error "connection to server on socket "var/...
padjee's user avatar
  • 19

1
2 3 4 5
14