From: | aidan <aidanewen(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Administer postgres from PGAdmin on remote mac using ssh tunnel |
Date: | 2012-11-16 22:32:37 |
Message-ID: | 1353105157389-5732503.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I've got PostgreSQL installed on a Ubuntu server and I'm trying to connect to
that server using PGAdmin on a remote macbook.
I've created an ssh tunnel -
macbook:~postgres$ ssh -L 5423:localhost:5432 postgres(at)mydomain(dot)com
And I can connect using psql on the macbook as expected -
macbook:~ me$ psql -U postgres -p 5423 -h localhost
...
postgres=#
In the 'New Server Registration' window on PGAdminIII I'm entering the
following credentials -
Name - MyServer
Host - localhost
Port - 5423
Maintenance DB - postgres
Username - postgres
Password - <remote_postgres_password>
However the connection fails -
Error connecting to the server: FATAL: password authentication failed for
user "postgres"
Not sure what's going on here, these seem to be the same credentials I've
used for psql.
My pg_hba.conf file only has the following lines -
# Database administrative login by Unix domain socket
local all postgres peer
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 127.0.0.1/32 md5
# IPv6 local connections:
host all all ::1/128 md5
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Administer-postgres-from-PGAdmin-on-remote-mac-using-ssh-tunnel-tp5732503.html
Sent from the PostgreSQL - pgadmin support mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2012-11-19 07:59:33 | Re: column "tgconstraint" doest not exist |
Previous Message | lucidval | 2012-11-16 09:58:19 | Re: pgadmin 1.14.2, ERROR:column tgconstraint does not exist |