NAME

user-setup-postgres - set up a Postgres storage backend for CGI::Wiki

SYNOPSIS

# Set up or update the storage backend, leaving any existing data intact. # Useful for upgrading from old versions of CGI::Wiki to newer ones with # more backend features.

user-setup-postgres --name mywiki \
                    --user wiki  \
                    --pass wiki

# Clear out any existing data and set up a fresh backend from scratch.

user-setup-postgres --name mywiki \
                    --user wiki  \
                    --pass wiki  \
                    --force-preclear

DESCRIPTION

Takes three mandatory arguments:

name

The database name.

user

The user that connects to the database. It must have permission to create and drop tables in the database.

pass

The user's database password.

and one optional flag:

force-preclear

By default, this script will leave any existing data alone. To force that to be cleared out first, pass the --force-preclear flag.

AUTHOR

Kake Pugh (kake@earth.li).

COPYRIGHT

Copyright (C) 2002 Kake Pugh.  All Rights Reserved.

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

SEE ALSO

CGI::Wiki, CGI::Wiki::Setup::Pg