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.
357 questions
1vote
1answer
23views
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 ...
0votes
1answer
154views
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
0votes
1answer
455views
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, ...
- 1
1vote
1answer
79views
/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 ...
0votes
1answer
385views
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 ...
0votes
1answer
174views
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,313
-3votes
1answer
393views
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 ...
0votes
1answer
111views
Can't start new PostgreSQL installation on Bazzite
I've recently installed Bazzite (an atomic Fedora variant) and want to get PostgreSQL running so I can continue an online development course I'm taking. I opened BoxBuddy (a.k.a. Toolbox) and ...
0votes
0answers
95views
Unable to start posgtresql on AlmaLinux 8.4
I’ve been working with the database for over a year, but after rebooting the server I can’t start postgresql: Job for postgresql.service failed because a fatal signal was delivered causing the control ...
0votes
1answer
44views
How to escape symbols inside runuser command?
I want to get list of PostgreSQL databases. PostgreSQL works by postgres user, so I need to use runuser. While I'm execute runuser -l postgres -c 'psql -tc "SELECT datname FROM pg_database WHERE ...
- 127
0votes
2answers
175views
Find out if user name and database are matching | grep
I found that grep -w 'desired_string' should deliver just lines exactly desired_string, but not desired_string-22 or any variant. What I need is a check if a certain Postgres database is owned by a ...
- 11
0votes
1answer
290views
Why do some repositories configured in /etc/apt/sources.list.d/ not have a signed-by= set? - Is that a problem?
Most third-party repositories configured in /etc/apt/sources.list.d have a signing key configured like this for example: deb [signed-by=/etc/apt/keyrings/lutris.gpg] https://. However, some like the ...
- 4,608
0votes
1answer
315views
postgresql service down, "/run/postgresql/.s.PGSQL.5432" failed: No such file or directory
i on artix with runit postgresql have issues after starting #sudo sv start postgresql ok: run: postgresql: (pid 849) 1236s #sudo -u postgres psql psql: error: connection to server on socket "/run/...
1vote
0answers
163views
Ubuntu service - pq: password authentication failed for user "root"
I have an application running on Ubuntu server that's using PostgreSQL. I can run the application's executable (as a non-root user) from the project's directory. I have created a service for this ...
- 111
1vote
2answers
775views
PostgreSQL Failing to Start Even after Reinstalling on Arch Linux
It's been some months since I've last used PostgreSQL on my Arch Linux desktop, and, apparently, after some updates, something must have broken. If I ask for the service's status, I get (systemctl ...
- 213
