Re: Remote Access to pgsql DB ???

You definitely can do a remote connect- I do all of my work this way, and it
runs smoothly.

In addition to Troy's suggestions you might also check to be sure the host
DB is really running with -i set on it. You should be able to see the whole
command line for the postmaster that is running with a "ps ax". It seems
like quite a few folks have trouble with a startup script somewhere
subverting their intentions. If you're on 7.1 or above, it is better to set
tcpip_socket=1 in the postgresql.conf file.

-Nick

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org
> [mailto:pgsql-general-owner(at)postgresql(dot)org]On Behalf Of Campano, Troy
> Sent: Monday, December 10, 2001 12:11 PM
> To: 'Steve Brett'; pgsql-general(at)postgresql(dot)org
> Cc: pgsql-general(at)postgresql(dot)org; 'fNoorbakhsh(at)tecways(dot)com'
> Subject: Re: [GENERAL] Remote Access to pgsql DB ???
>
>
>
> I think you can.
>
>
> I have a linux node named BETALIN and another linux node that has the
> database on it named ARCHER.
>
>
> I log into BETALIN and at the command prompt I run:
>
>
> psql databasename -U username --host=archer
>
> I also use pgadmin to access the database from a Windows machine
> (this uses
> ODBC)
>
>
> Make sure you have the ip's set correctly in pg_hba.conf
>
>
> -----Original Message-----
> From: Steve Brett [mailto:steve(dot)brett(at)e-mis(dot)com]
> Sent: Monday, December 10, 2001 8:02 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: Re: [GENERAL] Remote Access to pgsql DB ???
>
>
> i don't know if you can use psql to connect to remote servers - in fact i
> think you can't.
>
> try connecting from omega using a tool such as pgaccess in
> xwindows and you
> should be fine or telnet or ssh onto the orion box from omega and run psql
> from there i use IVT-TELNET for this at work.
>
> Steve
>
> "Fariba Noorbakhsh" <fNoorbakhsh(at)tecways(dot)com> wrote in message
> news:3C0CDF34(dot)CC972E7C(at)ccs-munich(dot)de(dot)(dot)(dot)
> > 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 &
> >
> > so I have done that, I also changed pg_hba.conf on ORION for OMEGA
> > IP address like:
> >
> > host all 172.21.2.41 255.255.255.255 trust
> >
> > But still I can not run psql mydb from Omega:
> >
> > psql: connectDBStart() -- connect() failed: Connection refused
> > Is the postmaster running locally
> > and accepting connections on Unix socket '/tmp/.s.PGSQL.5432'?
> >
> > Why should I get this error when I have run postmaster with -i on
> > ORION?
> >
> > Shall I run that on OMEGA as well, then it's not a remote access?!!!
> >
> > I appreciate your help!
> >
> > Thanks in advance,
> > Fariba
> >
> >
> > ---------------------------(end of
> > broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>