2 июн. 2014 г. · For a login shell, sudo -u postgres -i is preferable to sudo su - postgres . It doesn't require that the user have root access in /etc/sudoers , ...

6 февр. 2010 г. · You must be root to su to the postgres user without entering a password. On most systems the Postgres Unix account is locked (no password will work).

26 сент. 2013 г. · sudo doesn't use your user's path or the postgres user's path. sudo has its own path, defined by the the secure_path variable in the file /etc/sudoers.

18 янв. 2020 г. · I've installed postgres on Ubuntu and it switched me to postgres user. I've opened psql created a database and then decided to switch back to root. However, it ...

5 мая 2016 г. · When you sudo to postgres, the psql command takes your identity from your sudo'ed shell. Without "-U", it tries to use the user ID and looks it ...

15 нояб. 2013 г. · Store your data in the database and sync the servers with a cron job. Basically generate a new sudoers file periodically -- really easy to code ...

6 мар. 2023 г. · When you run sudo su - postgres. It invokes a new shell, which is owned by postgres user. Then, from that shell you run another sudo:

26 апр. 2014 г. · Firstly, always ALWAYS use either the -l or just plain - when using sudo. For example, " sudo su - postgres " not " sudo su postgres ".

19 июн. 2020 г. · I have installed Postgres on an Ubuntu 16.04 server, but I'm working in a corporate environment and am not able to sudo -u postgres.

28 мая 2019 г. · There isn't a default password. The default authentication mode for PostgreSQL is set to ident, not to sql DB user/password.