Jump to content

PostgreSQL: Difference between revisions

m
Added a missing > in a </code> tag in the "Verify setup" section
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".


Anonymous user