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
0
votes
1
answer
16
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 ...
-3
votes
1
answer
54
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 ...
0
votes
1
answer
36
views
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 ...
0
votes
0
answers
32
views
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 ...
0
votes
1
answer
24
views
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 ...
0
votes
2
answers
87
views
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 ...
0
votes
1
answer
64
views
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 ...
0
votes
1
answer
58
views
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/...
0
votes
0
answers
20
views
How to upgrade Hapi Fhir server on docker?
I have a very old hapi fhir server and I want to upgrade it from 5.1.0 to 6.10.1-tomcat. I can't find the upgrade method on the internet. How can I upgrade hapi fhir?
I'm using hapi-fhir-cli migrate-...
1
vote
0
answers
105
views
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 ...
0
votes
2
answers
167
views
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 ...
1
vote
1
answer
326
views
Running sudo apt-gt update gives E: The repository 'https://apt.postgresql.org/pub/repos/apt virginia-pgdg Release' does not have a Release file
I am using Linux Mint Cinnamon 21.3 Virginia.
I installed PostgreSQL recently and the installation proceeded successfully. However, there seems to be some issue with the package manager now.
On ...
0
votes
1
answer
368
views
Trying to install postgresql16-client on an Alpine Docker Container
I'm trying to create a Docker container with postgresql16-client but i'm getting an error saying that the package does not exist.
I'm going to also install dotnet 8 on this container in order to run ...
0
votes
0
answers
31
views
NixOS Postgresql authentication not being updated
I have the following snippet in my configuration.nix:
services.postgresql = {
enable = true;
authentication = lib.mkForce ''
# GENERATED
host all all 0.0.0.0/0 md5
host all ...
0
votes
1
answer
495
views
How to connect postgresql database without using sudo
I need to create a postgres database on a linux server. However, I don't have admin privileges and cannot use sudo. How to install postgres and create a database without using sudo. I looked at ...