Re: Connecting via perl gives "root" does not exist

on 4/22/01 11:24 PM, Randall Perry at rgp(at)systame(dot)com wrote:

> I'm new at PostgreSQL.
>
> So far, succesfully compiled & installed it. Created a db, created a table,
> and 'copied' tab-delim data into it.
>
> Also downloaded and installed Perl Pg mod (that was a pain; had to sen ENV
> variables, and had to force install because of the "root" does not exist
> error in make test).
>
> Here's the example script from the Pg readme (with my own db info):
>
> use Pg;
> $conn = Pg::connectdb("dbname=tasbill");
> $res = $conn->exec("SELECT * from cust");
> while (@row = $res->fetchrow) {
> print join(" ", @row);
> }
>
>
> Works fine if I log in as 'postgres' before executing script, but fails if
> logged in as any other user. I'm using the default pg_hba.conf file, which I
> thought would allow local users to connect to any database:
>
> local all trust
> host all 127.0.0.1 255.255.255.255 trust
>
> What am I missing??
>
>

Never mind. Figured out how to CREATE USER and GRANT.

--
Randy Perry
sysTame
Mac Consulting/Sales

phn 561.589.6449
mobile email help(at)systame(dot)com