Postgres Pro
Downloads
Home   >   mailing lists

Thread: perl access

perl access

From
Tom Allison
Date:
I'm stuck on something stupid.

I'm trying to use perl to open up a database handle and I can't find the
right database dsn string.

my $data_source = "dbi:Pg:mydatabase";
my $username = "mydatebasereader";
my $auth = "secret";

my $dbh = DBI->connect($data_source, $username, $auth);



DBI connect('postfix','postfix',...) failed: missing "=" after "postfix"
in connection info string at /home/tallison/bin/perl.pl line 21

I've tried variations on the $data_source but I'm afraid I'm working on
a hit-n-miss process.

Can someone point me?

Re: perl access

From
jseymour@linxnet.com (Jim Seymour)
Date:
Tom Allison <tallison@tacocat.net> wrote:
>
> I'm stuck on something stupid.
>
> I'm trying to use perl to open up a database handle and I can't find the
> right database dsn string.
>
> my $data_source = "dbi:Pg:mydatabase";
> my $username = "mydatebasereader";
> my $auth = "secret";
>
> my $dbh = DBI->connect($data_source, $username, $auth);
>
>
>
> DBI connect('postfix','postfix',...) failed: missing "=" after "postfix"
> in connection info string at /home/tallison/bin/perl.pl line 21
>
> I've tried variations on the $data_source but I'm afraid I'm working on
> a hit-n-miss process.
>
> Can someone point me?

Like this:

my $data_source = "dbi:Pg:dbname=mydatabase";
                          ^^^^^^^

Jim

Re: perl access

From
Tom Allison
Date:
Jim Seymour wrote:
>
> Like this:
>
> my $data_source = "dbi:Pg:dbname=mydatabase";
>                           ^^^^^^^
>

thank you very much.

Now if I could just authenticate correctly...