[flymine-dev] Postgres on Gollum

[Matthew Wakeling]

I have set up an alternative location for databases to be stored on Gollum
(for performance reasons).

Until recently, there were three separate /export/db directories, each
mounted on a separate RAID system, each with a database data directory.
These were:

/export/db1/postgres - OLD postgres 7.3 on Gollum (now defunct)
/export/db2/postgres - NEW postgres 7.4 on Gollum
/export/db3/postgres - postgres 7.4 on Smeagol

Now, it is possible to tell postgres to put database data in a different
location with gollum, when creating a database with "createdb". This is
good, because it allows us to have gollum accessing several independent
RAID arrays, allowing independent database performance.

The new location I have set up is:

/export/db1/gollum_second_location - NEW postgres 7.4 on Gollum

To create a new database in the alternative location, add "-D PGDATA2" to
the "createdb" command, like so:

createdb -D PGDATA2 -U flymine -h gollum chado-src-items

As such, I have placed chado-src-items on Gollum in the alternative
location.

Francois: you may wish to look at the change I made to
/sbin/init.d/postgresql on Gollum, and possibly do this properly (ie allow
both Smeagol and Gollum to access all three/four RAID arrays).

Matthew

-- 
Psychotics are consistently inconsistent. The essence of sanity is to
be inconsistently inconsistent.