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:

/var/lib/pgsql/15/data/pg_hba.conf
looks like -after some changes to try to login wihout password:

/var/lib/pgsql/data/pg_hba.conf
looks like:

Asked by La Vora Dev
(1 rep)
Oct 15, 2024, 04:12 PM
Last activity: Oct 16, 2024, 04:39 PM
Last activity: Oct 16, 2024, 04:39 PM