Skip to main content
We’ve updated our Terms of Service. A new AI Addendum clarifies how Stack Overflow utilizes AI interactions.
Unix & Linux

Questions tagged [postgresql]

Ask Question

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
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
1 answer
74 views

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 ...
user1337's user avatar
  • 455
-2 votes
2 answers
69 views

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 ...
Delphi Programming's user avatar
  • 463
-1 votes
1 answer
45 views

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 ...
Manuel Jordan's user avatar
  • 2,196
0 votes
0 answers
48 views

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 ...
CJG's user avatar
  • 1
0 votes
0 answers
128 views

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 ...
Alex's user avatar
  • 3
2 votes
1 answer
132 views

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 ...
Amanadiel's user avatar
  • 123
0 votes
0 answers
64 views

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 ...
Xoteric's user avatar
  • 1
0 votes
1 answer
66 views

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 ...
Ricardo Silva's user avatar
  • 103
1 vote
1 answer
63 views

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 ...
Gromisław Sosenkowski's user avatar
  • 11
0 votes
1 answer
696 views

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 ...
user avatar
0 votes
1 answer
844 views

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, ...
Slen's user avatar
  • 11
1 vote
1 answer
135 views

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 ...
Hari Krishna S's user avatar
  • 13
0 votes
1 answer
498 views

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 ...
ArthurS's user avatar
  • 1
0 votes
1 answer
257 views

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
  • 2,467
-3 votes
1 answer
687 views

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
  • 9
0 votes
1 answer
223 views

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
  • 103
0 votes
0 answers
132 views

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
57 views

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
  • 127
0 votes
2 answers
235 views

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
598 views

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,896
0 votes
1 answer
446 views

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
  • 3
1 vote
0 answers
208 views

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
1 vote
2 answers
1k views

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
  • 243
1 vote
1 answer
2k views

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
1 vote
1 answer
2k views

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
  • 13
0 votes
1 answer
1k views

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
  • 19
-1 votes
2 answers
219 views

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
  • 1
1 vote
1 answer
5k views

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
  • 11
0 votes
0 answers
455 views

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,924
0 votes
3 answers
533 views

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
  • 99
0 votes
0 answers
76 views

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
392 views

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,782
1 vote
1 answer
4k views

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
83 views

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
  • 597
0 votes
0 answers
322 views

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
  • 43
0 votes
1 answer
160 views

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
  • 141
1 vote
1 answer
5k views

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
  • 141
0 votes
1 answer
1k views

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
  • 141
0 votes
0 answers
784 views

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
  • 139
1 vote
1 answer
1k views

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
-1 votes
1 answer
199 views

[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
  • 360
1 vote
1 answer
2k views

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
537 views

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
8 votes
3 answers
15k views

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
  • 30.6k
0 votes
0 answers
256 views

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
  • 1
0 votes
1 answer
312 views

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
135 views

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
1 vote
1 answer
385 views

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,373
0 votes
1 answer
2k views

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
729 views

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

1
2 3 4 5
…
8