From: | John DeSoi <desoi(at)pgedit(dot)com> |
---|---|
To: | <operationsengineer1(at)yahoo(dot)com> <operationsengineer1(at)yahoo(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: psql, pg_dumpall, remote server questions... |
Date: | 2005-09-13 01:35:49 |
Message-ID: | A2C075CC-4537-430A-90E3-B1CC31B69682@pgedit.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On Sep 12, 2005, at 7:46 PM, <operationsengineer1(at)yahoo(dot)com>
<operationsengineer1(at)yahoo(dot)com> wrote:
> i think i log log into pgsql like so...
>
> psql dbname -h [full url to db on webhost here - is
> this possible?] -U [username goes here] -p [port goes
> here]
>
> will this work? can i access my webhost in this
> manner (putting url in as host option)?
The -h parameter is not a URL, it is just a host name (or IP
address). Yes, you can run psql (and other PostgreSQL utilities) this
way, but it assumes the proper permissions have been setup in the
pg_hba.conf file to allow it (see http://www.postgresql.org/docs/8.0/
interactive/client-authentication.html).
SSH access may be an alternative for you. I put a tip here about
setting up SSH tunneling for PostgreSQL:
http://pgedit.com/tip/postgresql/ssh_tunneling
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Cook | 2005-09-13 02:11:05 | Getting connected - Java application to PostgreSQL |
Previous Message | A Gilmore | 2005-09-13 01:04:00 | dbi:pg and meta commands |