Re: pgadmin connection via tunnel and ubuntu user instead of postgres - Mailing list pgsql-general

From Paul S
Subject Re: pgadmin connection via tunnel and ubuntu user instead of postgres
Date
Msg-id 000001cdf124$fed0b5e0$fc7221a0$@gmail.com
Whole thread Raw
In response to Re: pgadmin connection via tunnel and ubuntu user instead of postgres  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: pgadmin connection via tunnel and ubuntu user instead of postgres
Re: pgadmin connection via tunnel and ubuntu user instead of postgres
List pgsql-general
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.

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





-----Original Message-----
From: Adrian Klaver [mailto:adrian.klaver@gmail.com]
Sent: Saturday, January 12, 2013 7:08 PM
To: pasilveira
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgadmin connection via tunnel and ubuntu user instead
of postgres

On 01/11/2013 09:31 PM, pasilveira wrote:
> Hello,
>
> I'm forced to log into a server via SSH and the ubuntu user via ssh keys.
> The ubuntu Postgres OS user has no password by default.  When I log in
> via ssh, I log in via the ubuntu user, and then "sudo su - postgres"
> to then be able to execute "psql" to enter into postgres.  This all works
fine.
>
> When I try to connect via PGAdmin3, I setup a tunnel forwarding a port
> to the ubuntu servers postgres port and try to connect that way.  This
> fails beause I'm connecting in via the ubuntu user and not the
> postgres user directly.

What exactly is the error?
Seems you may not have pg_hba.conf set up to allow access for the ubuntu
user.

  I've even tried adding the sudo su - postgres to the "Remote
> Command" options in putty under connection --> SSH and although it
> does turn my user into the postgres OS user, pgadmin will still not
> connect via that tunnel.
>
> Any ideas on what my options are?

Set  up SSL connections for the Postgres server?

http://www.postgresql.org/docs/9.2/interactive/ssl-tcp.html

>
> Thanks
>
>
>

--
Adrian Klaver
adrian.klaver@gmail.com



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pgadmin connection via tunnel and ubuntu user instead of postgres
Next
From: Adrian Klaver
Date:
Subject: Re: pgadmin connection via tunnel and ubuntu user instead of postgres