Questions tagged [postgresql]
PostgreSQL, often simply Postgres, is an object-relational database management system (ORDBMS) available for many platforms including Linux, FreeBSD, Solaris, Microsoft Windows and Mac OS X.
365 questions
2 votes
1 answer
100 views
PostgreSQL 15 container with data directory mounted as host bind mount
I'm trying to create PostgreSQL container with bind mounted host directory in it as the PostgreSQL data directory. Doing it according to official PostgreSQL docker image documentation and Example from ...
- 455
-2 votes
2 answers
81 views
How to check version of PostgreSQL available on pacman?
Is there a way I can check what version of PostgreSQL is available on pacman without needing to install it first? I know I can install it and then run the following SQL to get the version: SELECT ...
-1 votes
1 answer
68 views
PostgreSQL: When would be mandatory use the "manually configure the Apt repository" approach?
To install PostgreSQL in either Debian or Ubuntu according with the official docs: Linux downloads (Debian) Linux downloads (Ubuntu) Exists the PostgreSQL Apt Repository section where exists two ...
- 2,206
0 votes
0 answers
66 views
Ubuntu Server 24.04 difficulty with uninstalling Postgresql
I have packages that I need to remove including postgresql-client-16, postgresql-client-18, postgresql-client-common and postgreql-common. Whenever I try to remove/purge any of them I get a message ...
- 1
0 votes
0 answers
148 views
can't install pgAdmin4 desktop on arch linux
I need your help! I'm trying to install pgAdmin4 desktop version on my Arch system. I am getting libfakeroot internal error: payload not recognized! while building package for pgadmin4-server(which is ...
- 3
2 votes
1 answer
155 views
systemd-tmpfiles doesn't create /run/postgresql at reboot, but does when called manually with --create
I have a problem related to a few already answered here in the past, but the solutions offered for them already appear to be in place for me: /var/run/postgresql missing after reboot Tired of ...
- 123
0 votes
0 answers
71 views
Manually Installing PostgreSQL from Packages
I'm in the process of bringing my server to life. I have already installed Proxmox onto it and now I'm in the bootstrapping stage whereby I'm planning to manually install a minimum number of VMs to ...
- 1
0 votes
1 answer
74 views
ldd /usr/bin/pg_restore gives error not a dynamic executable
I am trying to determine the libraries needed for pg_restore in the official postgres:15 docker image, but when I run ldd /usr/bin/pg_restore inside the container it returns this error: not a dynamic ...
- 103
1 vote
1 answer
79 views
How to replace source list in old postgres:9 image before effectively run apt-get update
I would like to install java in final dockerfile stage from postgres:9, and I have to change following outdated addresses: RUN sed -i s/deb.debian.org/archive.debian.org/g /etc/apt/sources.list RUN ...
0 votes
1 answer
753 views
How to install Postgresql17 to my EC2 instance on Amazon Linux [duplicate]
I'm trying to install postgres version 17 on my EC2 instance on Amazon Linux but I get this error: [ec2-user@ip-172-31-8-1 ~]$ sudo dnf install -y postgresql17 postgresql17-server Last metadata ...
Samantha Chan
0 votes
1 answer
887 views
system ID mismatch, node belongs to a different cluster
I have etcd cluster, and now trying to initialize patroni (on server A and server B), but whenever I try to do so I'm getting the error about cluster mismatch. Tried removing 'initialize' from etcd, ...
- 11
1 vote
1 answer
165 views
/proc/pid exists but does pid not found in ps
I am seeing a very odd behavior. /proc/1154/cmdline exists, and kill -0 1154 succeeds, but ps -ef | grep 1154 and ls /proc | grep 1154 do not show anything. 1154 was a postgres process in the middle ...
0 votes
1 answer
516 views
Cannot install postgres on Centos 7 as signature cannot be verified/gpg keys not imported
I am currently trying to access a postgres 12 RDS on a private VPC through an EC2 instance on the same VPC, and in order to do so I am trying to install postgres on this instance (which is a Centos 7 ...
- 1
0 votes
1 answer
287 views
An ALTER USER postgres PASSWORD 'postgres' fails when provisioning vagrant with Postgresql
I'm provisioning a vagrant box with Postgresql. It looks going well, but at the end, it cannot run an ALTER USER postgres PASSWORD 'postgres'; for a Permission denied. Here's what I'm doing, and what ...
- 2,499
-3 votes
1 answer
706 views
Issue with postgre database creation in Kali Linux
I just installed postgresql 16 on my Kali Linux. It's working perfectly but when I try to create a database (using the correct command line), it gives me this feedback : postgres=# create database ...
