Thread: PG on Suse

PG on Suse

From
Fabio Serra
Date:
Hi all,
I'm not a Linux Guru and I'm trying to install PG 7.1.3 on Suse 7.2.
Unfortunately SuSe  has not prepared a packet yet and the last Suse version
is 7.0.3.
In any case, I have some questions to do a good job.

1) Is it better to install from source or from SRPM ?
2) Where have I to put the binaries and data ?
I know the default are: /usr/local/pgsql/bin/  and /usr/local/pgsql/data/
but SUSE use  /usr/bin/  and /var/lib/pgsql/data.
3) Can I make a simple ./configure or is better to use any command line
options?
4) To start postgres at system startup can I mantain the postgres Suse
script for the 7.0.3. version or I have to make a script by myself?
5) If now I install PG from source, do I need to reinstall PG when Suse
releases the upgrade ?
Thanks in advance for your help.
--------------------------------------------------
FABIO SERRA - faser(at)faser.net
PGP available
--------------------------------------------------



Re: PG on Suse

From
Stefan Huber
Date:
>1) Is it better to install from source or from SRPM ?

Compile manually. reason: up to date.

>2) Where have I to put the binaries and data ?
>I know the default are: /usr/local/pgsql/bin/  and /usr/local/pgsql/data/
>but SUSE use  /usr/bin/  and /var/lib/pgsql/data.


just leave the defaults of the Postgresql-tarball (=/usr/local/pgsql/)

>3) Can I make a simple ./configure or is better to use any command line
>options?

If you don't need native Perl or whateve rinterfaces, SSL, ... you can run
a simple ./configure (/usr/local/pgsql/ will be the destination)

>4) To start postgres at system startup can I mantain the postgres Suse
>script for the 7.0.3. version or I have to make a script by myself?

Have a look at contrib/start-scripts/ in the source-tarball.

>5) If now I install PG from source, do I need to reinstall PG when Suse
>releases the upgrade ?
>Thanks in advance for your help.

if you don't have the old SuSE package installed, just don't do anything.
Keep upgrading manually (ie: compile, if you find an upgrade necessary)

Stefan

--
Wohlstand ist, wenn die Menschen mehr Uhren haben, als Zeit.


Re: PG on Suse

From
Jean-Michel Chabanne
Date:
Fabio Serra wrote:

> Hi all,
> I'm not a Linux Guru and I'm trying to install PG 7.1.3 on Suse 7.2.
> Unfortunately SuSe  has not prepared a packet yet and the last Suse
> version is 7.0.3.
> In any case, I have some questions to do a good job.
>
> 1) Is it better to install from source or from SRPM ?

Why a SRPM when one can get a tarball on an PostgreSQL mirror site?

> 2) Where have I to put the binaries and data ?
> I know the default are: /usr/local/pgsql/bin/  and /usr/local/pgsql/data/
> but SUSE use  /usr/bin/  and /var/lib/pgsql/data.

With a source tarball, you may put binaries and data where you want. On my
Linux box, running SuSE 7.2 with PostgreSQL 7.1.3, I put PostgreSQL in
/usr/local/pgsql, and data in /data/pgsql. /data is a big partition with
only data for several packages. But you can choose to install binaries an
data in a same directory of your choice.

> 3) Can I make a simple ./configure or is better to use any command line
> options?

To know all available options : ./configure -help | less
To compile, I used : ./configure --enable-locale --enable-odbc --with-CXX
--with-gnu-ld --enable-syslog
but it is only an example;

> 4) To start postgres at system startup can I mantain the postgres Suse
> script for the 7.0.3. version or I have to make a script by myself?
> 5) If now I install PG from source, do I need to reinstall PG when Suse
> releases the upgrade ?

If PostgreSQL is not installed from a SuSE RPM, an upgrade will not change
a source installation.

> Thanks in advance for your help.
> --------------------------------------------------
> FABIO SERRA - faser(at)faser.net
> PGP available
> --------------------------------------------------
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>

--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux