4 ms·
Running PostgreSQL on Ubuntu as Non-Postgres User: The Definitive Guide
- codetrotter 3y ago> We’ve just gone through a detailed process of setting up PostgreSQL under a non-default user on Ubuntu. This process, although a bit involved, provides us with a more streamlined and efficient way to manage our server, avoiding the constant need to switch between user accounts. ??? I don’t understand the point of doing that. For example when I want to dump PostgreSQL db “peertube_prod” I run sudo pg_dump -U postgres peertube_prod And likewise whenever you want to use psql sudo psql -U postgres I have almost never had any need for switching the shell session itself to that of the PostgreSQL user. So changing the whole setup of PostgreSQL would be meaningless for me at least.