first, make a copy of your ~/pgsql/data, or wherever you know your db is located.
have you used pgadmin?
you could try to open your db through pgadmin via tunnelling ssh.
i'm afraid you would get just the few tables you have on pgsql, those you mentioned.
at least try it out and if get in you can visualized the whole data and even save a copy.
ask on the postgresql users list
best hopes