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

> 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??

Either one or both of following:

1. Use proper user name in connectdb() call

2. Run 'createuser <username>' on the server side, where <username>
belongs to the user running the client script.

pg_hba.conf decides what hosts can connect and *how* to authenticate
users names. It does not control user access. That's what createuser
and GRANT queries are for.

--Gene