Herd seemed to fail to stop the 'postgres' service

Herd seemed to fail to stop the 'postgres' service

[Jukka]

[-- Attachment #1: Type: text/plain, Size: 2655 bytes --]


Someone on the IRC channel told me to post this here.

But basically I've installed 'postgresql-service' in a system config, like this:

                  (postgresql-service
                   #:config-file (local-file "../psql/postgresql.conf")
                   #:data-directory "/data/psql"
                   #:locale "en_US.utf8")
                  %base-services)))

I changed the contents of postgresql.conf (again), and re-ran "sudo guix system reconfigure".

Then I wanted to stop the postgres service, and I believe I ran: "sudo herd stop postgres".

The first time I did that, Herd told me it stopped postgres, but when called again, this happens:

~$ sudo herd stop postgres
herd: service 'postgres' could not be found

(Why would the service "not be found", if it's installed?)


---------------- 'postgres' is listed as stopped:

~$ sudo herd status
Started:
 + loopback
 + term-tty5
 + term-tty1
 + root
 + console-font-tty6
 + console-font-tty4
 + file-system-/dev/pts
 + term-tty3
 + host-name
 + term-tty4
 + syslogd
 + term-tty2
 + console-font-tty1
 + nscd
 + console-font-tty2
 + file-system-/data
 + user-processes
 + console-font-tty3
 + term-tty6
 + root-file-system
 + networking
 + file-system-/gnu/store
 + console-font-tty5
 + guix-daemon
 + user-file-systems
 + file-system-/dev/shm
 + urandom-seed
 + ssh-daemon
 + udev
 + file-systems
Stopped:
 - user-homes
 - postgres


-------------------- But it's still running:

~$ ps aux | grep postgres
postgres   252  0.0  0.7 312888 29496 ?        S    22:10   0:00 /gnu/store/3rg0avphlwgq56qjxd8gr8xbmh1rwkal-postgresql-10.1/bin/postgres --config-file=/gnu/store/hh3s1gpyfv0fa4g7n3x6qyy4272nkb7g-postgresql.conf -p 5432 -D /data/psql
postgres   253  0.0  0.0  23236  2296 ?        Ss   22:10   0:00 postgres: logger process
postgres   255  0.0  0.0 312888  2576 ?        Ss   22:10   0:00 postgres: checkpointer process
postgres   256  0.0  0.1 312888  4872 ?        Ss   22:10   0:00 postgres: writer process
postgres   257  0.0  0.5 312888 20460 ?        Ss   22:10   0:00 postgres: wal writer process
postgres   258  0.0  0.1 313192  5536 ?        Ss   22:10   0:00 postgres: autovacuum launcher process
postgres   259  0.0  0.0  23236  2260 ?        Ss   22:10   0:00 postgres: stats collector process
postgres   260  0.0  0.0 313172  3644 ?        Ss   22:10   0:00 postgres: bgworker: logical replication launcher




---------------------------
So yeah, that's pretty much it :)

Not sure what else to tell you now.

Let me know if you have ideas, etc.



Best,
Jukka








[-- Attachment #2: Type: text/html, Size: 5813 bytes --]

Re: Herd seemed to fail to stop the 'postgres' service

[Jukka]

[-- Attachment #1: Type: text/plain, Size: 5364 bytes --]


More output:

---------------------------------------
~$ ps aux | grep postgres
postgres   252  0.0  0.7 312888 29496 ?        S    22:10   0:00 /gnu/store/3rg0avphlwgq56qjxd8gr8xbmh1rwkal-postgresql-10.1/bin/postgres --config-file=/gnu/store/hh3s1gpyfv0fa4g7n3x6qyy4272nkb7g-postgresql.conf -p 5432 -D /data/psql
postgres   253  0.0  0.0  23236  2296 ?        Ss   22:10   0:00 postgres: logger process
postgres   255  0.0  0.0 312888  2576 ?        Ss   22:10   0:00 postgres: checkpointer process
postgres   256  0.0  0.1 312888  4872 ?        Ss   22:10   0:00 postgres: writer process
postgres   257  0.0  0.5 312888 20460 ?        Ss   22:10   0:00 postgres: wal writer process
postgres   258  0.0  0.1 313192  5536 ?        Ss   22:10   0:00 postgres: autovacuum launcher process
postgres   259  0.0  0.0  23236  2260 ?        Ss   22:10   0:00 postgres: stats collector process
postgres   260  0.0  0.0 313172  3644 ?        Ss   22:10   0:00 postgres: bgworker: logical replication launcher

---------------------------------------
~$ sudo herd start postgres
Password:
Service postgres has been started.
---------------------------------------

~$ ps aux | grep postgres
postgres   252  0.0  0.7 312888 29496 ?        S    22:10   0:00 /gnu/store/3rg0avphlwgq56qjxd8gr8xbmh1rwkal-postgresql-10.1/bin/postgres --config-file=/gnu/store/hh3s1gpyfv0fa4g7n3x6qyy4272nkb7g-postgresql.conf -p 5432 -D /data/psql
postgres   253  0.0  0.0  23236  2296 ?        Ss   22:10   0:00 postgres: logger process
postgres   255  0.0  0.1 312988  6880 ?        Ss   22:10   0:00 postgres: checkpointer process
postgres   256  0.0  0.1 312888  4872 ?        Ss   22:10   0:00 postgres: writer process
postgres   257  0.0  0.5 312888 20460 ?        Ss   22:10   0:00 postgres: wal writer process
postgres   258  0.0  0.1 313192  5536 ?        Ss   22:10   0:00 postgres: autovacuum launcher process
postgres   259  0.0  0.0  23236  2260 ?        Ss   22:10   0:00 postgres: stats collector process
postgres   260  0.0  0.0 313172  3644 ?        Ss   22:10   0:00 postgres: bgworker: logical replication launcher
postgres   379  0.0  0.0      0     0 ?        Zs   23:04   0:00 [kfg8y44w7771f7x] <defunct>

(I wonder what's up with the <defunct> process there)


---------------------------------------
~$ sudo herd stop postgres
herd: service 'postgres' could not be found
---------------------------------------



> On 5 Jan 2018, at 22:46, Jukka <email@close2design.com> wrote:
> 
> 
> Someone on the IRC channel told me to post this here.
> 
> But basically I've installed 'postgresql-service' in a system config, like this:
> 
>                   (postgresql-service
>                    #:config-file (local-file "../psql/postgresql.conf")
>                    #:data-directory "/data/psql"
>                    #:locale "en_US.utf8")
>                   %base-services)))
> 
> I changed the contents of postgresql.conf (again), and re-ran "sudo guix system reconfigure".
> 
> Then I wanted to stop the postgres service, and I believe I ran: "sudo herd stop postgres".
> 
> The first time I did that, Herd told me it stopped postgres, but when called again, this happens:
> 
> ~$ sudo herd stop postgres
> herd: service 'postgres' could not be found
> 
> (Why would the service "not be found", if it's installed?)
> 
> 
> ---------------- 'postgres' is listed as stopped:
> 
> ~$ sudo herd status
> Started:
>  + loopback
>  + term-tty5
>  + term-tty1
>  + root
>  + console-font-tty6
>  + console-font-tty4
>  + file-system-/dev/pts
>  + term-tty3
>  + host-name
>  + term-tty4
>  + syslogd
>  + term-tty2
>  + console-font-tty1
>  + nscd
>  + console-font-tty2
>  + file-system-/data
>  + user-processes
>  + console-font-tty3
>  + term-tty6
>  + root-file-system
>  + networking
>  + file-system-/gnu/store
>  + console-font-tty5
>  + guix-daemon
>  + user-file-systems
>  + file-system-/dev/shm
>  + urandom-seed
>  + ssh-daemon
>  + udev
>  + file-systems
> Stopped:
>  - user-homes
>  - postgres
> 
> 
> -------------------- But it's still running:
> 
> ~$ ps aux | grep postgres
> postgres   252  0.0  0.7 312888 29496 ?        S    22:10   0:00 /gnu/store/3rg0avphlwgq56qjxd8gr8xbmh1rwkal-postgresql-10.1/bin/postgres --config-file=/gnu/store/hh3s1gpyfv0fa4g7n3x6qyy4272nkb7g-postgresql.conf -p 5432 -D /data/psql
> postgres   253  0.0  0.0  23236  2296 ?        Ss   22:10   0:00 postgres: logger process
> postgres   255  0.0  0.0 312888  2576 ?        Ss   22:10   0:00 postgres: checkpointer process
> postgres   256  0.0  0.1 312888  4872 ?        Ss   22:10   0:00 postgres: writer process
> postgres   257  0.0  0.5 312888 20460 ?        Ss   22:10   0:00 postgres: wal writer process
> postgres   258  0.0  0.1 313192  5536 ?        Ss   22:10   0:00 postgres: autovacuum launcher process
> postgres   259  0.0  0.0  23236  2260 ?        Ss   22:10   0:00 postgres: stats collector process
> postgres   260  0.0  0.0 313172  3644 ?        Ss   22:10   0:00 postgres: bgworker: logical replication launcher
> 
> 
> 
> 
> ---------------------------
> So yeah, that's pretty much it :)
> 
> Not sure what else to tell you now.
> 
> Let me know if you have ideas, etc.
> 
> 
> 
> Best,
> Jukka
> 
> 
> 
> 
> 
> 
> 


[-- Attachment #2: Type: text/html, Size: 10339 bytes --]

Re: Herd seemed to fail to stop the 'postgres' service

[Clément Lassieur]

Jukka <email@close2design.com> writes:

> Someone on the IRC channel told me to post this here.
>
> But basically I've installed 'postgresql-service' in a system config, like this:
>
>                   (postgresql-service
>                    #:config-file (local-file "../psql/postgresql.conf")
>                    #:data-directory "/data/psql"
>                    #:locale "en_US.utf8")
>                   %base-services)))
>
> I changed the contents of postgresql.conf (again), and re-ran "sudo guix system reconfigure".
>
> Then I wanted to stop the postgres service, and I believe I ran: "sudo herd stop postgres".
>
> The first time I did that, Herd told me it stopped postgres, but when called again, this happens:
>
> ~$ sudo herd stop postgres
> herd: service 'postgres' could not be found
>
> (Why would the service "not be found", if it's installed?)

Hi Jukka,

This is a bug with the 'postgres' service: it does not stop.  I reported
it there:
https://debbugs.gnu.org/cgi/bugreport.cgi?bug=29992

Thank you,
Clément