Re: PG on Suse - Mailing list pgsql-admin

From Jean-Michel Chabanne
Subject Re: PG on Suse
Date
Msg-id 9qnen8$126g$1@news.tht.net
Whole thread Raw
In response to PG on Suse  (Fabio Serra <faser@faser.net>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Lenny Mastrototaro
Date:
Subject: Re: Freeing Connections
Next
From: "James Kelty"
Date:
Subject: Rename of a Table Column