On 01/12/2013 04:29 PM, Paul S wrote:
Thanks Adrian, Right, the pg_hba.conf file is setup with the default settings. # Database administrative login by Unix domain socket local all postgres peer # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all peer # IPv4 local connections: # host all all 127.0.0.1/32 md5 host all all 0.0.0.0/0 md5 # IPv6 local connections: host all all ::1/128 md5 I think that I may have to just use the PostgreSQL database user password to log in and I'll be fine. I was hoping that I could mimic what I was doing with SSH in that I could sudo su - postgres and then go into postgres as the postgres OS user without a DB password and I'd be done. I don't think the tunnel is allowing me to do that so I'll have to supply the postgres DB user password to still get in.
Well PgAdmin connects to a service(Postgres) not a user account so I would think what you want to do would be difficult.
I think I can work with that but it's just a little less optimal that I was hoping for. Logging in just like I do in SSH would have been much easier. Thanks, Paul
-- Adrian Klaver adrian.klaver@xxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
