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.
560
questions
0
votes
0
answers
30
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 ...
- 1
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 ...
- 1
0
votes
0
answers
11
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 ...
- 101
-1
votes
1
answer
150
views
Access denied when installing Postgres [closed]
When I try to install Postgres, I am receiving the following error of access denied even with my user being an administrator.
Access Denied
I want just to install postgres, i already installed it a ...
v1tor
0
votes
0
answers
73
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
81
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 ...
- 163
1
vote
1
answer
107
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 ...
- 113
0
votes
0
answers
30
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 ...
- 1
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 ...
- 101
0
votes
0
answers
57
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 ...
- 121
1
vote
1
answer
187
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 ...
- 111
0
votes
0
answers
88
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 ...
- 1
0
votes
0
answers
115
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 ...
- 17
2
votes
1
answer
181
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 ...
- 23