Re: Remote Access to pgsql DB ???

On Tue, 2001-12-04 at 15:44, Brent Verner wrote:
> [2001-12-04 15:35] Fariba Noorbakhsh said:
> | Hi,
> |
> | I have a question about remote access to Pgsql DB. I acctually want to
> | access mydb which located on a Unix server called ORION from another
> | Unix server called OMEGA.
> |
> | According to documentation I have to run postmaster on ORION with -i
> | option like:
> |
> | /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data &
>   [snip]
> | But still I can not run psql mydb from Omega:
>
> You need to say "psql -h orion mydb"

An even better way is to SSH to the machine and run either psql or
pgaccess over the secure connection.

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html