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
1
answer
3k
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 ...
1
vote
3
answers
5k
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/...
3
votes
1
answer
8k
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: ...
0
votes
1
answer
18
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 ...
1
vote
1
answer
221
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 ...
1
vote
0
answers
42
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 ...
0
votes
1
answer
815
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 ...
0
votes
1
answer
73
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 ...
1
vote
1
answer
3k
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 ...
0
votes
1
answer
10k
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 ...
-1
votes
1
answer
7k
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 ...
0
votes
0
answers
410
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
...
1
vote
0
answers
2k
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 ...
0
votes
1
answer
160
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 ...
-1
votes
1
answer
55
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.
...