postgresql

  1. T

    VM keeps turning off by itself

    Running PVE 7.2-7. An Ubuntu Server VM keeps turning off by itself. Node and VM have been running O.K. for a few hundred days. No update to PVE or the VM could've caused this, as I haven't updated any of then. Where can I find any shutdown logs as to what initiated the shutdown? One indication...
  2. T

    [SOLVED] Connection to server on socket "/var/run/postgresql/.s.PGSQL.5432" failed:

    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)...
  3. H

    From a VM OS point of view: It's an "standard" FS (like ext4) still COW when residing in a ZVOL on top of a proxmox host with ZFS?

    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...
  4. H

    Need help with accessing PostgreSQL DB running on Ubuntu VM....

    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...
  5. K

    postgresql always rewrite config file after server rebooted

    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...
  6. A

    New to PMG, please advice on user list!

    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...
  7. J

    Data Science VM Setup

    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...
  8. T

    DBI Connect .... error ...

    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...
  9. J

    Default config template breaks PostgreSQL

    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...
  10. D

    Installing gitlab into LXC container (sysctl kernel.shmmax)

    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...
  11. F

    How to use global blacklist to increase spam score?

    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...

About

The Proxmox community has been around for many years and offers help and support for Proxmox VE, Proxmox Backup Server, and Proxmox Mail Gateway.
We think our community is one of the best thanks to people like you!

Get your subscription!

The Proxmox team works very hard to make sure you are running the best software and getting stable updates and security enhancements, as well as quick enterprise support. Tens of thousands of happy customers have a Proxmox subscription. Get yours easily in our online shop.

Buy now!