Timeline for After renaming postgres user, getting "role 'postgres' does not exist" in logs on PostgreSQL startup
Current License: CC BY-SA 3.0
7 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Apr 13, 2017 at 12:42 | history | edited | CommunityBot |
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
|
|
| Jan 22, 2016 at 15:00 | vote | accept | Chris Williams | ||
| Jan 22, 2016 at 15:00 | answer | added | Chris Williams | timeline score: 1 | |
| Jan 20, 2016 at 2:00 | comment | added | Chris Williams | It's not someone running psql from the command line that is causing the error in the log. It is showing up every time the server starts. It's as if the process of starting the server through systemctl is also running some kind of script that tries to login to the db and perform some action but is still attempting to run as postgres. | |
| Jan 20, 2016 at 0:38 | comment | added | dizzystar | you need to run psql -U <new_user_name> to login as the alternate user. | |
| Jan 19, 2016 at 22:00 | comment | added | Philᵀᴹ | Security through obscurity? How silly | |
| Jan 19, 2016 at 20:28 | history | asked | Chris Williams | CC BY-SA 3.0 |