1

Lost PostgreSQL Superuser Username and Password

view story
linux-howto

http://serverfault.com – I have a PostgreSQL 8.4 database running on Windows, but I've lost the name of the superuser username, so am unable to connect. I've already configured pg_hba.conf to use trust to allow connections without a password, but I still need to know the name of a valid user to login. I've tried postgres, admin etc, but I always get: psql: FATAL: role "USERNAME" does not exist (HowTos)