----- Original Message -----
From: "John Gehman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
> Postgres 6.5.3-6, DBI 1.18, and trying to
> build DBD-Pg-1.00. I've got all the postgres RPMs installed off of the
> disk except for jdbc, python, and tcl (which I don't expect to need),
> and DBI appeared to build just fine.
ack...the postgres 6.5.3 RPMs? 6.5.3 is really buggy, you should be using
7.1. It's also really old, although AFAIK the client libraries have not
changed since 6.5.3, I am not 100% sure DBI 1.0 will work with it. Upgrate
to 7.1 or at least 7.0.
> In probing around for the problem, especially the suggestion in the README
> file, I find that the libraries are found just fine, but I have no
> pg_hga.conf file anywhere, nor anything beginning with "template1".
>
> Were these files supposed to come with one of the postgres RPMs? Or am I
> missing something else?
You have to do an initdb. This initalizes postgres and creates the tempate
database. To do this using the RPMs is simple, start the postgres server
using
/etc/rc.d/init.d/postgresql start
and it will automatically detect that it is the first time postgres is being
run, and do the initdb for you. You have to have the postgres server
running anyways to successfully run the test. Also, you have to run the
test as the user "postgres", not "root", because postgres does not allow
connections from root for securtity reasons.
At least, this is using postgres 7.0/7.1. I've never used 6.5.3, so maybe
someone else can say if the procedure for that one is different.
Also - to check whether the tempalte db is there, use
psql -U postgres template1
and see if it connects.
-Mike
