Name

bric_pgimport - Builds a Bricolage Database

Synopsis

bric_pgimport [options]

Description

This is a developer program. Users should make and make install to build their Bricolage installations and database. Note that it only works with PostgreSQL 7.3 and later.

Options

-P

The location of the psql program. Defaults to simply 'psql' if undefined. This should work if psql is in your path.

-w

The directory with the Subversion SQL files. Defaults to lib subdirectory of BRICOLAGE_ROOT environment variable, which itself defaults to /usr/local/bricolage.

-u

Database user login. Defaults to PGUSER environment variable.

-p

Database user password. Defaults to PGPASSWORD environment variable.

-d

Database name. Defaults to PGDATABASE environment variable.

-H

PostgreSQL server host name. Will use PGHOST environment variable or else PostgreSQL assumes that it's connecting via local Unix sockets.

-o

PostgreSQL server port number. Will use PGPORT environment variable or else PostgreSQL assumes that it's connecting via local Unix sockets.

-c

Create the database first.

-r

Drop and recreate the exiting database (assumes -c).

-m

Make a new user. Pass in the user name and password separated by a colon. Permissions will be granted to this user to access the new database (assumes -g for this user).

-g

User name to which permissions should be granted on the new database.

-t

Deprecated.

-h

Print this help message.

-q

Quiet mode.

Authors

Garth Web <garth@perijove.com>

David Wheeler <david@kineticode.net>

See Also

Bric::Admin