Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system.
658
questions
1
vote
0
answers
16
views
npm package connect-pg-simple webpack issue while creating session
Getting issue with connect-pg-simple@8.0.0 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 ...
0
votes
0
answers
27
views
I am running a postgresql database on an Ubuntu VM, via digital ocean but it loses connection to my heroku app [closed]
I am working on an aspnet app which is hosted on Heroku, and connects to a postgresql database running on digital ocean Ubuntu VM. Using Ubuntu 16.04.5 and postgresql 9.5.24. All has worked fine for ...
- 101
1
vote
1
answer
253
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
...
- 227
0
votes
1
answer
136
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 ...
- 227
3
votes
1
answer
99
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 ...
- 133
0
votes
0
answers
32
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 ...
- 133
-3
votes
1
answer
36
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
0
votes
0
answers
199
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
...
- 101
0
votes
0
answers
29
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)
- 1
2
votes
1
answer
2k
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:
...
- 388
0
votes
0
answers
69
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 ...
0
votes
0
answers
55
views
How to pin PGDG postgresql 15 at major version?
I am trying to Pin my postgresql installation from PGDG at major version 15. So in /etc/apt/preferences.d/pgdg.pref I've put:
Package: *
Pin: origin apt.postgresql.org
Pin-Priority: 1001
Package: *
...
- 101
1
vote
0
answers
58
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: ...
- 11
0
votes
0
answers
80
views
re-install POSTGIS after server update to Ubuntu 22.04.1 LTS
The server running Postgres + POSTGIS was upgraded to Ubuntu 22.04.1 LTS.
When I tried to run POSTGIS specific queries I got (e.g select * from my gis_table):
ERROR: could not access file "$...
- 101
0
votes
1
answer
681
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 ...
- 163
0
votes
0
answers
29
views
Ubuntu stays stuck in the load screen
I was installing PostgreSQL in the Ubuntu 22.04.1 LTS and I don't remember exactly how it was but I used sudo apt-get install postgresql when suddenly I couldn't enter to any app because it said I had ...
0
votes
0
answers
82
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 ...
- 101
0
votes
1
answer
74
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 ...
- 3
1
vote
1
answer
256
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 ...
- 11
2
votes
2
answers
1k
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 ...
- 21
0
votes
1
answer
168
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 ...
- 19
0
votes
0
answers
83
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 ...
- 163
0
votes
0
answers
261
views
Configure postgresql after installation with snap
I just installed Ubuntu Server 22.04.1 on a Raspberry Pi 4 in order to use it as a postgreslql server.
Unfortunately, for compatibility reasons, I can't use a current postgresql version, but needed to ...
- 101
2
votes
2
answers
690
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
762
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
42
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.
- 141
1
vote
1
answer
77
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....
0
votes
0
answers
102
views
Permissions error when creating user on postgresql for odoo
I am following this tutorial to install Odoo on Ubuntu, but I get this error with command sudo -u postgres createuser -s $USER:
could not change directory to "/home/hugolvc/Documents/Code/odoo/...
- 125
0
votes
0
answers
177
views
Trying to install package postgresql-server-dev-all gives error
I'm trying to install the package postgresql-server-dev-all but I take the following error:
Some packages could not be installed. This may mean that you have
requested an impossible situation or if ...
- 1
7
votes
6
answers
7k
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: &...
- 111
0
votes
0
answers
236
views
psql: error: connection to server at "5.199.162.56", port 5432 failed: Connection refused
The Postgres tutorial I followed
First small image shows the error,
Second Image Shows what I have done before
Also Gave the tutorial link I followed
upto the error point everything seemed to work ...
0
votes
0
answers
2k
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/...
- 19
0
votes
0
answers
198
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 ...
0
votes
1
answer
529
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
how do I fix the denied permission?
- 628
0
votes
1
answer
5k
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
488
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
144
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)&...
- 1
0
votes
2
answers
2k
views
How can I connect to postgres using the IP address of the localhost?
This is a new installation of Ubuntu 20.04 on OCI. Postgres database has been installed and is running fine. The problem is I am unable to connect to the database using the IP address of the host. ...
1
vote
0
answers
277
views
setting up Postgres with wsl
So I recently came across wsl and was trying to configure postgres with it but I am not able to do so, I am following these instruction - https://docs.microsoft.com/en-us/windows/wsl/tutorials/wsl-...
0
votes
0
answers
25
views
Download pgAdmin4 on Ubuntu 22.04 [duplicate]
I'm trying to download pgAdmin4 on Ubuntu 22.04 Desktop but it shows this:
E: The repository 'https://ftp.postgresql.org/pub/pgadmin/pgadmin4/apt/jammy pgadmin4 InRelease' is not signed.
N: Updating ...
0
votes
0
answers
30
views
Migrate PostgreSQL DB from Multipass to Cloud?
I have a PostgreSQL database running on Ubuntu in a Canonical Multipass instance on MacOS. I'd like to migrate its data to a cloud DB (Digital Ocean in this case). Is it possible to publicly expose ...
- 101
1
vote
2
answers
801
views
Cannot update/remove/reinstall postgresql 14
On Ubuntu 21.10,
When trying to do anything with apt on package postgresql (Ubuntu 14.4-1.pgdg21.10+1), the process hangs on the Setting up postgresql-14 [...] line :
$ sudo apt remove postgresql
...
3
votes
3
answers
8k
views
Run Pgadmin 4 on ubuntu 22.04
Installed pgadmin4 using this tutorial https://www.pgadmin.org/download/pgadmin-4-apt/ with the difference I just downloaded their https://www.pgadmin.org/static/packages_pgadmin_org.pub and put it as:...
- 63
0
votes
0
answers
94
views
Multipass + microk8s + pgadmin4
How can I connect a host-based pgadmin4 to postgres database on microk8s on multipass?
0
votes
0
answers
26
views
Errors while installing PostgreSQL [duplicate]
sudo apt-get -y install postgresql postgresql-contrib
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may ...
0
votes
0
answers
328
views
Docker postgres shared memory segment exceeded available memory
I am trying to run an image that contains PostgreSQL. When I am trying to run the image, it exits with the following error in the logs.
This error usually means that PostgreSQL's request for a shared ...
0
votes
1
answer
198
views
Trouble with connection to PostgreSQL server on VPS Server
I'm trying to configure a database on my personal VPS server on Veesp, but it just doesn't work whatever I do. I configured both of pg_nba.conf and postgresql.conf files, so I can connect from ...
- 1
0
votes
1
answer
37
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 ...
- 432
1
vote
0
answers
22
views
Why does writing to a PostgreSQL database (docker) shows some activity in the Network panel of the system monitor
A quick, yet simple question that came to my mind while observing my system monitor (I was curious on the RAM and CPU usage) while writing a massive data set to a PostgreSQL database hosted on my ...
- 1,138
0
votes
0
answers
1k
views
Trying to install a specific version of postgres, how do I know what version of libpq5 to install?
Viewing the answer in this thread - How to install libpq-dev (14.0-1) on ubuntu 21.10? -
Just install the required version of libpq5 and reinstall libpq-dev:
sudo apt-get install libpq5=13.4-1
sudo ...
- 253