Questions tagged [postgresql]
PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.
1,815
questions
0
votes
1answer
8 views
How to connect to PostgreSql database in docker (linux) container from windows desktop via vbscript
I face the following error in trying to connect to PostgreSql database in (linux) docker container from windows desktop via vbscript:
Microsoft OLE DB Provider for ODBC Drivers (30, 11) : FATAL: ...
0
votes
1answer
20 views
Connecting to postgres RDS instance with restricted network access?
I have an RDS instance that is unreachable from the public internet. After performing a restore from a backup through the console, I would like to be able to connect to the database and get a psql ...
0
votes
0answers
7 views
Postgresql 12.2 - Is there automatic way to syncronize a replica (hot-standby) when restoring a master from base backup?
I am testing now a system of two or more postgresql servers, one of them running as a master and the others configured as hot-standby.
OS: debian10 Linux, manually-compiled postgresql server 12.2
The ...
1
vote
1answer
39 views
“timeout expired” when trying to connect to RDS PostgreSQL server with pgAdmin
I am trying to connect to a Postgres RDS instance with pgAdmin, and I get the vague error 'timeout expired' every single time. This situation is especially strange, because my colleagues who are all ...
0
votes
1answer
35 views
Security issue with pg_hba.conf
I have a PHP script on my server that needs access to a database user to work properly . The person who programmed that PHP script has told to add the following to pg_hba.conf :
host all all 127.0.0.1/...
0
votes
0answers
10 views
Postgres backup restoration read-only database
I'm using Barman to manage my postgres database backup.
Now I would like to restore it. But when I restart postgres server after I did the restoration, I'm facing this error:
Add rule to pg_hba: 0.0.0....
0
votes
1answer
40 views
Postgresql update from 9.6 on 11 on debian10
I want to migrate from Potgresql 9.6 to 11 on debian10. But I get this error while wanting to install Postgresql 11:
apt-get install postgresql-11
Reading package lists... Done
Building dependency ...
1
vote
0answers
10 views
Postgres remote connection timeout works on one machine but not on another
im trying to connect remotely to a postgres database, after opening the connection for my public IP address on the server hosting the database, I was able to connect successfully to the database from ...
1
vote
0answers
31 views
What could cause kswapd to reclaim tens of GBs of file cache on a postgres machine?
Usually the size of the file cache on our managed postgres machine running in GCP is between 110GB and 120GB. Sometimes it drops by ~35GB then oscillates by 10GB for an hour or two before slowly ...
0
votes
0answers
25 views
Monitoring Postgresql DB for replication lag
I have 3 secondary DB servers and I am monitoring replication lag using the below command and executing it every 1 min from the master DB node.
ssh $PGHOST1 "sudo -u postgres psql template1 -c '...
0
votes
0answers
9 views
Account locked after postgresql 10.15 Installation in RHEL 7.5
I have installed the postgresql 10.15 in RHEL 7.5 and have also created the account with postgres as user name and password. The installation is completed but I am unable to access the database as the ...
0
votes
0answers
23 views
Equivalent of Firebase with PostGreSQL?
Is there a equivalent/similar product of Google's Firebase but using PostGreSQL instead of no-SQL of Firebase ?
Firebase is a really great product where I don't have to think about :
distributing ...
0
votes
0answers
56 views
High cpu consuming process on postgres in a container
I have a flask app and a PostgreSQL DB in a docker container on my ubuntu server.
I found a high CPU consuming process, which increases CPU usage to 100%!
I tried finding the process origin by ...
0
votes
0answers
27 views
Postgresql version mismatch between pgAdmin and console
I had running PostgreSQL version 10 on IOS and then I installed version 13.1. Now, when I run pgAdmin, I can still see the databases I created for version 10, and pgAdmin reports the server as version ...
0
votes
0answers
56 views
Two postgres servers (different versions) running on same mac, how can I add them both to servers list on pgAdmmin?
I had running postgres version 10 on my Mac and, then, I installed and started version 13. Now I have two versions running in my computer (I suppose, because pgAdmin still shows version 10 server ...
