Thread: tcpip connections..
Do I need to change anything else besides tcpip_socket to true for remote connections? Is there anyway to check that thisis actually working? I'm having trouble connecting remotely.. btw thank you all for your help.. using postgresql hasmade my life easier than you would have ever believed!! Travis
All,
I didn't realize it.. but all of my scripts before this one using DBI::Pg have been local.. (I realized that
somewhereI've got to specify where the DB is) reading the DBI::Pg I'm not sure where to specifiy this at.. any help is
appreciated..
Travis
-----Original Message-----
From: Williams, Travis L, NPONS
Sent: Thursday, November 21, 2002 7:09 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] tcpip connections..
Do I need to change anything else besides tcpip_socket to true for remote connections? Is there anyway to check that
thisis actually working? I'm having trouble connecting remotely.. btw thank you all for your help.. using postgresql
hasmade my life easier than you would have ever believed!!
Travis
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
On Thu, 2002-11-21 at 13:09, Williams, Travis L, NPONS wrote: > Do I need to change anything else besides tcpip_socket to true for remote connections? Is there anyway to check that this is actually working? I'm having trouble connecting remotely.. btw thank you all for your help.. using postgresql has made my life easier than you would have ever believed!! > You should also check the authorisation in pg_hba.conf, to ensure that users are allowed to connect from the remote sites. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "A new commandment I give unto you; That ye love one another. As I have loved you, so ye also must love one another. By this shall all men know that ye are my disciples, if ye have love one to another." John 13:34,35
> Date: Thu, 21 Nov 2002 08:09:18 -0500 > From: "Williams, Travis L, NPONS" <tlw@att.com> > > Do I need to change anything else besides tcpip_socket to true for remote > connections? > For some strange reason this is configured via the file $PGDATA/pg_hba.conf instead via some table in the system catalog (that's what I would have expected). See the chapter "Client Authentification" in the Administrator's Guide. > Is there anyway to check that this is actually working? > Start psql. Christoph Dalitz
Did that.. forgot to mention it though.. Travis -----Original Message----- From: Oliver Elphick [mailto:olly@lfix.co.uk] Sent: Thursday, November 21, 2002 7:53 AM To: Williams, Travis L, NPONS Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] tcpip connections.. On Thu, 2002-11-21 at 13:09, Williams, Travis L, NPONS wrote: > Do I need to change anything else besides tcpip_socket to true for remote connections? Is there anyway to check that this is actually working? I'm having trouble connecting remotely.. btw thank you all for your help.. using postgresql has made my life easier than you would have ever believed!! > You should also check the authorisation in pg_hba.conf, to ensure that users are allowed to connect from the remote sites. -- Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight, UK http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C ======================================== "A new commandment I give unto you; That ye love one another. As I have loved you, so ye also must love one another. By this shall all men know that ye are my disciples, if ye have love one to another." John 13:34,35
> Date: Thu, 21 Nov 2002 08:18:22 -0500
> From: "Williams, Travis L, NPONS" <tlw@att.com>
>
> I didn't realize it.. but all of my scripts before this one using DBI::Pg
> have been local.. (I realized that somewhere I've got to specify where the DB is)
> reading the DBI::Pg I'm not sure where to specifiy this at.. any help is appreciated..
>
$dbh = DBI->connect("dbi:Pg:dbname=bla;host=blabla;port=blablabla", ...);
Christoph
Christoph Dalitz <christoph.dalitz@hs-niederrhein.de> writes: > For some strange reason this is configured via the file > $PGDATA/pg_hba.conf instead via some table in the system catalog > (that's what I would have expected). The reason (for using ph_hba.conf) actually makes sense. ;) If it was all stored in system catalogs, and you screwed them up and locked yourself completely out of the database, you'd be in big trouble. With text files, you can always fix them with an editor. -Doug
tada.. that worked.. thanks..
Travis
-----Original Message-----
From: Christoph Dalitz [mailto:christoph.dalitz@hs-niederrhein.de]
Sent: Thursday, November 21, 2002 8:19 AM
To: Williams, Travis L, NPONS
Cc: pgsql-general@postgresql.org
Subject: Re: tcpip connections..
> Date: Thu, 21 Nov 2002 08:18:22 -0500
> From: "Williams, Travis L, NPONS" <tlw@att.com>
>
> I didn't realize it.. but all of my scripts before this one
using DBI::Pg
> have been local.. (I realized that somewhere I've got to specify where
the DB is)
> reading the DBI::Pg I'm not sure where to specifiy this at.. any help
is appreciated..
>
$dbh = DBI->connect("dbi:Pg:dbname=bla;host=blabla;port=blablabla",
...);
Christoph