Questions tagged [postgresql]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
28 views

Install postgresql 12 on ubuntu 18.04 march 2024 [closed]

im trying to install postgresql 12 on ubuntu 18.04 but the repositories on postgresql website does not cover bionic, start on 20.04 (focal). Where can I find those repositories or in which way i can ...
rramirezsn's user avatar
0 votes
0 answers
20 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
402 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
1k 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
32 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
601 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
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 ...
Abol's user avatar
  • 43
0 votes
0 answers
144 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
  • 267
0 votes
0 answers
469 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
196 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
341 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
110 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
38 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
224 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
231 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
514 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
69 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
222 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
102 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
0 votes
1 answer
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 ...
Nick's user avatar
  • 1
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
13k 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
  • 365
0 votes
1 answer
5k 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
  • 365
3 votes
1 answer
252 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
181 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
143 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
579 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
100 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
8 votes
3 answers
16k 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
  • 598
0 votes
0 answers
170 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
87 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
3k 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
281 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
839 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
595 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
3 votes
2 answers
9k 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
403 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
  • 29
0 votes
0 answers
119 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
2k 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
118 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
10 votes
7 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: &...
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
0 votes
0 answers
480 views

HOW TO INSTALL postgreSQL 10.15 version on ubuntu 20.04

I want to install PostgreSQL 10.15 version on my ubuntu device, referred below link and tried installing the same but it shows error: https://www.postgresql.org/download/linux/ubuntu/ Reading package ...
dastagir shah's user avatar
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 ...
Egon Stetmann.'s user avatar
1 vote
1 answer
10k views

Postgresql 14 installation issue

I am new to Ubuntu and Linux in general. Im using ubuntu 22.04 and i am trying to install postgresql. I ve tried to troubleshoot the following error but i ve lost hours trying to do so, still not even ...
Stefan Miličić's user avatar
0 votes
0 answers
898 views

Cannot install PostgreSQL problem with libllvm10

I am trying to install PostgreSQL on Ubuntu 20. However, an errors occurs while installing. Could somebody help me please? $ sudo apt install postgresql postgresql-contrib Reading package lists... ...
Lukáš Hrmo's user avatar

1
2 3 4 5
14