how do I login to postgres

[JCrou82]

how do i login to postgres. I am loged in to a RH LInux 7.0 machine as root. when i type in at the terminal "psql"
i get an error "psql: FATAL 1: database "root" does not exist in the system catalog"

I do not know what users are set up on here because i was hired to replace the dbadmin that set up the dbserver.

Is there any way of figuring out the users. I know that in mysql, i could login as root and then be able to view the users with their permissions and datatbases. how do i login to postgres as root since i don't know what users are created.

Thank you in advanced

 

[Leland123]

Hi JCrou82,

As root edit the pb_hba.conf file and set all security back to trust. Then you can login to postgres without a password. You can used pgaccess to create a new password for postgres. Then as root edit pg_hba.conf and set security back as it was originally.

Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox