tcpip connections..
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!!
Travis
All,
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..
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 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!!
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)
Import Notes
Resolved by subject fallback
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
Import Notes
Reply to msg id not found: 20021121130925.7782A47628E@postgresql.orgReference msg id not found: 20021121130925.7782A47628E@postgresql.org | Resolved by subject fallback
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
Import Notes
Resolved by subject fallback
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
Import Notes
Reply to msg id not found: 20021121140618.43528475DA7@postgresql.orgReference msg id not found: 20021121140618.43528475DA7@postgresql.org | Resolved by subject fallback
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
Import Notes
Reply to msg id not found: ChristophDalitz'smessageofThu21Nov2002150007+0100Reference msg id not found: 20021121130925.7782A47628E@postgresql.org
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
Import Notes
Resolved by subject fallback