The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.

NAME

Installation of DBIx::PgLink

PREREQUISITES

  • PostgreSQL 8.2 or later

  • Perl 5.8.6 or later

  • Perl modules

    DBI
    DBD::Pg
    Moose
    MooseX::Method
    Tie::Cache::LRU
    
    DBD driver for remote database

    Moose requires Class::MOP module. Ensure that you have latest Class::MOP version installed, for notable performance boost in 0.49.

  • Superuser account on local PostgreSQL server

    Must logon without password typing, i.e. use 'trust' authentication or store password in .pgpass/pgpass.conf file

BUILDING

Run

perl Makefile.PL
make

(on Windows with Microsoft Visual Studio use 'nmake')

or

perl Build.PL
./Build

TESTING

  • Change t/test.conf for your environment. It's in YAML format.

    First configuration entry named 'TEST' describe local PostgreSQL connection. Test will log on to this server as specified user, drop and create test database and install all database object.

    WARNING: all previous content of database will be lost

    This database also will be used as 'remote' database for testing.

    Other entries are commented by default.

  • Check PostgreSQL account

    Ensure that PostgreSQL owner (operating system account, usually 'postgres') can connect to his own server with specified in t/test.conf credentials. If used .pgpass file, place it to 'postgres' home directory.

  • Change permission on some directories for PostgreSQL owner account

    read permissions for ./blib
    chmod -R o=r,+X blib
    read and write permissions for ./examples
    chmod -R o=rw,+X examples

    Only if you plan testing of XBase or SQLite data sources

  • Run test

    make test

    or

    ./Build test

    Check for errors.

INSTALLING

  • Install Perl module

    Run as root

    make install

    or

    ./Build install
  • Install database objects

    Run

    psql -h <host> -p <port> -U <superuser> -f _install.sql <database>

SEE ALSO

DBIx::PgLink::Manual::Usage, http://pgfoundry.org/projects/dbi-link/

AUTHOR

Alexey Sharafutdinov <alexey.s.v.br@gmail.com>

COPYRIGHT AND LICENSE

Copyright (C) 2007 by Alexey Sharafutdinov

This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself, either Perl version 5.8.8 or, at your option, any later version of Perl 5 you may have available.