Postgres file locations

["Guy R. Thomas" <gthomas@native-ed.bc.ca>]

Hi folks,

I would like some help with deciding on a location for the files  
associated with the Postgres package that I am putting together.  I have  
a few ideas that might work, but as I have limited experience with the  
way other big DBMS's are configured I would like some other ideas.

In the original sources the entire tree lives under /usr/local/postgres.  
 That is the source code, the binaries, the shared libraries, the  
include files, and the databases all install there.  There is a special  
user, (the DBA usually postgres,  uid 6), that has /usr/local/postgres as  
the home directory.

I suggest the following

/usr/lib/                    shared library
/usr/include/postgres/       include files
/var/postgres/               database files
/usr/bin/                    postgres binaries
/home/<dba>/                 source tree

Does this seem reasonable?  What major gaff have I made?  Am I using  
/var correctly?  There are about 15 binaries that get installed in  
/usr/bin.  Is that too many?

In the binary package  I plan to prompt the configurer for a username to  
have as the DBA.  Then the package will create that user if they dont  
already exist.  Does that seem wise?

Thanks for the input.
---
Guy R. Thomas                                 Native Education Centre
Library Coordinator                           285 East Fifth Avenue
gthomas@native-ed.bc.ca                       Vancouver B. C.
V:(604) 873-3772 x.311 --- F:(604) 873-9152   V5T 1H2