I have PostgreSQL running on my Linux server.
PostgreSQL is enabled and is active after reboot.
In the config file from PostgreSQL I enabled remote access. But every time after I reboot my device, the remote access is no longer available:
systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2022-04-12 02:05:22 CEST; 10min ago
Process: 491 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 491 (code=exited, status=0/SUCCESS)
CPU: 5ms
Apr 12 02:05:22 raspberrypi systemd[1]: Starting PostgreSQL RDBMS...
Apr 12 02:05:22 raspberrypi systemd[1]: Finished PostgreSQL RDBMS.
cat grafana.log
logger=tsdb.postgres t=2022-04-12T02:18:50.33+0200 lvl=eror msg="query error" err="dial tcp 192.1.1.1:5432: connect: connection refused"
After I restart the service, remote access on the PostgreSQL works perfectly fine:
sudo systemctl restart postgresql
systemctl status postgresql
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Tue 2022-04-12 02:53:47 CEST; 25min ago
Process: 2541 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 2541 (code=exited, status=0/SUCCESS)
CPU: 5ms
Apr 12 02:53:47 raspberrypi systemd[1]: Starting PostgreSQL RDBMS...
Apr 12 02:53:47 raspberrypi systemd[1]: Finished PostgreSQL RDBMS.