view release on metacpan or  search on metacpan

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

  sh Configure
  make
  make test
  make install

=back

=head2 PostgreSQL

PostgreSQL is an integral part of myco: it's where all of your objects are
stored! Its installation is pretty straight-forward and typical, but it
requires a number of extra steps that one might not expect.

If you're using Redhat Linux you may already have Postgres installed. If so,
all you need to do to get it ready for use with myco is edit your
postgresql.conf file (run C<locate postgresql.conf> or C<find / -name postgresql.conf -print> to find it) and turn on
the tcpip_socket option:

  tcpip_socket = true

Otherwise, here are the installation details:

=over 4

=item *

Download the PostgreSQL source tarball from www.postgresql.org.

=item *

Gunzip and untar the sources.

=item *

Change into the source directory and read the INSTALL file to see if you need
to use any Configure commands.

=item *

Install PostgreSQL:

  ./configure
  make
  make install

=item *

If the PostgreSQL installation did not create a user named "pgsql" for you,
create it now. This is the user that will start the PostgreSQL server and own
the log and data files. Certain platforms (i.e. various Linux distributions) may create another user to own and run the server process. On FreeBSD (our favourite platform), "pgsql" is the user. The following instructions were written with this in min...

=item *

Now make a directory in which you want to keep your PostgreSQL databases,
including the myco database. Make the "pgsql" user the owner of that
directory.

  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.