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.

Filter by
Sorted by
Tagged with
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 ...

15 30 50 per page
1
2 3 4 5
121