Stack Overflow
Stack Overflow

Questions tagged [postgresql.conf]

12 questions
10
votes
3 answers

PostgreSQL 11 configurations doesn't allow pgAdmin4 to connect

I'm pretty new to PostgreSQL so the question may be simple. So. I have installed PostgreSQL 11 and pgAdmin 4 on Fedora 29. I can connect to the database via terminal or AzureDataStudio, but when I try to connect with pgAdmin, I get this…
amiry jd
  • 27,021
  • 30
  • 116
  • 215
5
votes
1 answer

how to resolve ERROR: could not start WAL streaming: ERROR: replication slot "xxx" is active for PID 124563

PROBLEM!! After setting up my Logical Replication and everything is running smoothly, i wanted to just dig into the logs just to confirm there was no error there. But when i tail -f postgresql.log, i found the following error keeps reoccurring…
Walters
  • 61
  • 1
  • 4
4
votes
3 answers

How to change bitnami postgresql helm chart configs? (ph_hba.conf, postgresql.conf)

How do you update postgresql.conf or pg_hba.conf for the main postgresql chart on https://artifacthub.io? (In particular I have been trying to update the wal_level within the postgresql.conf) Related…
John Drinane
  • 1,279
  • 2
  • 14
  • 25
1
vote
1 answer

Postgres Upgrade from 9.5 to 12 cannot execute UPDATE in a read-only transaction

Since moving from 9.5 to 12 we are seeing alot of errors in the database log. The query that is being run is a basic update statement which changes the date of when a user is logged in. 2021-03-03 09:23:43.235 CET [18820] ERROR: cannot execute…
rdbmsNoob
  • 121
  • 1
  • 12
1
vote
0 answers

Can't edit postgresql.conf file to change settings

After editing postgresql.conf file and restarting a server it seems that all changes do not apply. I was following this…
Addas
  • 11
  • 3
0
votes
0 answers

Can not connect Postgres after sometimes

Its been a week that I can not connect to Postgres 13 server after some period of idle time (I do not connect to database for about 1 - 2 hours), although it's status is Active. I am the only one accessing this database right now using…
padjee
  • 125
  • 2
  • 12
0
votes
0 answers

Dbeaver : connection is closed by foreign host

im working on vmware on ubuntu i want connect util in postgres... enter image description here im also change pg_hba.conf and postgres.conf im changed listen addresses ='*' and host all all 0.0.0.0/0 …
js s
  • 1
0
votes
0 answers

Postgresql Replication EFM how to reject inserts when Standby nodes are not sync?

I have a 3 nodes cluster for PostgreSQL 14 made by EDB Failover Manager. When I turn off the two standby nodes, the Primary node takes forever to do the insert commands. I don't want it to do insert commands, I want it to act like a read-only node…
Mohammed Alali
  • 7
  • 2
0
votes
1 answer

Postgres on Ubuntu, controlling the postgresql.conf location

I created a cluster as follows: pg_createcluster -d /some_dir/pg_data/ -p 5432 \ --environment=/some_dir/pg_env.prod.conf \ --createclusterconf=/some_dir/pg.prod.conf \ 13 apif However, when the cluster is stood-up, it has effectively…
Alexi Theodore
  • 1,177
  • 10
  • 16
0
votes
1 answer

postgresql.conf setting is ignored because it is defunct

I'm trying to add 2 settings to my postgresql.conf file (on a CentOS Greenplum Postgres 9.4 instance) and I'm getting this message back: log_destination"": setting is ignored because it is defunct log_line_prefix"": setting is ignored because it is…
Matias
  • 539
  • 5
  • 28
0
votes
1 answer

PostgreSQL (pg_hba.conf / postgresql.conf) The connection to the server was lost. Attempting reset: Failed

I have a problem with Postgres that others seem to have found but the solutions that are given somehow do not work for me. I explain: WHAT I USE MacOS 10.15.6 Installed through Homebrew PostgreSQL 12.2 on x86_64-apple-darwin, compiled by Apple LLVM…
JourneyDS
  • 113
  • 14
0
votes
1 answer

Is it safe to change Postgresql settings in production?

I started a project that is already in production and we have a few clients already registered and paid for the service (SaaS business). We use an Ubuntu VPS with Postgresql with default postgresql.conf settings. Based on PGtune, to optimize the…
Chris
  • 33
  • 1
  • 3