Password for database user

[tonis]

How can I set a password for the database user?

The configuration in the quick install file assumes that the postgresql user is configured with "trust" authentication in pg_hba.conf, but that's what most people would want.

[y-mori0110]

you can define PGPASSFILE to pgsql_funcs.conf and set password for database.

1. add "export PGPASSFILE=xx" to pgsql_funcs.sql

PGHOST=localhost
PGPORT=5432
PGROLE=postgres
PGDATABASE=postgres
export PGPASSFILE=/usr/local/etc/pgpass

2. Create pgpass file at /usr/local/etc/.
   localhost:5432:*:postgres:somepassword

3. Grant only the read permission to the start user of zabibx agent.
   $ chmod 600 /usr/local/etc/pgpass

ref)
https://www.postgresql.org/docs/9.6/static/libpq-pgpass.html

[tonis]

Thank you. It would be good if you could add it to the readme or quick install file. I knew about the .pgpass file but not how to give it to zabbix.