Home / server / Questions / 310176
Accepted
Cocowalla
Asked: 2011-09-11 23:14:56 +0800 CST

Lost PostgreSQL Superuser Username and Password

  • 772

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
postgresql

1 Answers

  1. Best Answer

    You can try to run PostgreSQL in single-user mode. On my system (Linux), I've been able to get superuser sql shell with following command: sudo -u postgres postgres90 --single postgres -D /var/lib/postgresql/9.0/data/.

    sudo -u postgres here is to drop priveledges (postgres refuses to run under priveledged account`, other params should be easy to understand.

    In single-user shell you should be able to create new user or SELECT * FROM pg_user;

    • 11