
Now that PostgreSQL is installed, you should read the documentation and
implementation guides. These can be found at:

		http://www.PostgreSQL.org/docs

You may wish to subscribe to the PostgreSQL user-support mailing list.
Send an e-mail to pgsql-questions-request@postgresql.org with the
text "subscribe" in the message body.

If you built PostgreSQL with TCL/TK support, you can use the pgaccess
utility to get a TCL/TK based database frontend for database
operations. You do NOT need to install the pgaccess port separately.

If you built in the TCL support, you can load the Pg package into your
TCL scripts as easily as ``package require Pgtcl''.

If you built with Java support, add
/usr/local/share/java/classes/postgresql.jar to your classpath.

If you have many tables and many clients running, consider raising
kern.maxfiles using sysctl(8).

======================================================================

      * IMPORTANT UPGRADE NOTICE * IMPORTANT UPGRADE NOTICE *

The PostgreSQL port now obeys hier(7) by default, which means that it
installs into:

/usr/local/bin
/usr/local/lib
/usr/local/include/pgsql

You *must* move away your old installation from users' and
ldconfig(8)'s PATHs. If you rather install using the old-fashion
layout, cancel now and build the port with "make -DWITH_OLD_LAYOUT".

The pgsql user's home dir is /usr/local/pgsql by default, but can be
changed with for example chpass(1). Datadir defaults to ~pgsql/data,
but can be changed by modifying the ~pgsql/.profile script.

As always, you *must* dump existing databases before stopping and
removing your old postgresql, as part of the update.  This is *NOT*
done by this port!

======================================================================

To initialize the database, you should run initdb as the "pgsql" user.

Example:

  su -l pgsql -c initdb

You can then start PostgreSQL by running:

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

For postmaster settings, see ~pgsql/data/postmaster.conf
======================================================================
