Timeline for Createuser: could not connect to database postgres: FATAL: role "tom" does not exist
Current License: CC BY-SA 3.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 18 at 7:22 | comment | added | buncis | for super user you use sudo -u postgres createuser username -s to set the password you do psql postgres then (in postgres console) \password username; | |
| Jan 18, 2020 at 23:17 | review | Suggested edits | |||
| Jan 19, 2020 at 4:20 | |||||
| Sep 9, 2014 at 11:54 | comment | added | Craig Ringer | Three options. (a) Set a password for that user and edit pg_hba.conf to use md5 auth for that user (see the manual); (b) Create an OS user by the same name and keep on using peer auth; or (c) more advanced, create a pg_ident.conf mapping to allow your OS user to log in as the new user. | |
| Sep 9, 2014 at 10:45 | comment | added | Jony | well after creating owning_user, How do yo connect with this user? I mean to connect default user i use , sudo -u postgres psql postgres . same way how to connect owning_user? | |
| Jul 15, 2014 at 6:42 | history | edited | Craig Ringer | CC BY-SA 3.0 | added 2 characters in body |
| Jun 7, 2013 at 0:04 | history | answered | Craig Ringer | CC BY-SA 3.0 |