PostgreSQL: Difference between revisions
imported>Samueldr m Squashed a typo |
imported>Samueldr m Adds citation/source for ident authentication use. |
||
Line 8: | Line 8: | ||
* 17.09 and later: the superuser is <code>postgres</code> | * 17.09 and later: the superuser is <code>postgres</code> | ||
There is no password, [https://www.postgresql.org/docs/9.6/static/auth-methods.html#AUTH-IDENT Ident Authentication] is used. This means that you can access the database using a system user named like the database user. | There is no password, [https://www.postgresql.org/docs/9.6/static/auth-methods.html#AUTH-IDENT Ident Authentication] [https://github.com/NixOS/nixpkgs/blob/release-17.09/nixos/modules/services/databases/postgresql.nix#L182 is used]. This means that you can access the database using a system user named like the database user. | ||
Example for a 17.03 stateVersion. | Example for a 17.03 stateVersion. |