Postgresql and SuSE7.0 question about $PATH
Hi: Anyone using postgresql on SuSE7.0? Can you clear up some confusion here? I am following the PostgreSQL 7.1 Documentation for install, and it recommends that $PATH be set to /usr/local/pgsql/bin. Looks like SuSE changed that to /usr/bin, along with some other changes, like /usr/local/pgsql/data is actually /var/lib/pgsql/data [I guess]. Any help appreciated. The documentation for PostgreSQL 7.1 is at: http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/installation .html. How about it, SuSE support? What gives? Any help for this humble newbie? Thanks, Tom
On Fri, 20 Apr 2001, Tom Poe wrote:
Hi: Anyone using postgresql on SuSE7.0? Can you clear up some confusion here?
I am following the PostgreSQL 7.1 Documentation for install, and it recommends that $PATH be set to /usr/local/pgsql/bin. Looks like SuSE changed that to /usr/bin, along with some other changes, like /usr/local/pgsql/data is actually /var/lib/pgsql/data [I guess]. Any help appreciated. The documentation for PostgreSQL 7.1 is at: http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/installation .html.
How about it, SuSE support? What gives? Any help for this humble newbie? Thanks, Tom
SuSE Postgres installation differs from the default PostgreSQL installation completely when it comes to the paths. I recommend backing up current PostgreSQL data, if any, then removing PostgreSQL installation with Yast and then compiling and installing PostgreSQL from sources. It's not that difficult, really, and pg comes with decent INSTALL file to guide through the process. --jq
Jyry Kuukkanen wrote:
On Fri, 20 Apr 2001, Tom Poe wrote:
Hi: Anyone using postgresql on SuSE7.0? Can you clear up some confusion here?
I am following the PostgreSQL 7.1 Documentation for install, and it recommends that $PATH be set to /usr/local/pgsql/bin. Looks like SuSE changed that to /usr/bin, along with some other changes, like /usr/local/pgsql/data is actually /var/lib/pgsql/data [I guess]. Any help appreciated. The documentation for PostgreSQL 7.1 is at: http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/installation .html.
How about it, SuSE support? What gives? Any help for this humble newbie? Thanks, Tom
SuSE Postgres installation differs from the default PostgreSQL installation completely when it comes to the paths.
... Yes, the same applies to Apache and various other things. I used to fret about this too, but the reason for it is adherence to LSB guidelines on where things should be located. One of the things, I think, is that they try to keep stuff that should be writable at runtime in /var or /etc while /usr (except /usr/local) should be theoretically mountable read-only, potentially useful if running off a network - as opposed to running attached to a network. On the other hand, it's usual for the default installation of applications from original source is in /usr/local (ie: /usr/local/apache, /usr/local/pgsql or other things which put their files into /usr/local/bin, /usr/local/lib et al). This is, I think, so that when you compile your own stuff, it doesn't get mixed up with the stuff installed as part of the distribution. It doesn't seem very consistent though. There seem to be all sorts of exception which means I'm not at all sure of this pattern. Why, for instance, are some things in /usr and some in /opt? Why is the anonymous ftp directory defaulting to /usr/local/ftp? There's probably some explanation of the rationale somewhere, but I haven't read it. :-) If it's any consolation, SuSE seem to be saner about all this than most if not all other Linux distributions or other Unixes for that matter. -- Rachel
>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 4/20/01, 3:21:45 AM, Rachel Greenham
It doesn't seem very consistent though. There seem to be all sorts of exception which means I'm not at all sure of this pattern. Why, for instance, are some things in /usr and some in /opt? Why is the anonymous ftp directory defaulting to /usr/local/ftp?
There's probably some explanation of the rationale somewhere, but I haven't read it. :-)
If it's any consolation, SuSE seem to be saner about all this than most if not all other Linux distributions or other Unixes for that matter.
-- Rachel
Hi, Rachel: You and Jyry have provided some excellent advice about SuSE and the quality of their work. Thanks, much. Tom
>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
On 4/20/01, 2:15:56 AM, Jyry Kuukkanen
SuSE Postgres installation differs from the default PostgreSQL installation completely when it comes to the paths.
I recommend backing up current PostgreSQL data, if any, then removing PostgreSQL installation with Yast and then compiling and installing PostgreSQL from sources. It's not that difficult, really, and pg comes with decent INSTALL file to guide through the process.
--jq
Hi Jyry: Hey, thanks! Excellent advice, and easily convinced, I am. I have used more than one authored resource from SuSE company authors, e.g., The Linux Server, and the collaborative work on the Redbook Series at the IBM site for SuSE configuration for the X and E Series IBM servers. I am going to do what you suggest, and thanks again. Tom
participants (3)
-
Jyry Kuukkanen -
Rachel Greenham -
Tom Poe