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
84
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
70
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
55
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,196
0
votes
0
answers
51
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
133
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
136
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
66
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
66
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
66
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
715
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
858
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
144
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
501
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
264
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,467
-3
votes
1
answer
692
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 ...
