Enter a host name and port number for the connection. And start postmaster with the -i switch to accept TCP/IP connections.
Dieter Simader http://www.sql-ledger.org (780) 472-8161 DWS Systems Inc. Accounting Software Fax: 478-5281 =========== On a clear disk you can seek forever =========== On Thu, 20 Jun 2002, Saurabh Shah wrote: > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Sergio A. > Kessler > > > >with this setting postgresql would NOT allow ANY connection > >from other machine, except the SAME machine were postgresql > >is installed. > >if you are running the perl script from machine A and > >postgresql is in machine B, then uncomment the > >tcpip_socket line... > > > >/sergio > > I tried with uncommeting and putting values with true and then also > false - but same error: > > Error! > connectDBStart() -- socket() failed: errno=2 > No such file or directory > > > I have insallted postgresql7.2.1 on cygwin on drive i: and Apache in > other drive c:\apache And perl in c:\perl > > But all are on the same machine. > > > I got some notes on postgresql resources: > > [{ > connectDBstart() -- connect() failed: No such file or directory > > Is the postmaster running locally and accepting connections on UNIX > socket '/tmp/.s.PGSQL.5432'? > > The last line is useful in verifying that the client is trying to > connect where it is supposed to. If there no postmaster running there, > the kernel error message will typically be either Connection refused or > No such file or directory, as illustrated. (It is particularly important > to realize that Connection refused in this context does not mean that > the postmaster got your connection request and rejected it -- that case > will produce a different message, as shown in the chapter on Client > Authentication.) Other error messages such as Connection timed out may > indicate more fundamental problems, such as a lack of network > connectivity. }] > > > > Do I have to tell somewhere in sql-ledger, or DBI or DBD:Pg the path to > /tmp/.s.PGSQL.5432' ? (I have got this file in > c:\cygwin\tmp\.s.PGSQL.5432) ?? > > Any ideas? > > Thanks and regards, > saurabh > > > > ------------------------------------------------------- > Bringing you mounds of caffeinated joy > >>> http://thinkgeek.com/sf <<< > > _______________________________________________ > sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive http://www.mail-archive.com/[email protected]/ > ------------------------------------------------------- Bringing you mounds of caffeinated joy >>> http://thinkgeek.com/sf <<< _______________________________________________ sub/unsub https://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive http://www.mail-archive.com/[email protected]/
