Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system.
666
questions
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 ...
- 26.3k
0
votes
2
answers
5k
views
How to connect Datagrip on Ubuntu (WSL) inside Windows
I have installed Ubuntu ecosystem from Microsoft Store (https://www.microsoft.com/en-us/p/ubuntu/9nblggh4msv6?SilentAuth=1&wa=wsignin1.0).
After setting up the environment, I installed postgres, ...
- 240
15
votes
3
answers
86k
views
How to start PostgreSql
When I am running this command below:
sudo -u postgres psq
I get this error message below:
psql: could not connect to server: No such file or directory
Is the server running locally and ...
- 21
0
votes
1
answer
1k
views
Can not start postgresql due to perl error
I have installed postgres on my Ubuntu, when I try to run the psql command I am getting following error:
$ psql
Can't locate POSIX.pm: /usr/local/lib/x86_64-linux-gnu/perl/5.22.1/POSIX.pm: ...
- 1
2
votes
1
answer
15k
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
...
- 187
23
votes
5
answers
90k
views
Uninstall an specific version of PostgreSQL
I have Postgresql 9.1.1 in my Ubuntu 12.04 which got installed due to automatic upgrades and whenever I uninstall it using the command:
sudo apt-get --purge remove postgresql-9.1.1
I get an error ...
- 375
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 ...
- 375
13
votes
5
answers
81k
views
"postgres: command not found" / after regular install of postgres and configure new data directory
I am setting up a POSTGRESQL on a UBUNTU 16.04 server:
I followed the explanation given here, I did:
The install:
sudo apt-get install postgresql postgresql-contrib`
The setup of postgres user and ...
- 123
3
votes
1
answer
286
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
-3
votes
1
answer
153
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 ...
- 115k
3
votes
3
answers
15k
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:...
- 399
0
votes
2
answers
4k
views
Trouble with rake db:setup
I am trying to pull a GitHub file using rake db:setup, but I get an error every time, no matter how many times I reinstall postgresql or check Rails. Here's the error I'm getting:
hifriend@...
CommunityBot
- 1
1
vote
0
answers
619
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
...
- 111
0
votes
0
answers
111
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)
- 115k
0
votes
0
answers
183
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
90
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: ...
- 90.1k
0
votes
1
answer
4k
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 ...
- 203
2
votes
3
answers
4k
views
Error while installing pip install pgadmin4-1.4-py2.py3-none-any.whl
I am new to Ubuntu and I am trying to install pgadmin4 with
pip install pgadmin4-1.4-py2.py3-none-any.whl
But received the following error while installing pgadmin4:
Command "python setup.py ...
- 375
0
votes
0
answers
126
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 ...
- 1
1
vote
1
answer
70
views
Installing mit-scheme alongside postgres
I recently started reading structure and interpretation of a programing language and as such I want to install the mit-scheme interpreter but I realized whenever I installed it, it uninstalled ...
- 113
1
vote
1
answer
2k
views
how to remove postgres 9.3 and install 9.2
I want to install postgres 9.2 and remove 9.3 on ubuntu 13.04 , since I want to install a software and they recommand postgress 9.2, thank you
- 107
0
votes
1
answer
961
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 ...
- 22.2k
1
vote
1
answer
635
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 ...
- 312
3
votes
2
answers
10k
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 ...
- 22.2k
0
votes
1
answer
428
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 ...
- 18.1k
0
votes
1
answer
8k
views
Postgresql: can't start service database system was shut down
I install Postgresql using
sudo apt install postgresql postgresql-contrib
then I run
sudo systemctl restart postgresql
then I run
sudo systemctl status postgresql
It says
Active: active (exited) ...
CommunityBot
- 1
11
votes
4
answers
54k
views
How to uninstall the postgresql
I did try different ways of installing postgresql like version 9.5, version 9.6. I forgot how to install them, by doing this
sudo apt-get --purge remove postgresql
I can't uninstall them. Is there ...
- 123
3
votes
3
answers
98k
views
could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
When I want to open pgAdmin 4, this message appears:
could not connect to server: Connection refused Is the server running on host "127.0.0.1" and accepting TCP/IP connections on port 5432?
...
- 101
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 ...
- 26.3k
3
votes
1
answer
8k
views
Is it possible to 'export' an installed package
I need to install a software that runs only on Ubuntu 10.04. This software uses Postgres 9.0 client, which depends on libpq5 version 9.2.4-0ppa1~lucid
Version 9.2.4 is no more available on PPAs.
...
CommunityBot
- 1
50
votes
4
answers
147k
views
What is a masked service?
I would like to understand what a masked service is and how to unmask it if need be.
I have been trying to start PostgreSQL on Ubuntu 16.04-LTS using the command
systemctl start postgresql.service.
...
- 101
-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.
- 141
113
votes
27
answers
605k
views
Can not connect to PostgreSQL listening on port 5432
I installed the Bitnami Django stack which included PostgreSQL 8.4.
When I run psql -U postgres I get the following error:
psql: could not connect to server: No such file or directory
Is the ...
- 1
0
votes
1
answer
6k
views
pgAdmin4 doesn't open the correct web browser
Context
I've installed pgAdmin4 using the APT installation procedure on Ubuntu 18.04 (default package without this new apt repository ships pgAdmin in version 3, which is deprecated).
This is how my ...
CommunityBot
- 1
1
vote
1
answer
132
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....
42
votes
4
answers
107k
views
Stopping a postgresql instance
For the sake of educational purposes I have two identical instances of postgresql running on my machine.
I can easily stop the service of the instance that is running on port 5432 like this :
sudo ...
- 113
47
votes
4
answers
162k
views
how to nicely stop all postgres processes
How do you nicely stop all postgres processes with pg_ctl (or otherwise), when you don't recall what the database directory is, nor have the PGDATA environment variable defined?
- 113
0
votes
0
answers
580
views
Unable to install postgreSQL 9.6 in Ubuntu 20.04 [duplicate]
It worked hundred times in my ci/cd pipeline, but suddenly stopped to work and idk what could I broke.
According to this and/or this, I do:
lsb_release -cs # just for debug
focal
echo "deb https:...
- 115k
2
votes
2
answers
3k
views
Not able to install pdo_mysql
I m using Ubuntu 18.04.2 LTS. After successful installation of php7.2-pgsql, I cant install pdo_pgsql. I have tried following command:
sudo apt-get install pdo_pgsql
and got this error:
E: Unable ...
- 101
200
votes
8
answers
742k
views
How do I find the path to pg_hba.conf from the shell?
I would like to obtain the path to pg_hba.conf from the shell. The path varies between versions of PostgreSQL. For instance, for 8.4 and 9.1:
/etc/postgresql/8.4/main/pg_hba.conf
/etc/postgresql/9.1/...
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/...
- 19
4
votes
2
answers
4k
views
PostgreSQL admin tool behind nginx
I have a VPS with PostgreSQL installed. I have a nginx setup with a some reverse proxies to different tools, grafana, Node.js sites and so on. I'm trying to setup PostgreSQL right now, and I just can'...
- 91
0
votes
2
answers
4k
views
Error: Could not find pg_ctl executable for version 11 (PostgreSQL 11) + let's encrypt
I have a VPS hosting with a domain redirecting to it.
I have LAMP stack for my main website using WordPress CMS.
Plus I am using Odoo as my back-end with python and PostgreSQL in a sub-domain.
...
- 11
0
votes
0
answers
503
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
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 ...
- 22.2k
0
votes
0
answers
941
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... ...
- 115k
0
votes
1
answer
379
views
unable to find package 'postgresql-12-citus-9.1'
I am following this documentation to install PostgreSQL and Citus extension:
# Add Citus repository for package manager
curl https://install.citusdata.com/community/deb.sh | sudo bash
# install the ...
- 1
0
votes
0
answers
228
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
3k
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. ...
- 82
1
vote
0
answers
481
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-...
- 18.1k