Re: new to sql-ledger and postgresql.

[Gianluca C. <te...@li...>]

You can also modify the postgresql.conf file:

tcpip_socket = true

You have also to grant access to the clients, modifying the file
pg_hba.conf, that is in
$PGDATA directory (/usr/local/pgsql/data in my case).
It is self explanatory, for example I introduced this line in it

host all 192.168.0.0 255.255.0.0 trust

supposing that clients connections arrive from 192.168.0.0 network.

HIH.



Bye,

Gianluca

----- Original Message -----
From: "Olaf Faaland" <ofa...@at...>
To: "klavs klavsen" <kl...@vs...>; "SQL-Ledger mailinglist"
<sql...@li...>
Sent: Thursday, March 21, 2002 4:51 PM
Subject: Re: new to sql-ledger and postgresql.


> Klav,
>
> See the snippet below from the Postgres manual.  Perhaps sql-ledger is
> trying to connect via TCP, but Postgres is only accepting connections via
> UDP (the Postgres default, at least at one time).
>
> -Olaf
>
> =======================
>
> 3.3.2. Client Connection Problems
> Although the error conditions possible on the client side are quite varied
> and application-dependent, a few of them might be directly related to how
> the server was started up. Conditions other than those shown below should
be
> documented with the respective client application.
>
>
> psql: could not connect to server: Connection refused
>         Is the server running on host server.joe.com and accepting
>         TCP/IP connections on port 5432?
> This is the generic "I couldn't find a server to talk to" failure. It
looks
> like the above when TCP/IP communication is attempted. A common mistake is
> to forget the -i option to allow the postmaster to accept TCP/IP
> connections.
>
> Alternatively, you'll get this when attempting Unix-socket communication
to
> a local postmaster:
>
> psql: could not connect to server: Connection refused
>         Is the server running locally and accepting
>         connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
>
> ----- Original Message -----
> From: "klavs klavsen" <kl...@vs...>
> To: "SQL-Ledger mailinglist" <sql...@li...>
> Sent: Thursday, March 21, 2002 5:53 AM
> Subject: new to sql-ledger and postgresql.
>
>
>
>
>