I used the Proxmox helper scripts to deploy a Postgresql container and a Zabbix container. I followed all the post-install steps on the database to create a new admin user and change the password and I also installed adminer. I created a database called zabbix and can confirm it is created. In the Zabbix configuration I can't connect to the database because it can't seem to find a table for the dbversion.
![Studio Snippet 2024-07-18 at 15.53.40.jpg Studio Snippet 2024-07-18 at 15.53.40.jpg](https://forum.proxmox.com/data/attachments/71/71225-8deaf3f92bab5ef4db081c3bcbfe0208.jpg)
The database is there. I even tried to create a table called 'diversion', but that doesn't work.
![Studio Snippet 2024-07-18 at 15.50.02.jpg Studio Snippet 2024-07-18 at 15.50.02.jpg](https://forum.proxmox.com/data/attachments/71/71224-27c41e14130d89bbc1f0fc836dbddc63.jpg)
I've previously been able to create databases on other postgresql installs using pgAdmin without any issues. What am I missing?
My Postgresql container config is below:
arch: amd64
cores: 1
features: keyctl=1,nesting=1
hostname: postgresql
memory: 1024
net0: name=eth0,bridge=vmbr0,hwaddr=BC:24:11:1A:CE
C,ip=dhcp,type=veth
onboot: 1
ostype: debian
rootfs: local-raid10-vdev1:vm-105-disk-0,size=4G
swap: 512
tags: proxmox-helper-scripts
unprivileged: 1
![Studio Snippet 2024-07-18 at 15.53.40.jpg Studio Snippet 2024-07-18 at 15.53.40.jpg](https://forum.proxmox.com/data/attachments/71/71225-8deaf3f92bab5ef4db081c3bcbfe0208.jpg)
The database is there. I even tried to create a table called 'diversion', but that doesn't work.
![Studio Snippet 2024-07-18 at 15.50.02.jpg Studio Snippet 2024-07-18 at 15.50.02.jpg](https://forum.proxmox.com/data/attachments/71/71224-27c41e14130d89bbc1f0fc836dbddc63.jpg)
I've previously been able to create databases on other postgresql installs using pgAdmin without any issues. What am I missing?
My Postgresql container config is below:
arch: amd64
cores: 1
features: keyctl=1,nesting=1
hostname: postgresql
memory: 1024
net0: name=eth0,bridge=vmbr0,hwaddr=BC:24:11:1A:CE
onboot: 1
ostype: debian
rootfs: local-raid10-vdev1:vm-105-disk-0,size=4G
swap: 512
tags: proxmox-helper-scripts
unprivileged: 1