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.
541
questions
0
votes
0
answers
48
views
How do I install pgaudit on PostgreSQL 11.5 in Red Hat Linux environment?
PostgreSQL 11.5 was installed with Control-M in a Red Hat Linux environment. Unfortunately, there are only 2 extensions (dblink, plpgsql) that were a part of that installation.
I am new to PostgreSQL. ...
2
votes
1
answer
476
views
Postgres docker error "data directory "/var/lib/postgresql/data" has wrong ownership"
I am trying to start a postgres container using docker
I have tried using multiple versions of postgres docker images
I have tried using volumes as mentioned here
tried setting POSTGRES_USER ...
- 58
0
votes
1
answer
26
views
Accidentally installed postgres10 and postgres12 on Ubuntu
Ubuntu 20.04 came preinstalled with postgres10. Roughly 2 years ago I did a sudo apt-get install postgresql which must have installed postgres12. I never noticed that when I sudo -u postgres psql (...
- 101
0
votes
0
answers
30
views
PostgreSQL ODBC Driver for IBM i Compile Error
I am attempting to compile the PostgreSQL ODBC driver on our IBM i system, and I'm getting a strange error. The version I'm trying to compile is 12.02, since that's the version of PostgreSQL we have ...
- 113
0
votes
0
answers
44
views
Updating to bookworm sid fails - plasmashell(kde), libgiognutls.so
I updated bullseye 11 to bookworm sid 12 (yeah, I know testing phase). I learnt that many people successfully installed that. But I had some problems:
My problems
plasmashell (kde) starts to blank ...
- 207
0
votes
0
answers
36
views
Postgresql Connection Timedout
i have postgresql 12.14 installed (on an azure VM) and trying to connect to it remotely but connection timesout with below error
i have allowed incoming connections in both /etc/postgresql/12/main/...
Faheem Sultan
1
vote
0
answers
92
views
Is there any way to pg_upgrade PostgreSQL 12 to 15 over network?
My situation is a little bit complicated.
I have an older version of PostgreSQL 12.9 installed on an older Centos Stream 8 machine. There are about five custom databases created under the roof, say ...
- 149
1
vote
0
answers
59
views
Postgres' pg_total_relation_size returning unexpected table size for a zfs-based tablespace
I have Postgres 15.1 running on Ubuntu 20.04. Basic FS is ext4, but I have mounted zfs onto a sparse file like this (for compression testing purposes):
truncate -s 100G zfspart.dat
zpool create -o ...
- 111
2
votes
0
answers
147
views
Vagrant - Ansible - Install PostgreSQL and Postgis
I'm trying to install PostgreSQL and Postgis with Ansible on a Vagrant VM.
The VM is only use locally for local development, so that's why I grant access to databases.
But I'm reaching some issues to ...
- 21
0
votes
0
answers
50
views
How to create backup in directory format
Creating backup in directory format using
pg_dump -f "sba" -Fdirectory --jobs=32 --verbose sba
throws error
pg_dump: error: could not stat file "sba/282168.data.gz": value too ...
- 149
1
vote
1
answer
289
views
PyQt6 QPSQL Driver not loaded
I'm trying to use the SQLTableModel from PyQt6 (installed with pip) in Python 3.11. For this I need to connect to my Postgresql 13 database (hosted on AWS) using the QPSQL driver from PyQt6.
The ...
- 11
0
votes
0
answers
14
views
psql linux run sql file for windows
Hello guys I use linux to restore postgresql database from sql file but this file was dump from windows
then the inserts look like \N and tabs separators
How can I import this windows born file, from ...
1
vote
0
answers
24
views
How would I keep a live database directory atomically synchronized with other local disks on Windows 10?
I run PostgreSQL 14.1 on Windows 10 (Pro). The computer has multiple internal storage disks. The PostgreSQL "data directory" is set to C:\whatever\PGDB.
I do make full backups daily, but ...
- 11
0
votes
2
answers
76
views
Postgresql :: operation select sysdate didn`t work
I recently installed postgres v15 in windows 10 machine and below paths set to system variables >> Path
C:\Program Files\PostgreSQL\15\lib
C:\Program Files\PostgreSQL\15\bin
When I run SELECT ...
- 1
3
votes
1
answer
231
views
PostgreSQL cluster won't start, no log of the issue, message on WAL redo
I'm having trouble with a system that I didn't set up or configure myself, but pieces of the system seem to generally be in more or less default places. My current theory is that the PostgreSQL ...
- 131
0
votes
0
answers
47
views
How does Debian/Postgres determine which version of Postgres to run?
This is from a Debian 11 server:
psql select version();
version
-----------------------------------------...
- 153
0
votes
1
answer
124
views
How to recover Postgresql databases from an older version
I was running for many years Davical on a Debian server (Debian version 11.6 at the moment) to have access to my calendar from many different devices. That application uses PostgreSQL to store its ...
- 111
1
vote
1
answer
319
views
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
How to test in VSCode a postgreSQL SQL expression in Python's interactive notebook (= Jupyter Notebook, iPython) in a venv with package manager conda?
- 1,715
0
votes
0
answers
175
views
Azure database for postgresql: change the owner of a table without using the super user
I'm working on a PostgreSQL v10 Database created in Azure. This database has several users including:
myuser: user used by a web application. Has limited powers;
myadmin: admin user created by azure ...
- 345
0
votes
2
answers
1k
views
running into permission issues when using the COPY command with postgresql 14.6-1 on linux 6.0.12-arch1-1
Hello everyone :) noob here,
trying to learn sql with postgresql 14.6-1 on arch linux kernel: 6.0.12-arch1-1 ,
the current topic of the book i'm reading, has me doing this command
COPY char_data_types ...
1
vote
0
answers
120
views
PostgreSQL sum function resurns different result when run multiple of times with psql
I have this query :
SELECT SUM(median) FROM my_table WHERE id = 100
-- median is of type float4
When I run from psql, it returns slightly different result for multiple of runs (For example 1000.08, ...
- 125
0
votes
0
answers
18
views
PostgreSQL - privileges for all tables in database
I have such problem in PostgreSQL 12.
There is a database testdb with many tables in several schemas.
There are four users user1, user2, user3, user4.
I have to grant only SELECT and INSERT privileges ...
0
votes
0
answers
106
views
Does it make sense to use the local entries (Unix domain socket) of pg_hba.conf in Windows?
I have a rather simple question.
As stated in the pg_hba.conf file in the postgres data directory:
# DO NOT DISABLE!
# If you change this first entry you will need to make sure that the
# database ...
- 141
1
vote
1
answer
70
views
Persisting data for amazon ec2 instance running postgres
I am provisioning a cheap postgres instance for myself by installing directly on amazon ec2.
Everything will be deployed using terraform.
I would like the database data to persist between restarts / ...
- 111
0
votes
1
answer
137
views
Terraform setup of postgres conf files (pg_hba_conf + postgresql.conf) via User Data on AWS ec2 instance
I am setting up a cheap postgres server on amazon ec2, using Terraform.
I know I can add a User Data file when setting up a ec2 instance.
I know that with terraform, I can provide that User Data ...
- 111
1
vote
1
answer
529
views
Connecting to a Postgres database, hosted within a Windows Subsystem for Linux, from a separate device
I have two devices:
HOST: a Windows device, on which I have installed a Windows Subsystem for Linux.
CLIENT: a Linux device.
I have then taken the following steps.
I have installed Postgres within ...
- 111
0
votes
1
answer
178
views
Importing a large .dump file into Postgres Database (Win 10)
I'm running into a problem where I want to import a really, really large .dump file (530gb) into a postgres database inside a docker.
This is the commmand I'm running inside Powershell:
cat .\dbexport....
- 125
0
votes
1
answer
26
views
Cannot view postgres database on one system in another
I am trying to view a database created on a different system in my current installation of postgres.
I downloaded the same version of postgres (9.6) and replaced the data folder with the data folder ...
0
votes
1
answer
2k
views
E: Unable to correct problems, you have held broken packages
Linux Mint 21
I try to install postgresql 9.6 like this:
sudo apt-get install postgresql-9.6
But get error:
Reading package lists... Done
Building dependency tree... Done
Reading state information... ...
- 343
0
votes
0
answers
61
views
phppgadmin wont let me change the user used to access a database
I accidentally logged in to a database with the wrong account and now cant reset it to ask for a different user name to access that specific database. [Note: I know the proper login for logging in ...
- 601
0
votes
1
answer
34
views
Parallel processing implementation
I received an very old program in my company that need to be refactored. The code is a bunch of SQL instructions that are orchestred by a program written as shell commands with the objective of doing ...
0
votes
1
answer
63
views
Windows chkdsk claims my disks are fine, application errors suggest otherwise
I'm running a postgres 14 database on a windows 11 machine.
Postgres has started generating some errors including the following...
ERROR: XX002: index "tableA_i1" contains corrupted page at ...
- 205
0
votes
0
answers
16
views
Recover postgresQL from base files
Here's the thing:
I had a super important PostgreSQL database in my Windows 10 external disk (D:/) and forgot to dump it before installing Ubuntu 22 over my Windows.
I just realized that I still have ...
0
votes
0
answers
46
views
How do I configure an additional Postgresql instance on RHEL9 using postgresql@.service?
RHEL9 ships with Postgresql 13.7, and provides two systemd startup scripts:
/usr/lib/systemd/system/postgresql.service
/usr/lib/systemd/system/postgresql@.service
The first systemd service file is ...
- 572
0
votes
0
answers
25
views
PostgreSQL doesn't run on MacOS after OS upgrade
I had a postgreSQL v10 installed and running locally, now after I upgraded my macOS from Big Sur to Monterey now it seems the service is not running and I can't get it running. Brew doesn't recognize ...
- 101
0
votes
1
answer
39
views
Rebuild PostgreSQL from backup after data corruption
My PostgreSQL database seems to have suffered corruption after an unclean shutdown, and now I cannot figure out how to get it out of recovery mode. Since the database does not get very frequent ...
- 980
0
votes
0
answers
99
views
How to uninstall PostgreSql user on Mac Monterey
I already deleted pgadmin 4 and the PostgreSQL apps and I don't know why the PostgreSQL user profile is listed on my task bar. I checked the official "System Preferences", and I don't see ...
0
votes
0
answers
12
views
Is it possible to edit and execute plv8 scripts (store procedure) direct from IntelIJ IDEA?
IntelliJ IDEA 2022.1.3 (Community Edition)
In my java project I use plv8 scripts (store procedures).
The question is: Is it possible to edit and execute store procedures direct from IDEA?
- 343
0
votes
1
answer
114
views
Cannot launch Postgresql's pgadmin4 on Fedora36
I have just installed pgadmin4-desktop on Fedora36 and after initially working it has suddenly stopped. The steps I followed are documented here: https://www.pgadmin.org/download/pgadmin-4-rpm/
Now I ...
- 111
1
vote
0
answers
583
views
Postgres: Failed system call was shmget(key=3879116, size=56, 03600)
I recently upgraded from a 2013 Macbook Pro to an M1 iMac 2021. This was done using the data stored in Time Machine by my old Macbook. The old Macbook had no problems, ever, running Postgres. But then ...
- 121
1
vote
1
answer
448
views
PostgreSQL Client on SUSE Linux
On an SUSE Linux server I need the tools psql, pg_dump and pg_restore, without the whole database server installation. Other distributions provide an postgresql-client package (Ubuntu) but I am unable ...
- 1,308
2
votes
0
answers
748
views
How create new server connection in pgAdmin 4 by pasting PostgreSQL connection string (URI)
See https://stackoverflow.com/a/20722229/470749
It's very common for server connections to be specified in just one URI, which is more convenient than needing to type out a bunch of values into ...
- 1,626
2
votes
2
answers
3k
views
Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?
I have PostgreSQL running on my Linux server.
PostgreSQL is enabled and is active after reboot.
In the config file from PostgreSQL I enabled remote access. But every time after I reboot my device, the ...
- 31
0
votes
1
answer
91
views
Is postgresql installed by default on MacOS?
The Uninstall app isn't working and it's been so long that I don't remember if MacOS had Postgres installed for anything before I started. If I delete /Library/PostgreSQL will it brick my system?
I ...
- 168
0
votes
2
answers
2k
views
Postgresql unix domain socket with password authentication
It looks like postgresql supports either of the below
Use tcp (i.e. localhost:5432) with password authentication
Use Unix domain scoket (i.e /var/run/postgresql/.s.PGSQL.5432 ) with peer/trust ...
- 107
0
votes
2
answers
816
views
/usr/local/opt/postgresql/*.plist no match
i'm trying to install postgres on my macOS (Monterey 12.0.1).
i've ran brew install postgres and the next step is to run ln -sfv /usr/local/opt/postgresql/*.plist ~/Library/LaunchAgents, but when i do,...
0
votes
1
answer
45
views
Cannot disinstall PostgreSql by Script Bash - Linux - Must not open dialog confirmation
My goal is to uninstall PostgreSql (installed on a Linux host- Ubuntu 18.04 LTS) using a bash script file.
I use the following command:
apt remove --purge -y postgresql-12 && apt autoremove -y
...
- 111
4
votes
1
answer
4k
views
Changing default user for PostgreSQL on Windows 10?
I just installed PostgreSQL 13 on Windows 10. In the command prompt I did:
C:\Users\Max>cd ../postgres
I then tried to do the createdb command and got this error message:
createdb: error: could ...
- 81
0
votes
1
answer
164
views
nslookup on azure postgres server - output explanation
I created a new postgres database in azure. Lets assume, this database has the server name URL mytestdatabase.postgres.database.azure.com
While doing a nslookup on this URL, i'll get the following ...
0
votes
0
answers
56
views
Port on remote server appears open from one server but no the other
So this one has been a bit odd. I have a server within my work VPN that has postgres setup on it. I can access the server in question from my local WSL instance (when connected to the vpn obv) and ...
- 101