view release on metacpan or  search on metacpan

lib/Myco/Admin.pod  view on Meta::CPAN

  mkdir /var/db/pgsql
  mkdir /var/db/pgsql/data
  chown pgsql /var/db/pgsql/data

and set the right permissions:

  chmod -R 0700 /var/db/pgsql/data

=item *

Initialize the PostgreSQL database. Be sure to pass the directory you just
created to the C<-D> command.

  su - pgsql -c "initdb -D /var/db/pgsql/data"

=item *

Start the PostgreSQL "postmaster". On FreeBSD this looks like so:

  /usr/local/etc/rc.d/pgsql.sh start

If you start postgres this way, you'll need to set the C<PGDATA>
environment variable first:

  su - pgsql -c "export PGDATA=/var/db/pgsql/data"

=item *

Now create a postgres user for yourself.

  su - pgsql -c "createuser someuser"

Be sure to enter the postrges username, password and database name into C<myco.conf>. The Makefile.PL script included with myco will do this for you.
    
=back


And now PostgreSQL is ready to go!

Note that only a little work is required to make myco compatible with MySQL
and other Tangram-supported RDBMSs - notably changing PostreSQL-specific SQL
directives passed to Tangram in various Entity attribute specifications. Formal
myco releases may depend on the transaction support embedded in postgres and
will not provide this support by default.

=head2 Myco.pm and required Perl Modules

There are quite a few 3rd-party Perl modules required by the myco framework
(see L<"PACKAGES"> above for a list). The easiest way to install them all,
together with all myco framework modules (Myco.pm et al), is to let CPAN.pm
take care of the process:

  perl -MCPAN -e 'install Myco'

If you have never before used the CPAN module then you will be prompted to
go through configuration process. If your computer sits behind a firewall,
setting the environment variable FTP_PASSIVE beforehand can be helpful:

 export FTP_PASSIVE=yes   # sh, bash
 setenv FTP_PASSIVE yes   # csh

See L<CPAN> for more information.

Alternatively, the process may be performed "by hand."  Manual installation of
each of the required modules follows the usual perl module installation process:

=over 4

=item *

Download the package sources.

=item *

Gunzip and untar the sources.

=item *

Change to the source directory and execute these commands:

  perl Makefile.PL
  make
  make test
  make install

=back

=head2 Deploying the Database

Now you should myco-deploy the database, assuming you were successful in installing
PostgreSQL. The CPAN installation method will have already done this for you, if you answered "yes" to the "Do you plan to run the test suite?" question.

=over

=item *

Set the MYCO_ROOT environment variable to point to the directory (usually
'myco' or 'myco/framework') that contains the 'classes', 'test', 'bin', and
'conf' directories. Alternatively you can set it temporarily on the command
line.

=item *

Change to the 'bin' directory, in the source directory, and run the 'myco-deploy'
script:

  cd bin
  perl myco-deploy

or, in csh:

  env MYCO_ROOT=~/myco perl myco-deploy

=back

Your database should now be populated. Try running 'psql' or your favourite
PostgreSQL client to inspect that its OK.

If you run into problems, send a note with as much information as possible to
myco-users@lists.sourceforge.net