Re: Update to postgresql 14.14

On 20/11/2024 18:15, Adrian Klaver wrote: On 11/20/24 06:26, Levente Birta wrote: Hi I'm trying to update postgresql 14.13->14.14, but there is a libllvm 18.1 dependency. I have enabled the pgdg-centos8-sysupdates repo, but as I see there is no llvm 18, only 16/17. Is somethin

Update to postgresql 14.14

Hi I'm trying to update postgresql 14.13->14.14, but there is a libllvm 18.1 dependency. I have enabled the pgdg-centos8-sysupdates repo, but as I see there is no llvm 18, only 16/17. Is something that I miss? All this on rocky linux 8, up to date. Thanks Levi

Power loss test

Hello For many years when I get a new server every time I tested the storage system with diskchecker.pl for power loss. I'm just curious if there is any other/newer tool to test ? Thanks Levi

Recommended storage hardware

Hi all What storage is recommended nowdays? Currently I'm using two of SSD DC P3700 Series add in card (SSDPEDMD400G4) in soft raid 1, but it's pretty old and I have to replace the whole server. Before, I used Intel too and I'm very satisfied, but now that intel sold the ssd business looks

pg_cron question

Hi all Is there a way to run pg_cron job only once? Or can I get somehow inside the cronjob the ID of a running job to unschedule? Thanks Levi

pgadmin4 error

Hello, I use pgadmin4 with server installation, on Centos7, installed from official postgresql yum repo. Since v4.24, IIRC, I got error when I try to visualize the SQL for a table: INTERNAL SERVER ERROR ... expected token 'end of statement block', got '.' For views, foreign tables or any o