Re: [HACKERS] Installation procedure wishes

On 17-Jun-99 Tom Lane wrote:
> Dmitry Samersoff <dms@wplus.net> writes:
>> 1. My standard way to install pgsql:
>>   make
>>   su
>>   useradd postgres
>> ****
>>   mkdir ~postgres
>>   make install
>>   chown -R postgres ~postgres 
> 
>> Is it possible to include last three commands into installation procedure?

I wrote this letter because last month I had to install/upgrade
postgress over 20 times. All this questions is not significant for 
single instalation, but prove a task if I need installing postgres
every day.

> 
> If you followed the installation instructions (ie, run "make install" as
> the postgres user), you wouldn't need the chown step.  The reason that
> making the toplevel installation directory isn't part of what "make
> install" does is that it's typically located somewhere that requires
> root permission to make the directory --- but you only need to do that ^^^^^^^^^^^^^^^
Yes! IMHO, If root privilege required (in most case) at least once,
it would be nice to make top-level directory and all other
by install.

(It's step back to discussion fired some monthes ago) 

> once, it doesn't have to be done over each time you reinstall.
> 
>> 2. The most often PGDATA is ~postgres/data 
>>               and PGLIB  is ~postgres/lib
>> Is it possible to use this as default if environment not set?
> 
> Not ~postgres necessarily, but whatever the --prefix set by configure
> is.  I kinda thought these defaults were compiled in already?  If not,
> they probably should be.

AFAIK, It's not compiled already in current 6.5.
Other side, using home directory of user "postgres" provide a simple and
standard way to control postgres data and lib locations. 

> 
>> 3. Next step is adding plpgsql into database template1 (or patching creatdb
>> script) to add plpgsql every time as I create new db
> 
> That's a one-command thing now, so I'm not seeing why it's harder to issue
> the command than type a configure option ...

I still need remember to run this command for template1 or do it every time 
when I creating db. 

Configure options allow me to add it to internal-used build script
and don\'t keep it in mind.

---
Dmitry Samersoff, dms@wplus.net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...