Re: Upgrade or install 7.2.2 on SuSE 8.0

On Wed, 2002-09-11 at 22:48, John Dougherty wrote:
> I have been trying to get postgresql version 7.2.2 up and running properly on
> a SuSE 8.0 machine. SuSE comes with a 7.1.* version, which installs into
> /var/lib/pgsql in part, but distributes the include, lib, and other files in
> a number of other directories. I decided to try simply using the defaults as
> they come in the source file for 7.2.*. I have tried to edit the conf files

You need to make sure that all the 7.1 files are removed, in case they
get selected in preference to your own installation. The source file
defaults to /usr/local/pgsql/... whereas the SuSE distribution will use
/usr/...

> and other material so that they system works as it did prior to the upgrade,
> however the startup process, invoking "/etc/init.d/postgresql start" now
> results in a "failed" message and the statement that "/usr/local/pgsql cannot
> be opened, it is a directory." I edited the postgres user profile to match
> the present setup, but this seems to have had no effect. Can someone suggest
> the basic steps? Possibly they can point to how to comply with LSB when
> configuring and compiling 7.2.

As a local administrator, the LSB asks you to put your stuff in
/usr/local, so taking the PostgreSQL source's defaults is fine.

Your /etc/init.d/postgresql should at least operate on start and stop
and should invoke pg_ctl to do so. It should first set and export
PGDATA, PGLIB and PATH (and maybe PGPORT). PGDATA would typically be
/usr/local/pgsql/data:

PGDATA=/usr/local/pgsql/data
PGLIB=/usr/local/pgsql/lib
PGPORT=5432
PATH=$PATH:/usr/local/pgsql/bin
export PGDATA PGLIB PGPATH PGPORT

Users should set and export PGDATA, PGLIB, PGPORT and PATH in their
login profiles, which you can do (typically) in /etc/profile,
~/.bash_profile, ~/.login, ~/.xsession or ~/.xinitrc according to how
user sessions are started.

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"Let the wicked forsake his way, and the unrighteous
man his thoughts; and let him return unto the LORD,
and He will have mercy upon him; and to our God, for
he will abundantly pardon." Isaiah 55:7