Re: psql, pg_dumpall, remote server questions...

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