PostgreSQL

19 Dec 2024 12:14

How to automate basebackup ij both primary and replica

PostgreSQL

19 Dec 2024 09:29

But everytime closing and opening of the tool will not cause this issue

PostgreSQL

19 Dec 2024 09:27

Hmmm. I *wonder* what could cancel your ETL job then 😏

PostgreSQL

19 Dec 2024 09:14

computer also depends on quantum physics
brain is a piece of hardware
fake.

PostgreSQL

18 Dec 2024 15:06

Stops in the sense tool itself closes within 5-10 days where in job is kept in running state

PostgreSQL

18 Dec 2024 15:03

Hi guys, I have a pentaho integration tool-etl, which is running in windows, but suddenly stops at night level at unknown intervals ...any particular reason behind it

PostgreSQL

18 Dec 2024 12:28

Please create temporary tablespace and assign to users. It is storing in storage.. once session is completed, automatically removed

PostgreSQL

18 Dec 2024 05:08

Good evening, maybe someone can guide me, I have a cluster where connections are made through pgpool on port 9999 using a virtual IP, I want to create a user that connects through the virtual IP and is only read-only, it gives me this error Unable to connect to server connection failed to server 192.168.15.145 port 9999 failed error failed to authenticate with backend using scram detail valid password not found, I already created the user but when I use postgres port 5432 it does allow me to connect but I don't want it there, I want it through port 9999 so that it does the correct pgpool balancing, how could I do where should I create the user? In pgpool_hba.conf?? Where and the postgres encryption method is scram, and pgpool md5, can someone explain to me if it is possible and what I am doing

PostgreSQL

17 Dec 2024 14:35

I have checked the replication slot and there is no abondoned slot. Also before no archiving was there but I set it now. But the issue is if all 539 gb wal files will copy to remote server , it will fail because not enough space. So this is the scenario. How to tackle this

PostgreSQL

17 Dec 2024 14:20

Can anyone pls help. My whole motto is to reduce the pg_wal size without affecting replication and archiving. How to achieve this?

PostgreSQL

17 Dec 2024 14:09

Thank u for all information but I am still confused how to reduce size of pg_wal on master server. After setting archive command on master it will copy the wal files to a remote server and if it copies all files of 539 gb to remote server, it will fail because remote server has not this space.
So in this scenario what should I do to to reduce pg_wal size till 50 gb

PostgreSQL

17 Dec 2024 13:44

Or for miscellaneous purposes or PITR, or auditing, or....

PostgreSQL

17 Dec 2024 13:42

https://postgresqlco.nf/doc/en/param/wal_keep_size/

PostgreSQL

17 Dec 2024 13:41

The archived WAL segments will be considered for deleting after two checkpoints. You can see where the archiver is currently working on by checking aforementioned view. *Did you?*

PostgreSQL

17 Dec 2024 13:41

It should decrease automatically, assuming postgresql believes that the wal has been archived and there is no pending replication slot

PostgreSQL

19 Dec 2024 09:37

temp tables are written into a special schema, on disk. But they are not WAL logged (i.e. not synced), so they essentially reside in the shared buffers, if they grow larger they end up in the OS' filesystem cache and *may* spill to the filesystem.
N.B.: the catalog changes related to TEMP tables *are* WAL logged.

PostgreSQL

19 Dec 2024 09:27

Postgresql on windows 😢

PostgreSQL

19 Dec 2024 09:23

That may well be your problem... 5-10 days might be the patch & reboot cycle in your organisation. I've worked in several large shops that rebooted each Window$ machine (including servers) every weekend.

PostgreSQL

18 Dec 2024 23:30

I guess you'll find what you need here: https://jdbc.postgresql.org/documentation/use/#connecting-to-the-database

PostgreSQL

18 Dec 2024 15:04

Can anyone help me out

PostgreSQL

18 Dec 2024 14:57

Give me the jdbc url to connect postgres in Databricks help me in this

PostgreSQL

18 Dec 2024 08:25

Dear collegues, hello

Could anyone tell me which component of memory(RAM, disk) stores temp tables in postgres?
As i know, temp tables are storing while the session or transaction is alive
So in this case where temp tables are storing?

PostgreSQL

18 Dec 2024 05:01

Can I manually delete 2 months older wal files from pg_wal on master if I take full hot backup everyday? Will it cause any error on replication or anything else?

PostgreSQL

17 Dec 2024 14:24

I will say it once again, the database will not delete a wal segment until:
- it has been succesfully archived
- there are no more replication slots needing that segment

If you have >500gb of of wal segments, check the logs because something is going very wrong in your setup

PostgreSQL

17 Dec 2024 14:18

Ok. It means suppose I set wal keep size to 50 gb. Will it reduce the pg_wal size to 50 gb from 539 gb?

PostgreSQL

17 Dec 2024 14:01

A quick search in this chat would have discovered this...

PostgreSQL

17 Dec 2024 13:43

In case your standby points directly to the pg_wal folder of the primary server

PostgreSQL

17 Dec 2024 13:41

Then what is role of wal keep size

PostgreSQL

17 Dec 2024 13:41

Aka, as i said earlier:
- check that your archive command is returning status correctly
- check that you don't have any replication slots that have been left abandoned

PostgreSQL

17 Dec 2024 13:39

Sir how it will decrease automatically. Is there any specific parameter for this?