The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

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.