Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system.
687 questions
2
votes
1
answer
258
views
Why my sudoers file doesn't let me access?
I made this file:
/etc/sudoers.d/myfile
myuser ALL=(postgres) ALL
I rebooted the system and then I tried:
su - postgres
I entered MY password but it failed with su: Authentication failure, am I ...
- 207
0
votes
1
answer
46
views
Cannot access Postgresql through pgAdmin via SSH
Trying to configure pgAdmin 4 (9.9) on my client (Windows 11), so that I can access Postgresql 16 on Ubuntu 24.04 server.
This works:
SSH to server works via Powershell (serveruser)
database user (...
0
votes
1
answer
92
views
Problems in connecting postgresql with ssl
on my ubuntu-server PostgreSQL (16) is running succesfully (so far without ssl). I try now to get a ssl-conncetion and have no success.
For the server I have bought ssl-certificates from "Sectigo&...
- 1
-3
votes
1
answer
168
views
What to do when an app doesn't support arm64 architecture
When I try to install Postgres shell tools on Noble with sudo apt install pgadmin4-desktop, I get:
Skipping acquisition of configured file 'main/binary-arm64/Packages', as repository 'https://ftp....
- 1,089
0
votes
1
answer
194
views
Downloading postgresql, I found a problem that makes me unable to install it. How can I fix it?
I'm using Ubuntu 24.04.2 and the error message is:
E:The repository 'https://apt.postgresql.org/pub/repos/apt -pgdg Release' does not having a Release file.
N:Updating from such a repository can't be ...
0
votes
0
answers
41
views
How to use Gramps with SharedPostgres db in passwordless mode?
I have Ubuntu Mate desktop "Ubuntu 22.04.5 LTS". To manage my genealogy, I've installed Gramps v. 5.2.2-1.
As I have Postgres server v14 running for other purposes, I want to use it also for ...
- 33
0
votes
1
answer
79
views
Remove Zitadel from Ubuntu
How does one uninstall Zitadel, the self-hosted authentication management software, from a Ubuntu server? There only seems to be installation documentation on their website.
I installed it on an ...
- 640
1
vote
2
answers
377
views
i want to do release upgrade but keep the current version of postgres
I want to upgrade my server OS from ubuntu 20.04.5 to ubuntu 24.04.2. Currently, i have pgsql version 12.22 installed on it and i do not want to upgrade the version during this upgrade. Is there a way ...
0
votes
1
answer
311
views
No permission to run postgresql after installation
I installed postgresql version 17.4 (Ubuntu 24.04). After attempt running sudo psql I receive an error
psql: error: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed: ...
0
votes
1
answer
467
views
postgresql configuration failed: /etc/postgresql folder is empty
Followed instructions in: postgresql install which ends with the statement:
The database service is automatically configured with viable defaults, but can be customised based on your specific needs.
...
- 111
0
votes
1
answer
450
views
What is the difference between PostgreSQL client version to PostgreSQL server version?
I'm trying to understand the difference between PostgreSQL client and server versions.
I came across 2 different ways of checking the version and this got me curious whether there are different ...
- 1
0
votes
0
answers
78
views
How to host Core WCF host on Ubuntu to access a database running in Ubuntu
I have an Ubuntu server hosted in the cloud, and it has a postgres database hosted in a Docker container. I now have a Windows application needing access to the database. I want to have a service ...
1
vote
1
answer
85
views
Python and Postgresql Broke My Terminal and APT?
I have Ubuntu 24.04 on a VirtualBox VM.
I installed python3, pip and postgresql with seemingly no errors. Then I closed my terminal to restart it and then I could not open it back up.
This is the ...
- 11
0
votes
1
answer
87
views
Postgres 9.5 with Postgis 2.2
I'm in need to install a brand new Postgres installation using older versions. I'm in need since i want to upgrade to the latest version, and for compatibility issue i'm working on a dump of my main ...
- 111
1
vote
0
answers
59
views
PostgreSQL Permission Denied After Docker Migration Between VPS Using rclone
[Help] PostgreSQL Permission Denied After Docker Migration Between VPS Using rclone
Problem
I'm getting permission denied errors while trying to set modification times on PostgreSQL files after ...
