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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
10 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 ...
user avatar
0 votes
0 answers
6 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?
user avatar
  • 113
0 votes
1 answer
18 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 ...
user avatar
  • 111
0 votes
0 answers
48 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 ...
user avatar
  • 101
0 votes
1 answer
36 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 ...
user avatar
  • 1,268
0 votes
0 answers
93 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 ...
user avatar
  • 1,249
1 vote
2 answers
308 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 ...
user avatar
  • 11
0 votes
1 answer
21 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 ...
user avatar
0 votes
0 answers
211 views

Cannot install PostgreSQL 14 because it failed to start database server

I try to install the PostgreSQL 14 in my windows 10 laptop. But it shows the "Problem Running post-install step" when the cluster initialization start. The eror message image What I have ...
user avatar
0 votes
0 answers
35 views

Correct ODBC driver for latest Postgres?

We want to upgrade from 9.4 to the latest PostgreSQL version. The latest PostgreSQL version is 14.1, but the latest ODBC driver is 13.02. Can I safely use 13 with 14? I don't see any deprecated ...
user avatar
  • 101
0 votes
0 answers
63 views

Stop postgresql server windows

I'm a new user of PostgresSQL and don't know how exactly how it works 😅 I would like to stop a psql server on Windows but I haven't found how yet... I tried using (directly in command promt) : pg_ctl ...
user avatar
0 votes
2 answers
323 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 ...
user avatar
  • 107
0 votes
0 answers
109 views

Postgres Database gone after macOS update

I updated to MacOS Monterey and when I started Postgres, it looked like a fresh install. All my databases are gone. I thought maybe I wasn't running brew's version of Postgres but I can't find any ...
user avatar
  • 101
0 votes
1 answer
81 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,...
user avatar
0 votes
1 answer
29 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 ...
user avatar
  • 111
0 votes
0 answers
25 views

Should psql command history work out of the box in Windows?

I would like to use psql command history like any other shell command history, I mean with up arrow get the previously executed command(s). I've googled it, and I got ambiguous result (at least for me)...
user avatar
0 votes
0 answers
158 views

PostgreSQL Point-in-Time Recovery - error at recovery

I have created base backups and continuous Archive Backups of a PostgreSQL 13 database cluster following the official documentaion. (E.g. archive_command = 'test ! -f /continuous_archiving/%f &&...
user avatar
  • 43
0 votes
0 answers
23 views

Regex to remove content not needed from the Rapid 7 database postgresql

I have this below query for Rapid 7 Nexpose SQL database and have been trying to remove unneeded content SELECT dp.policy_id, dp.title as policy_title, dpr.rule_id, dpr.title as policy_rule_title, ...
user avatar
0 votes
0 answers
9 views

How to make PGAdmin4 point to my Postgres server instance

My PgAdmin seems to be connected to a Postgres server instance different from what I get connected when I do psql postgres. I say that because PgAdmin shows only one database "postgres", but ...
user avatar
  • 101
0 votes
0 answers
58 views

High CPU usage of PostgreSQL

I have a PostgreSQL backed complex Ruby on Rails application running on a Ubuntu Virtual Machine. I see that the Postgres processes were having very high CPU usage while running top command. ...
user avatar
0 votes
0 answers
14 views

How to work SQL query rule set from a database table?

I'm running Postgres, and have to deal with some quite long rule sets to do data quality checks. At the moment, these are in my query the usual way like this: case when (var1 = 0) then '1' when (...
user avatar
3 votes
1 answer
529 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 ...
user avatar
0 votes
0 answers
11 views

capture raise info or exception into output log

I am trying to capture the raise info or the exception during during the psql anonymous block. it doesnt capture the output other than DO.. (see below) C:\Users\Arvinds>psql -d postgres -U postgres ...
user avatar
0 votes
0 answers
39 views

WARNING: oldest multixact is far in the past

Is there anyway to simulate the below error WARNING: oldest multixact is far in the past HINT: Close open transactions with multixacts soon to avoid wraparound problems.
user avatar
0 votes
0 answers
778 views

Keepalived scripts not executable?

I am trying to work on automatic failover on postgres with keealived. the problem is that, on both machines (MASTER and BACKUP), when I pass sudo journalctl -u keepalived -f I get this output: ...
user avatar
0 votes
1 answer
71 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 ...
user avatar
0 votes
0 answers
27 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 ...
user avatar
  • 101
0 votes
0 answers
83 views

Recover old PostgreSQL database after reinstalling Windows

My Windows hard drive died and I transferred the secondary hard drive (on which my PostgreSQL 9.4 database was installed) to my new PC. Since all programs needed to be reinstalled, I then downloaded ...
user avatar
  • 527
1 vote
0 answers
171 views

Installing postgres on windows with locale

Disclaimer: as this should be a standard operation, i feel something on my side must have gone terribly wrong. I am trying to use postgresql on windows 71. The installer from edb works fine, apart ...
user avatar
  • 111
0 votes
0 answers
701 views

I can't start PostgreSQL Server 13 from Services.msc

I'm trying to set up a PostgreSQL server on my PC, but I keep getting this error message when I try to start it from services.msc: The postgresql-x64-13 - PostgreSQL Server 13 service on Local ...
user avatar
0 votes
1 answer
624 views

How to install pgBench on Mac Os Big Sur?

How can I install pgBench on mac os Big Sur . I have postgres 12.5 already installed and stack builder does not have the option to install pgbench . And once installed how to connect pgbench to a ...
user avatar
0 votes
1 answer
576 views

How can I connect to PostgreSQL database on a server through an SSH Tunnel using R?

I am trying to connect an RStudio Session to a PostgreSQL database which is on a server (Digital Ocean) through a SSH Tunnel. I am new to the SSH Connections, specially using R. Systems Information: ...
user avatar
0 votes
1 answer
36 views

Can not connect to pgAdmin server in windows 10

Sorry for the same repeated question but pgAdmin failed to connect to the pgAdmin application server. it will save much time from others
user avatar
0 votes
1 answer
341 views

psql command not taking password from .pgpass file

psql -U postgres -h 127.0.0.1 postgres I am using the above command to connect to the postgres running on my system. It asks for password Whereas I have setup .pgpass file in the current directory ...
user avatar
  • 1
1 vote
0 answers
42 views

Bash: read from socket file descriptor returns always the same data instead of blocking

I have a postgres started like this: exec 3< <(su -l postgres -c "/usr/local/pgsql/bin/postmaster -p '$port' -d 3 -D '$backupDir' 2>&1 & echo \$!") This redirects all logs ...
user avatar
  • 243
0 votes
1 answer
2k views

Importing large volume of dummy data into pgAdmin 4 by csv - Failed (exit code:1)

I am trying to upload a large amount of dummy data into my pgadmin tables. I was able to use a csv for the smaller tables however I have a larger spreadsheet of data that includes descriptions (with ...
user avatar
1 vote
3 answers
1k views

cannot start postgres - not able to create lockfile

I have installed postgres from pacman repo on Manjaro but am running into trouble trying to get it to start. I have followed the instructions from the arch wiki and have created my db. initdb -D /var/...
user avatar
  • 113
0 votes
1 answer
1k views

Solve Error without installing PostgreSQL on Mac? dyld: Library not loaded: libpq.5.dylib

I am using a Mac OS X software called TablePlus which throws an error when trying to perform a backup of a PostgreSQL 13 database that is running inside a Docker container. dyld: Library not loaded: ...
user avatar
  • 335
0 votes
1 answer
12 views

How do I tell Postgres to convert existing values to new values?

Problem I have a table that has parent_id and child_id, and they are mutually exclusive, so naturally they should be just one value, not two. I need to replace them with external_id. So any child id's ...
user avatar
1 vote
1 answer
92 views

disable (or trim) logging of bytea requests in postgres

Our application store some big blob (bytea) in a separate database every 30 minutes. It's fine and we want to keep it like, this, but it's causing crazy logging: 2021-01-25 11:11:00 UTC postgres109432 ...
user avatar
1 vote
0 answers
22 views

Issue with Computer Clock (or perhaps LAN)?

I am experiencing a very strange behavior for which I struggle to identify the source, but assume it's the computer clock. Here is the setup and synopsis: I have two computers on my home network ...
user avatar
  • 111
0 votes
1 answer
371 views

Cache configuration for PostgreSQL/TimescaleDB VM on ZFS with proxmox

I have a proxmox cluster of a single node and I want to start a new VM with a PostgreSQL and TimescaleDB and after a lot of reading about how to tune ZFS volumes for this purpose I still have some ...
user avatar
  • 113
0 votes
1 answer
50 views

How to learn what is trying to use my DB?

I'm having a working postgre 11.5 in a docker container, they're just fine! In the the logs I see lots of: FATAL: password authentication failed for user "myuser" DETAIL: Password does not ...
user avatar
  • 111
0 votes
1 answer
903 views

Postgres Column with Multiple Values

I recently took over a database as admin and am unfamiliar with the columns structure in one of the tables. I would really like to know how to select one of the values in the column, as of now I can ...
user avatar
0 votes
1 answer
8k views

pgAdmin not working on mac OS Big Sur

I updated my Mac to macOS Big Sur a few days ago and tried to run pgAdmin to work on some projects of mine. However, it seems there is a problem with pgAdmin 4 and Big Sur. I just cannot run it ...
user avatar
  • 3
-1 votes
1 answer
4k views

100% CPU usage in Linux server and Postgres database

I'm using a Linux server (Ubunto 18.04) that hosts the Postgres database. PostgreSQL makes CPU Usage up-to 100% and sometimes the related web site is down and after server restarting the site turns to ...
user avatar
0 votes
0 answers
154 views

Can't connect to postgres database

Im trying to connect to a DB with Postgres JDBC, both machines are linux the firewall, selinux, iptables are down on both machines I can connect to the DB, (on my personal windows computer) with ...
user avatar
  • 25
1 vote
0 answers
103 views

How can I allow postgresql connections from specific ip address?

I have a postgres database. I would like to allow connections to this database from a specific machine. I have installed postgresql-12 and have started the postgresql service on both machines. I have ...
user avatar
0 votes
1 answer
69 views

R "RPostgrSQL" package fails to install on Centos 8 (as `lib` is unspecified)

I want to install the R package RPostgresql to connect to my PostgreSQL database called "crex" on Centos 8. When I run > install.packages("RPostgreSQL") in the terminal I get ...
user avatar
0 votes
1 answer
43 views

Is it possible to create a single EXE of my system?

I have made an advanced and complex library/framework in PHP. Currently, if I wanted to put this on a new computer, I would have to perform (in broad terms) these manual steps: Install PHP CLI. ...
user avatar

1
2 3 4 5
11