Thread: perl-interface: make test

Hello,

     When I installed the perl interface for postgresql, as instructed, the
first two steps (perl Makefile.PL; make) worked well. But when doing
"make test",  it stopped with message

...
not ok 2: 0, 1
FATAL 1:  Database emplate1 does not exist in pg_database
                   ======== rather than template1

Looks like the first char of $dbmain (which is 'template1') has been
striped off. If I placed an arbitrary char before 'template1', which
would be '?template1', then the database template1 could be connected; but
it would still fail at later steps of 'make test'.

    I just find out that I didn't specify '--with-perl' to enable perl
interface at the configuration step when I installed postgresql last May.
Is this responsible for the above problem?  Any shortcut to enable it rather
than re-install it from scratch? The INSTALL file indicates if using
'--with-perl', it requires an installed version of postgreSQL. In that
case, what files/directories should be retained for a rebuild or an update?

    Any advices will be appreciated!

Wuyin Lin
wlin@atmgcm.msrc.sunysb.edu

wlin@atmgcm.msrc.sunysb.Edu writes:
>     I just find out that I didn't specify '--with-perl' to enable perl
> interface at the configuration step when I installed postgresql last May.

"Last May"?  What version are you using?  I suppose it could be 6.3.2 at
latest.

> Is this responsible for the above problem?  Any shortcut to enable it rather
> than re-install it from scratch?

Actually I'd recommend upgrading to 6.4.2; we cleaned up the perl5
module's install process in 6.4 so that you can build it either with
Postgres ("--with-perl") or afterwards.  I've forgotten exactly what
the problems were before, but one or the other method didn't work
quite right...

The 6.4.2 backend is also noticeably more stable than 6.3.2, at least
in my experience.

            regards, tom lane