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.