Re: [HACKERS] Installation procedure wishes

From: Dmitry Samersoff <dms(at)wplus(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Installation procedure wishes
Date: 1999-06-18 06:55:09
Message-ID: XFMail.990618105509.dms@wplus.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 17-Jun-99 Tom Lane wrote:
> Dmitry Samersoff <dms(at)wplus(dot)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(at)wplus(dot)net, ICQ:3161705
http://devnull.wplus.net
* There will come soft rains ...

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Jan Wieck 1999-06-18 08:12:14 Re: [HACKERS] Installation procedure wishes
Previous Message Vadim Mikheev 1999-06-18 06:28:30 Re: [HACKERS] Re: Apparent bug in _make_subplan