Forum OpenACS Q&A: installation of postgres 7.2.1 for oacs 4.5

Collapse
1: installation of postgres 7.2.1 for oacs 4.5
Posted by edwin ho on 06/24/02 11:27 PM
I am learning to install an OACS 4.5 installation and is wondering
where do I install pgsql?  I have /var/db that i originally wanted to
install pgsql but after some reading, it is recommended that I install
into /usr/local/ instead.  If I do install into /usr/local/, can I
tell pg to use /var/db to store the actual db? or does it have to be
where the program is running from? (/usr/local/)  btw, this is on a
RH7.3 box.

thanks,
Edwin

Collapse
2: Response to installation of postgres 7.2.1 for oacs 4.5 (response to 1)
Posted by Jonathan Ellis on 06/24/02 11:40 PM
you can symlink the pgdata dir to anywhere you like.  unfortunately there's no "high level" way to do this.
Collapse
3: Response to installation of postgres 7.2.1 for oacs 4.5 (response to 1)
Posted by edwin ho on 06/24/02 11:51 PM
so I can't specify pg to store the db file on another location? would it better if I just installed pg into /var/db or just link it like you suggested?
Collapse
4: Response to installation of postgres 7.2.1 for oacs 4.5 (response to 1)
Posted by Neophytos Demetriou on 06/25/02 12:00 AM
Edwin you can do it with initdb -- just change the -D flag value to whatever directory you wish to have your data. 

/usr/local/pgsql/bin/initdb  -D /usr/local/pgsql/data
Collapse
5: Response to installation of postgres 7.2.1 for oacs 4.5 (response to 1)
Posted by edwin ho on 06/25/02 12:03 AM
Thanks Neophytos,

one more question. Is it better to install programs into /usr/local/(program name) or just install into /usr/local/ ?

Collapse
6: Response to installation of postgres 7.2.1 for oacs 4.5 (response to 1)
Posted by Jonathan Ellis on 06/25/02 05:28 PM
oops.  yeah, sorry for the misinformation.  but if you want to move *some* of the data structures (say, the WAL) you have to symlink.