Questions tagged [postgresql]
PostgreSQL is a community developed, open source, relational database, made available under a BSD-like license. The PostgreSQL documentation is expansive and incredibly useful.
558
questions
0
votes
0
answers
44
views
Kali Linux Postgresql Metasploit DB Fails to Start
I currently have 3 versions of postgres installed, 14, 15, 16. All 3 are actively running and can be accessed from user postgres on ports 5432, 5433, and 5434.
When running sudo msfdb status it ...
0
votes
0
answers
4
views
Connection error whe configuring postgresql_basebackup in nxs-backup
when configuring postgresql_basebackup in nxs-backup I encountered the following:
PSQL connect error: pq: database "repluser" does not exist
Tried to edit pg_hba.conf, but it still doesn't ...
0
votes
0
answers
12
views
kubernetes pod won't start unless I rename the azure disk
I encountered a strange behaviour concerning my Azure kuberentes pod.
This is a postgres db disk.
My pod crashes only if I choose a specific (the original) name for the disk
Using the same snapshot by ...
0
votes
0
answers
87
views
I installed Postgresql. While trying to create user in psql, I messed up the configuration settings. Now, I can't even uninstall or install completely
W: An error occurred during the signature verification. The repository is not updated and the previous index files will be used. GPG error: http://apt.postgresql.org/pub/repos/apt jammy-pgdg InRelease:...
0
votes
0
answers
84
views
An error occurred while reading data from the provider: The remote certificate is not valid according to the validation procedure, PowerBI Postgresql
I wanted to use PowerBI to view and manage things on my Postgresql Database server, but when I select obtain data from another source and select Postgresql DB and enter the credentials (server, DB ...
0
votes
0
answers
15
views
PostgreSQL - Replacing pg_dump -o parameter when migrating to newer PostgreSQL version?
The pg_dump -o parameter was removed in PostgreSQL 12. What should I replace it with when migrating from PostgreSQL 9 to 14?
-o
--oids
Dump object identifiers (OIDs) as part of the data for every ...
1
vote
1
answer
114
views
Issue when creating a new user and group on macOS
I need to create a user and a group called postgres on my mac but I seem to have issues with that. The reason for needing this user is because I've installed postgresql@15 via brew and it created a ...
0
votes
0
answers
31
views
Postgresql on Linux Mint 21.3 can not create server
I downloaded the desktop version of postgresql on my linux mint 21.3 successfully (over Ubuntu Jammy Download-Method) but it still seems to have a problem with the connection.
postgresql connection ...
0
votes
0
answers
30
views
granting privileges to user in postgresql
I'm trying to setup a new project with a Postgresql 15.5 database.
I have a running instance. If I create a new database
psql --command "create database \"tagger-db\""
create a ...
0
votes
0
answers
63
views
Why Postgresql latest stable release is not in Debian stable repository yet?
I can see that today v15 is the stable one version for Postgresql on Debian 12 (here: https://packages.debian.org/bookworm/postgresql).
But v16 is the latest one Postgresql stable released on 2023 ...
1
vote
1
answer
193
views
PostgreSQL traffic analysis - Wireshark - how many bytes in total are being received by the client?
<TL;DR>
How many bytes are being received in total when a SELECT * command is issued for a (small) table?
</TL;DR>
I have a PostgreSQL table - very simple (see fiddle here):
CREATE TABLE ...
0
votes
0
answers
90
views
Data was reset from the postgresql table after deleting the Packages file
I created my project in python using postgresql on windows in a wsl environment. And accidentally deleted the file at the address Appdata/Local/Packages. After that, everything broke down and the ...
0
votes
0
answers
118
views
Pgbouncer: Multiple Instances on same host receiving same TCP connection when using SO_REUSEPORT
I was able to setup two pgbouncer instances for database connection pooling, on a single VM (CentOS 7.0) listening to same port (6432) on two different TCP socket (I believe) using Linux Kernel ...
2
votes
1
answer
182
views
Could interrupting a SQL query that was taking too long lead to a decrease in disk space?
For a personal data analysis project, I was trying to find the most frequent 3 products that were being sold together by doing a self join (twice).
As the query was taking over 15 mins and the laptop ...
1
vote
0
answers
98
views
How do I remove the postgres user
I am on a windows 10 computer, and am looking to clean up my system as I have had this machine for a while, and it has quite a bit of "junk" on it.
I believe part of this is the postgres use ...