From: Randall Perry <rgp@systame.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: Connecting via perl gives "root" does not exist
Date: Mon, 23 Apr 2001 00:36:52 -0400
Message-ID: <B70929A4.A19D%rgp@systame.com> (raw)
In-Reply-To: <B70918AA.A190%rgp@systame.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: rgp@systame.com
Subject: Re: Connecting via perl gives "root" does not exist
In-Reply-To: <B70929A4.A19D%rgp@systame.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox