Jump to content

PostgreSQL: Difference between revisions

107 bytes added ,  29 November 2017
m
Adds citation/source for ident authentication use.
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.
Anonymous user