PostgreSQL: Difference between revisions
imported>Malteneuss m Fix headline text |
imported>Hofsiedge m Added a missing > in a </code> tag in the "Verify setup" section |
||
| Line 34: | Line 34: | ||
</syntaxhighlight> | </syntaxhighlight> | ||
We have to switch to a system user like "postgres" with <code>sudo -u postgres</code, because by default <code>psql</code> logs you into the DB user of the same name as the current Linux/system user. By default, NixOS creates a system and DB user names "postgres". | We have to switch to a system user like "postgres" with <code>sudo -u postgres</code>, because by default <code>psql</code> logs you into the DB user of the same name as the current Linux/system user. By default, NixOS creates a system and DB user names "postgres". | ||
So the line <code>postgres=# </code> shows that we are now logged-in as DB user "postgres". | So the line <code>postgres=# </code> shows that we are now logged-in as DB user "postgres". | ||