PM
To: Paul S
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgadmin connection via tunnel and ubuntu user instead
of postgres
On 01/12/2013 04:29 PM, Paul S wrote:
> Thanks Adrian,
> I think I can work with that but it's just a little less optimal that
> I was hoping for. L
I believe the main problem in this situation is that you are trying to use
a security context that only exists on the server you are trying to connect
to, this is not available from a remote client.
You need to setup a authentication method that does allow this, or specify
credentials on connectin
On 01/12/2013 04:29 PM, Paul S wrote:
Thanks Adrian,
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.
Just had a thought. Could you not set up SSH keys for the postgres user
and connect the
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 postgrespeer
# TYPE DATABASEUSERADDRESS
in just like I do in SSH would have been much easier.
Thanks,
Paul
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@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
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"
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 fi
