Postgres

[Sparkes, David]

Hi again,

Ok... well I have created the tables using
/etc/raddb/sql/postgresql/schema.sql and populated the tables manually.

However no postgresql.conf file exists in either
/etc/raddb/sql/postgresql or /etc/raddb/postgresql.  Have I missed a
package that would include this or should I just create it from scratch?
Looking at the examples that I've found, it seems to be a fairly
straightforward file to understand, if large.  If I'd known that the
table name and SQL queries were defined in postgresql.conf, I wouldn't
have bothered to recreate the tables according to the schema. ;)

For the record, all of the configuration files are in
/etc/raddb/postgresql in this install.

Regards,

Dave


-----Original Message-----
From:
freeradius-users-bounces+david.sparkes=keymile.com at lists.freeradius.org
[mailto:freeradius-users-bounces+david.sparkes=keymile.com at lists.freerad
ius.org] On Behalf Of John Dennis
Sent: Thursday, October 15, 2009 2:35 PM
To: FreeRadius users mailing list
Subject: Re: Postgres

On 10/15/2009 07:01 AM, Alan DeKok wrote:
> Sparkes, David wrote:
>> I was working through the example to set up PostGres; I just was
thrown
>> when I tried to set up the database ("Setting up the RADIUS database"
>> section), as I reached these lines:
>>
>> cd /usr/share/doc/packages/freeradius/doc/examples/
>> psql -U radius radius<  postgresql.sql
>
>    See raddb/sql/postgresql/.  Everything for postgres is there.

Just for clarity, using the Red Hat packages (sice the OP did state this

is RHEL) that would be /etc/raddb/sql/postgresql and requires the 
freeradius-postgresql subpackage to be installed.

-- 
John Dennis <jdennis at redhat.com>

Looking to carve out IT costs?
www.redhat.com/carveoutcosts/
-
List info/subscribe/unsubscribe? See
http://www.freeradius.org/list/users.html