Bumped by Community user

occurred Jan 6 at 9:06

Bumped by Community user

occurred Sep 6, 2023 at 23:01

Bumped by Community user

occurred May 7, 2023 at 2:07

added 4 characters in body; edited title

Source Link

edited Apr 12, 2022 at 14:08

Giacomo1968

56.2k
23
167
214

Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?

I have postgresPostgreSQL running on my linuxLinux server.

PostgresPostgreSQL is enabled and is active after reboot. In

In the config file from postgresPostgreSQL 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 postgresdbPostgreSQL 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.

Why is my service not working properly until I restart it manually?

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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 postgresdb 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.

Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?

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.

deleted 32 characters in body

Source Link

edited Apr 12, 2022 at 13:50

msba

41
2
6

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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, everythingremote access on the postgresdb 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.

raspberrypi systemd[1]: Finished PostgreSQL RDBMS.

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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, everything 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.

raspberrypi systemd[1]: Finished PostgreSQL RDBMS.

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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 postgresdb 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.

added 592 characters in body

Source Link

edited Apr 12, 2022 at 1:23

msba

41
2
6

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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, everything 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.

raspberrypi systemd[1]: Finished PostgreSQL RDBMS.

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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, everything works perfectly fine:

sudo systemctl restart postgresql

I have postgres running on my linux server.

Postgres is enabled and is active after reboot. In the config file from postgres 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, everything 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.

raspberrypi systemd[1]: Finished PostgreSQL RDBMS.

Source Link

asked Apr 12, 2022 at 1:13

msba

41
2
6

Loading

Stack Exchange Network

Return to Question

Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?

Why is my service not working properly until I restart it manually?

Why is my PostgreSQL startup service not working properly until I restart it manually after reboot?