From PostgreSQL to SQL Server (No User/Pass)
I think currently you are not able to log into the postgresql database? If this is the case you can get access of the database by changing the access authorization. Please open  pg_hba.conf and change the following line:

local   all             postgres                                md5


to:

local   all             postgres                                peer


or

local   all             postgres                                trust


Now restart the postgresql service. You should now be able to connect to the database by typing: psql

You can get list of databases by typing: psql -l