Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system.
666
questions
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-...