postgresql

Hello, Today I noticed that my PMG is not receiving mail any more. The log is showing showing a connection error to postgres database every minute. Dec 12 17:29:31 pmg pmg-smtp-filter[336]: starting database maintenance Dec 12 17:29:31 pmg pmg-smtp-filter[336]: end database maintenance (4 ms)...

I thought that it was true, but after reading some answers in this thread now I have doubts. The real reason why I want to know it's because of the full_page_writes parameter in postgresql DB. Setting it to off improves the performance greatly (almost x2) but for non COW FS keeps the DB in a...

I created a Proxmox server on an old computer and have a couple things running on it; Truenas, Plex, and now an Ubuntu 20.04 VM. I installed PostgreSQL on the Ubuntu VM and want to access the database from another machine on my local home network. How do I do that? I am pretty new to...

Hi, After upgraded by following this guide https://pmg.proxmox.com/wiki/index.php/Upgrade_from_6.x_to_7.0 PMG is working fine but after rebooting once, Postgresql failed to start as its config file /etc/postgresql/13/main/postgresql.conf version number changed from 13 to 11 on all lines. Tried...

Hello, I try to set up PMG as a mail filtering system in front of my mail server (which is Exim+dovecot based). My Exim uses domain and user lists stored at Postgres (no LDAP), and I really wonder if PMG can get mail lists from Postgres (or via some kind of HTTP API requests) from my server...

Anyone setup a data science environment on proxmox? Something akin to the data science machine you can roll on azure ( azure data science vm ) Is there an image for something like this or something close to this? use a vm or container? my VMs are on a single ssd drive. I am planning to...

I've been having this error for a few days now. Every day when I arrive in the morning, I see that mistake. Nothing has been changed, just updated, just like every beginning of the week. This error appears on the query screens However, graphics and statistics also do not work. E-mails...

Version: 5.2-2 in /var/lib/pmg/templates/postgresql.conf.in there are two timezone related parameters (timezone and log_timezone) with the default value of 'localtime'. When running without modification the PostgreSQL service fails to start. 2019-05-14 20:21:08.941 GMT [745] LOG: invalid...

Hi, I tried to install gitlab into LXC CT, but during the installation I received an error that PostgreSQL requires kernel.shmmax = 17179869184 I verify kernel.shmmax in CT: # cat /proc/sys/kernel/shmmax 18446744073692774399 If I try set this parameter in CT, I get error: sysctl -w...

Hi guys, My company have hundreds of Brazilian domains and emails in our PMG (5.0.78) global blacklist. Even with these domains and emails entries in global blacklist, we still receiving a lot of spam from them passing thru PMG and going to our mailboxes. We changed the blacklist rule also to...