Thread: Postgresql installation with ssh connection.
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. Thank you for your suggestions. D. Formenton
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.