bash-2.05b# su pgsql
$ cd ~
$ mv data/*.conf .
$ rm -rf data
$ initdb -D /usr/local/pgsql/data/ -E ""
The files belonging to this database system will be owned by user "pgsql".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /usr/local/pgsql/data/... ok
creating directory /usr/local/pgsql/data//base... ok
creating directory /usr/local/pgsql/data//global... ok
creating directory /usr/local/pgsql/data//pg_xlog... ok
creating directory /usr/local/pgsql/data//pg_clog... ok
selecting default max_connections... 10
selecting default shared_buffers... 1000
creating configuration files... ok
creating template1 database in /usr/local/pgsql/data//base/1... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
creating information schema... ok
vacuuming database template1... ok
copying template1 to template0... ok
Success. You can now start the database server using:
/usr/local/bin/postmaster -D /usr/local/pgsql/data/
or
/usr/local/bin/pg_ctl -D /usr/local/pgsql/data/ -l logfile start
$ mv *.conf data/
$ /usr/local/bin/pg_ctl -D /usr/local/pgsql/data/ -l logfile start
postmaster successfully started
$ sockstat -4l
USER COMMAND PID FD PROTO LOCAL ADDRESS FOREIGN ADDRESS
pgsql postgres 32499 4 tcp4 *:5432 *:*
[... Boring other services ...]
$ bash-2.05b# cd /usr/local/www/OpenNMS/
bash-2.05b# ./bin/install -disU
==============================================================================
OpenNMS Installer Version $Id: Installer.java 3056 2006-03-26 19:39:16Z djgregor $
==============================================================================
Configures PostgreSQL tables, users, and other miscellaneous settings.
Exception in thread "main" org.postgresql.util.PSQLException: The connection attempt failed because Exception: java.net.SocketException: Invalid argument
Stack Trace:
The rest is the same as the previous one :(