I have made the following entry in pg_hba.conf
local all all trust
does not accept blank as password. I am not able to run psql nor pg_ctl for same reason as most of the files are owned by postgres.
dhaval@ubuntu:~$ su -c "pg_ctl reload -D template1" Password: su: Authentication failure dhaval@ubuntu:~$ su -c psql Password: su: Authentication failure
I am giving the root password above but I guess its expecting "postgres" superuser password. I dont have the same. I need to reset it.
dhaval@ubuntu:~$ sudo -i -u postgres [sudo] password for dhaval: postgres@ubuntu:~$ psql Welcome to psql 8.3.7, the PostgreSQL interactive terminal.
The above has taken me postgreSQL command prompt. But I am still not sure why the "trust" was not working.