Sample Header Ad - 728x90

Unable to execute psql with postgres user

0 votes
0 answers
94 views
After a server failure I'm not able to execute psql like psql -U postgres nor like sudo -u postgres psql. In both cases I'm asked for the user password despite I've modified the pg_hba.conf files to trust all local connections and I've tried virtually all proposed solutions along the web. Would it be possible to delete the postgres user and re-create it without loosing the data? That's assuming the issue might be that the user got corrupted during the system failure. ## Detailed info * Logs at /var/lib/pgsql/15/data/log are all empty. * Service status looks like: enter image description here * /var/lib/pgsql/15/data/pg_hba.conflooks like -after some changes to try to login wihout password: enter image description here * /var/lib/pgsql/data/pg_hba.conf looks like: enter image description here
Asked by La Vora Dev (1 rep)
Oct 15, 2024, 04:12 PM
Last activity: Oct 16, 2024, 04:39 PM