Importing Zabbix Initial Schema into Separate PostgreSQL Database on Different Host?

[derrelaed]

Hello dear forum members,

I'm running two Debian servers, and I want to install the Zabbix server on one host while using a separate PostgreSQL database for Zabbix on the other host. The official Zabbix instructions mention the need to import the "initial schema" into the PostgreSQL database. However, since the Zabbix server and the database are on different hosts, I'm not sure how to proceed with the import.
Could you guide me on how to import the "initial schema" into the PostgreSQL database on the separate host? What steps should I follow, and is the transfer between the database and the Zabbix server encrypted?
Your assistance in successfully setting up my Zabbix monitoring environment would be highly appreciated!

Thank you for your support!

Best regards,

derrelaed

[cyber]

"import initial schema" ie "create empty database with all needed tables"

https://www.zabbix.com/documentation/current/en/manual/installation/install_from_packages/debian_ubuntu#creating-database

Yes, you can encrypt data transfer between server and DB. Depends, how you set up your DB users...

[derrelaed]

The response I received in the forum did not provide the solution I was looking for. I managed to resolve the issue myself. For those who might be interested, the command I used to import the schema to the dedicated database server is as follows:
zcat /usr/share/zabbix-sql-scripts/postgresql/server.sql.gz | psql -h <database-host> -U <database-user> -d zabbix