Skip to main content

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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
9 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 ...
Marc Le Bihan's user avatar
-3 votes
1 answer
44 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 ...
Daniel NanaYaw Gyamfi's user avatar
0 votes
1 answer
33 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 ...
spartanhooah's user avatar
0 votes
0 answers
29 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 ...
Hitriy's user avatar
  • 1
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 ...
palmasd1's user avatar
  • 125
0 votes
2 answers
83 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 ...
herrdeh's user avatar
  • 11
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 ...
mYnDstrEAm's user avatar
  • 4,388
0 votes
1 answer
53 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/...
bazizi khaled's user avatar
0 votes
0 answers
18 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-...
codesss143's user avatar
1 vote
0 answers
101 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 ...
Saurabh's user avatar
  • 111
0 votes
2 answers
153 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 ...
psygo's user avatar
  • 201
1 vote
1 answer
308 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 ...
kaddy's user avatar
  • 13
0 votes
1 answer
339 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 ...
mig50's user avatar
  • 3
0 votes
0 answers
29 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 ...
TheChubbyPanda's user avatar
0 votes
1 answer
474 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 ...
heyula's user avatar
  • 21
-1 votes
2 answers
121 views

410 Gone [IP: 2606:4700:20::681a:d05 443] when trying to run sudo apt update

I have been trying to fix an error when running docker and as a result want to update my kali version, however i receive this when running sudo apt update E: Failed to fetch https://mirror.mwt.me/...
dhud130's user avatar
0 votes
0 answers
122 views

gvmd update error: PostgreSQL connection termination on Debian 12, PPC64

System is Debian 12 port for ppc64 (sid). I have installed and configured gvmd, the problem is: is impossible to update the SCAP database cause of this error. All seems ok.· tail -15 /var/log/gvm/gvmd....
elbarna's user avatar
  • 12.8k
0 votes
0 answers
49 views

Error PostgreSQL CENTOS restart server, Failed to start PostgreSQL 9.6 database server

Failed to start PostgreSQL 9.6 database server. I restarted my database server on CENTOS and now PostgreSQL doesn't wake up the service, journalctl -xe says: -- The result is failed. Nov 06 10:17:21 ...
userhelp777's user avatar
0 votes
0 answers
16 views

postgres/nextcloud keeps drives active

I run a small home server with Debian including a autoshutdown script if the system is idle. Since a few days my drives are not staying in standby and with this the server is always running. I ...
MelBourbon's user avatar
0 votes
1 answer
3k views

Obsolate postgresql version 15 on Kali

I'm begginer who tries to start working with Kali Linux so I downloaded virtual box, then kali, but after command 'sudo apt upgrade -y && sudo apt update' I got message that postgresql 15 is ...
Michał Tlałka's user avatar
0 votes
0 answers
252 views

How was my postgres docker container hacked / infected

My VPS have been infected by the kdevtmpfsi malware, twice. That's the problem, because I've taken every possible precaution after being infected for the first time, and I have no idea how I'm being ...
xpt's user avatar
  • 1,644
0 votes
3 answers
134 views

Tracking the source of PostgreSQL authentication failures in Linux Localhost

I have these logs in my PostgreSQL database log file that appeared after I changed the database password. 2023-09-14 11:57:15.937 UTC [3401773] username@db-name FATAL: password authentication failed ...
Amir Sabeghi's user avatar
0 votes
0 answers
30 views

Ubuntu - PostegreSQL displays errors in foreign language even after changing all locales to en_US and reinstalling it

I inherited a Ubuntu desktop from another employee and installed PostgreSQL with the help of the official guide. abc@lenovo:~$ sudo apt install postgresql-15 I had not known that I had to setup an ...
qc033's user avatar
  • 1
2 votes
1 answer
242 views

How to tell rsyslog to use Unix domain sockets to write syslog messages to a Postgresql database?

I created a database as explained here: https://github.com/rsyslog/rsyslog/blob/master/plugins/ompgsql/createDB.sql I created a "root" user in the database and granted insert permissions: ...
ceving's user avatar
  • 3,619
1 vote
1 answer
2k views

Debian Bullseye install error for postgresql-client-15 (Depends: libreadline7 (>= 6.0) but it is not installable)

I'm inside a docker container that uses the Ruby 3.2.2 Debian 11 bullseye image as a base image (see https://github.com/docker-library/ruby/blob/ed1be47a38a7a24a0aa03c450549afcb592f02a8/3.2/bullseye/...
23tux's user avatar
  • 175
0 votes
3 answers
61 views

comment out line between in a file based on pattern

File: /home/jian/Desktop/pg_sources/main/postgres/src/test/regress/sql/test_setup.sql 246: -- 247: -- Create some C functions that will be used by various tests. 248: -- 249: 250: CREATE FUNCTION ...
jian's user avatar
  • 577
0 votes
0 answers
215 views

I cannot add users or otherwise control PostgreSQL 15 using openSUSE Tubleweed (updated recently)

I just switched workstations and installed openSUSE Tumbleweed and PostgreSQL 15 using the postgresql database repo. Details: Kernel: 6.3.4-1-default arch: x86_64 bits: 64 Desktop: LXQt v: 1.3.0 ...
DrKC's user avatar
  • 23
0 votes
1 answer
103 views

Cannot start postgres service because expected file is not in run directory

I recently tried to install postgres on my arch machine. I was able to run the initdb command as the postgres user, but I cannot actually run the service. This is what I see in my terminal when I try ...
Anthony Bias's user avatar
1 vote
1 answer
3k views

Permission denied when starting PostgreSQL service using systemctl but works with postmaster

I previously installed PostgreSQL by following this documentation then I uninstalled it using the following commands (I'm on Fedora) sudo rm -rf /var/lib/pgsql/ sudo dnf remove postgresql postgresql-...
Jérôme MEVEL's user avatar
0 votes
1 answer
712 views

PostgreSQL not working after creating a symbolic link on the pg_hba.conf file

I'm trying to create a symbolic link on /var/lib/pgsql/data/pg_hba.conf (default path on Fedora) pointing to the real file located somewhere else, for example /var/lib/pgsql/data/pg_hba.conf -> /...
Jérôme MEVEL's user avatar
0 votes
0 answers
625 views

AlmaLinux Postgersql installation error

I've followed the instruction at here to install Postgresql at AlmaLinux. But the error persists. $ sudo yum install -y postgresql15-server The error: PostgreSQL 9.6 for RHEL/CentOS 8 - x86_64 ...
Igor Savinkin's user avatar
1 vote
1 answer
898 views

how to download postgres data in csv format through bash script?

I am able to connect to db also getting output but it's not coming in proper format. So how to get the output in csv like format and also want to save that in csv format. psql -d <db> -U <...
zircon's user avatar
  • 113
0 votes
1 answer
129 views

[email protected] fails to load but not [email protected] - are both needed in linux boot?

[email protected] fails to load but not [email protected] - are both needed in linux boot? linux - bookworm sid. So [email protected] is needed ?
Estatistics's user avatar
1 vote
1 answer
652 views

Unable to change Postgresql data directory with systemd service overrides on Ubuntu 22

I am trying to change the data directory that Postgres uses to look for its configuration files. I have a fresh update of Ubuntu 22 and newly installed Postgresql@15. In order to maintain version ...
Geuis's user avatar
  • 121
0 votes
0 answers
361 views

Fedora: Error when install Postgres SQL: nothing provides libicui18n.so.69()

I had installed the Postgresql database on my Fedora system, which worked without problems. After some time I had uninstalled Postgres and wanted to reinstall it. When reinstalling with the following ...
TobKel's user avatar
  • 143
3 votes
2 answers
9k views

Upgrade your postgreSQL Database from 14 to 15 on Debian

I wonder how I can upgrade the data from an existing PostgreSQL 14 installation to 15. I automatically got PG 15 installed via apt, so I see # dpkg -l | grep ii | cut -d" " -f3 | grep ...
rubo77's user avatar
  • 29.4k
0 votes
0 answers
101 views

PostgreSQL: indexes and partitions

I have a PostgreSQL database and I noticed a weird behaviour while working with indexes and partitions. The engine version is 10.21. Now, I have a table with this structure: guid varchar(50) PK guid_a ...
Federico Loro's user avatar
0 votes
1 answer
195 views

Bash: psql command not found when called inside a function

I have a bash script, where the psql connect string is stored in a variable. After this I have defined three functions. ————————— export PC="usr/bin/psql --host=abx --port=1234 --dbname=A --...
Bash3d's user avatar
  • 1
2 votes
0 answers
52 views

Is there a single command to remove a package source and its signing key?

I added the postgresql package source to my Linux Mint system. I'm new to apt and was wondering if, instead of deleting the package source from /etc/apt/sources.list.d and the signing key from /etc/...
Bunny's user avatar
  • 141
0 votes
1 answer
185 views

Running psql with a role

When using psql I always have to issue set role ... first. Could this be executed automatically before accepting interactive commands? E.g.: psql -h HOST -U USER -c "set role 'ROLE';" -f - ...
laktak's user avatar
  • 6,054
0 votes
1 answer
1k views

-bash: psql: command not found after manual installation of PostgreSQL

I installed the PostgreSQL database via source code, and I successfully up it and installed the pg admin also. I am able to execute SQL functions via it. But when I type psql in the server I am having ...
Zero5's user avatar
  • 11
1 vote
0 answers
598 views

psql: error while loading shared libraries: libssl.so.3

after incorrectly reinstalling postgresql on Linux, an error appears: libssl.so.3: cannot open shared object file: No such file or directory I decided to remove postgress and looked at the commands ...
mArSeN's user avatar
  • 11
0 votes
0 answers
643 views

Debian stretch, executor failed running and some packages can not be authenticated

I have an error when I am building my Docker containers. It seems that there are problems with Postgres Stretch for Debian. I saw that Debian strech was removed and no longer supported. W: The ...
bubamara's user avatar
1 vote
0 answers
793 views

Unable to start PostgreSQL, error looks like its pointing to DB user not found

Asking for some assistance with trying to start postgresql-9.6.2 service using systemctl (systemd). I'm installing a monitoring tool that installs an instance of PostgreSQL to support the tool. It ...
A.brashear's user avatar
0 votes
1 answer
155 views

How to upgrade Postgresql 11.2 to 11.17 on Ubunutu 14.04

We have a Ubuntu 14.04 server with Postgresql 11.2 installed. We need to upgrade it to 11.17. I have read old versions of Postgresql will move to https://apt-archive.postgresql.org/. So I have updated ...
Chinna2022's user avatar
2 votes
1 answer
10k views

How can I upgrade the postgreSQL from 14 to 15 in kali linux VM?

I am setting up my first VM with debian (x64) and kali linux... I am a windows user but want to learn linux. while upgrading linux using sudo apt upgrade I got a message like this. But I do not ...
paxanoA1607's user avatar
0 votes
1 answer
106 views

Why isn't password based auth working in postgresql until I disable ident auth?

I just installed postgresql and pgadmin from the repos on Fedora 36. I set up the initial postgres role and database, and logged in with the postgres user sudo su - postgres psql From there, I set up ...
John's user avatar
  • 477
0 votes
1 answer
1k views

Unzip compressed dump and import via psql

I'm trying to dump a huge database and compress the dump in order to not have to wait hours till it's done. I dump the database the following way: pg_dump -Fc -U -v | gzip > db$(date +%d-%m-%y_%H-%...
Djabone's user avatar
  • 113
1 vote
2 answers
2k views

"CREATE EXTENSION postgis" fails with 'could not access file "$libdir/postgis-3"'

# dnf list installed | grep postgresql VRTSnbpostgresqlagent.x86_64 9.1.0.0-1620848511 @System postgresql.x86_64 ...
raphael's user avatar
  • 195
3 votes
1 answer
7k views

E: Unable to locate package postgresql-12

I'm using Linux Mint and I'm trying to upgrade PostgreSQL 10 to version 12 through sudo apt-get install postgresql-12, but I see this frequent error: E: Unable to locate package postgresql-12 So what'...
ezzeddin's user avatar
  • 135

1
2 3 4 5
8