Postgresql installation with ssh connection.

2009/4/3 dfx <dfx@dfx.it>:

dear Sirs,

The default installation (#>yum install opstresql)suggest the version 8.1
but I would like to install the latest 8.3, so I suppose that I have to
change some file containing yum directive per postgresql.

30 seconds on the postgres website ... ran into this ;}

http://yum.pgsqlrpms.org/

Cheers,
Andrej

dfx wrote:

dear Sirs,

is there on the web a simple guide (for "idiots") to install postgresql
on CentOS 5.2 using only a ssh connection? (no web browser, no graphical
capability). My first problem is to download using ftp instead a web
browser.

Try something like "yum install lynx" first - lynx is a text-based browser.

The default installation (#>yum install opstresql)suggest the version
8.1 but I would like to install the latest 8.3, so I suppose that I have
to change some file containing yum directive per postgresql.

Notes regarding RPMs here (there must be a more up-to-date one, this is
the first I found).

http://archives.postgresql.org/pgsql-announce/2008-06/msg00012.php

You'll probably want to add a new repository to yum (or something like
that - Debian my myself I'm afraid).

--
Richard Huxton
Archonet Ltd

On Thu, Apr 2, 2009 at 12:51 PM, dfx <dfx@dfx.it> wrote:

dear Sirs,

is there on the web a simple guide (for "idiots") to install postgresql on
CentOS 5.2 using only a ssh connection? (no web browser, no graphical
capability). My first problem is to download using ftp instead a web
browser.

The default installation (#>yum install opstresql)suggest the version 8.1
but I would like to install the latest 8.3, so I suppose that I have to
change some file containing yum directive per postgresql.

Actually postgresql is no installed, so I don't have to unistall and/or
backup.

If you want to use the pgsql version that's included with RHEL 5.2 you
can just use yum:

yum list | grep -i "postgres"

to see a list of packages.

sudo yum install "postgresql*"

to install everything.

If you want to run the latest and greatest, then you can dl the files
via wget and / or lynx. Using a web browser, and wandering about
ftp://ftp.postgresql.org you'll find this directory:

ftp://ftp.postgresql.org/pub/binary/v8.3.7/linux/rpms/redhat/rhel-5-x86_64/

right click on the packages and copy the link into your buffer, then
in your ssh terminal, type in:

wget ftp://ftp.postgresql.org/pub/binary/v8.3.7/linux/rpms/redhat/rhel-5-x86_64/ftp://ftp.postgresql.org/pub/binary/v8.3.7/linux/rpms/redhat/rhel-5-x86_64/postgresql-server-8.3.7-1PGDG.rhel5.x86_64.rpm

and wait for it to finish. If it gets stopped halfway through, use
wget -c ftp://.... (rest of url here) to start where you left off. Or
just use ftp. Or lynx.

Then when you've got them all in a directory ready to install, do:

sudo rpm --install *.rpm

in that directory.