postgresql service fail to start

[pasqui23]

Describe the bug
After services.postgresql.enable=true and nixos-rebuild switch,

systemctl status postgresql
● postgresql.service - PostgreSQL Server
   Loaded: loaded (/nix/store/qmkxcb588mayqmhja7lfq0p30qdqdvys-unit-postgresql.service/postgresql.service; enabled; vendor preset: enabled)
   Active: failed (Result: timeout) since Mon 2019-07-29 15:07:59 CEST; 2min 23s ago
  Process: 29988 ExecStartPre=/nix/store/6ypijng9k2fvifppipj8w7bg2vczz087-unit-script-postgresql-pre-start (code=exited, status=0/SUCCESS)
  Process: 29989 ExecStart=/nix/store/6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start (code=exited, status=0/SUCCESS)
 Main PID: 29989 (code=exited, status=0/SUCCESS)

lug 29 15:05:58 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:05:58.678 GMT [30000] LOG:  database system was shut down at 2019-07-29 12:05:08 GMT
lug 29 15:05:58 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:05:58.779 GMT [29989] LOG:  database system is ready to accept connections
lug 29 15:07:57 nixos systemd[1]: postgresql.service: Start operation timed out. Terminating.
lug 29 15:07:59 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:07:57.995 GMT [29989] LOG:  received fast shutdown request
lug 29 15:07:59 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:07:58.427 GMT [29989] LOG:  aborting any active transactions
lug 29 15:07:59 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:07:58.429 GMT [29989] LOG:  background worker "logical replication launcher" (PID 30006) exited with exit code 1
lug 29 15:07:59 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:07:58.430 GMT [30001] LOG:  shutting down
lug 29 15:07:59 nixos 6f1pbjrxjx2fr8ffy3m1fd82jqyp8sd4-unit-script-postgresql-start[29989]: 2019-07-29 13:07:59.575 GMT [29989] LOG:  database system is shut down
lug 29 15:07:59 nixos systemd[1]: postgresql.service: Failed with result 'timeout'.
lug 29 15:07:59 nixos systemd[1]: Failed to start PostgreSQL Server.

To Reproduce
Steps to reproduce the behavior:

1. services.postgresql.enable=true in /etc/nixos/configuration.nix
2. nixos-rebuild switch
3. systemctl status postgresql

Expected behavior
postgresql up and running,ready to accept connections

Metadata

• system: "x86_64-linux"
• host os: Linux 5.1.16, NixOS, 19.09pre186408.3d84cffe955 (Loris)
• multi-user?: yes
• sandbox: yes
• version: nix-env (Nix) 2.3pre20190712_aa82f8b
• channels(root): "nixos-19.09pre186408.3d84cffe955"
• nixpkgs: /nix/var/nix/profiles/per-user/root/channels/nixos

Maintainer information:

# a list of nixpkgs attributes affected by the problem
attribute:
# a list of nixos modules affected by the problem
module:
  - services.postgresql

[aanderse]

ping @danbst @thoughtpolice

[danbst]

This was fixed in master: #61581 (comment)

[aanderse]

Thanks @danbst!