User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022
Date: Mon, 23 Apr 2001 00:36:52 -0400
Subject: Re: Connecting via perl gives "root" does not exist
From: Randall Perry <rgp@systame.com>
To: <pgsql-interfaces@postgresql.org>
Message-ID: <B70929A4.A19D%rgp@systame.com>
In-Reply-To: <B70918AA.A190%rgp@systame.com>
Mime-version: 1.0
Content-type: text/plain; charset="US-ASCII"
Content-transfer-encoding: 7bit

on 4/22/01 11:24 PM, Randall Perry at rgp@systame.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@systame.com