Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system.
666
questions
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....
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
...
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/...
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 ...
0
votes
0
answers
602
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
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 ...
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 ...
0
votes
0
answers
470
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 ...
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 ...
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 ...
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-...
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-...
1
vote
1
answer
225
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/...)...
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: ...
0
votes
1
answer
515
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
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@...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
-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 ...
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
...
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)
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:
...
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 ...
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: ...
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 ...
1
vote
1
answer
282
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
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 ...
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 ...
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 ...
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 ...
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 ...
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-...
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 ...
-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.
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....
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: &...
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/...
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 ...
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
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 ...
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... ...
0
votes
0
answers
221
views
PostgreSQL - Export data with copy command uses huge memory resources
I am using CopyManager from Java to export data from PostgreSQL (data size around 1GB) and there is no problem with it Running "COPY (" + sql + ") TO STDOUT WITH (FORMAT CSV, HEADER)&...