Wiki::Toolkit::Setup::Pg - Set up tables for a Wiki::Toolkit store in a Postgres database.

Alternative Calling Syntax

       As requested by Podmaster.  Instead of passing arguments to the methods as

         ($dbname, $dbuser, $dbpass, $dbhost)

       you can pass them as

         ( { dbname => $dbname,
             dbuser => $dbuser,
             dbpass => $dbpass,
             dbhost => $dbhost
           }
         )

       or indeed as

         ( { dbh => $dbh } )

       Note that's a hashref, not a hash.

Author

       Kake Pugh (kake@earth.li).

Copyright

            Copyright (C) 2002-2004 Kake Pugh.  All Rights Reserved.
            Copyright (C) 2006-2008 the Wiki::Toolkit team. All Rights Reserved.

       This module is free software; you can redistribute it and/or modify it  under  the  same  terms  as  Perl
       itself.

Description

       Set up a Postgres database for use as a Wiki::Toolkit store.

Functions

setup
use Wiki::Toolkit::Setup::Pg;
Wiki::Toolkit::Setup::Pg::setup($dbname, $dbuser, $dbpass, $dbhost);

Wiki::Toolkit::Setup::Pg::setup( $dbh );

You can either provide an active database handle $dbh or connection parameters.

If you provide connection parameters the following arguments are mandatory -- the database name, the
username and the password. The username must be able to create and drop tables in the database.

The $dbhost argument is optional -- omit it if the database is local.

NOTE: If a table that the module wants to create already exists, "setup" will leave it alone. This
means that you can safely run this on an existing Wiki::Toolkit database to bring the schema up to
date with the current Wiki::Toolkit version. If you wish to completely start again with a fresh
database, run "cleardb" first.

cleardb
use Wiki::Toolkit::Setup::Pg;

# Clear out all Wiki::Toolkit tables from the database.
Wiki::Toolkit::Setup::Pg::cleardb($dbname, $dbuser, $dbpass, $dbhost);

Wiki::Toolkit::Setup::Pg::cleardb( $dbh );

You can either provide an active database handle $dbh or connection parameters.

If you provide connection parameters the following arguments are mandatory -- the database name, the
username and the password. The username must be able to drop tables in the database.

The $dbhost argument is optional -- omit it if the database is local.

Clears out all Wiki::Toolkit store tables from the database. NOTE that this will lose all your data;
you probably only want to use this for testing purposes or if you really screwed up somewhere. Note
also that it doesn't touch any Wiki::Toolkit search backend tables; if you have any of those in the
same or a different database see Wiki::Toolkit::Setup::DBIxFTS or Wiki::Toolkit::Setup::SII,
depending on which search backend you're using.

Name

       Wiki::Toolkit::Setup::Pg - Set up tables for a Wiki::Toolkit store in a Postgres database.

Synopsis

         use Wiki::Toolkit::Setup::Pg;
         Wiki::Toolkit::Setup::Pg::setup($dbname, $dbuser, $dbpass, $dbhost);

       Omit $dbhost if the database is local.