Blog

Ponderings of a kind

This is my own personal blog, each article is an XML document and the code powering it is hand cranked in XQuery and XSLT. It is fairly simple and has evolved only as I have needed additional functionality. I plan to Open Source the code once it is a bit more mature, however if you would like a copy in the meantime drop me a line.

Atom Feed

Installing Postgres 9.0 onto Amazon EC2 Linux

Amazon Linux and Postgres

Amazon EC2 Linux is based on a customised version of Redhat Enterprise Linux, but sadly they do not seem to have Postgres 9.0 available from their Yum repositories. However with a bit of fiddling around I was able to get it to install, so I have reproduced the details here for everyone else.

1) Download and install the appropriate YUM repository configuration from here - http://yum.pgrpms.org/reporpms/repoview/pgdg-redhat.html

   $ wget http://yum.pgrpms.org/reporpms/9.0/pgdg-redhat-9.0-2.noarch.rpm
   $ sudo rpm -i pgdg-redhat-9.0-2.noarch.rpm

2) You need to manually edit the Yum repo file that has just been installed for Postgres 9, as otherwise an unknown release version (as far as the Postgres repo is concerned) will be used, and you wont be able to download and install the packages.
Edit the file /etc/yum.repos.d/pgdg-90-redhat.repo and replace the string “$releasever” with “6.0”

3) You can now install Postgres 9.0 using Yum.

    $ sudo yum install postgresql90-server

4) You can now start up the database

            
    $ sudo /etc/init.d/postgresql-9.0 initdb
    $ sudo /etc/init.d/postgresql-9.0 start

5) Check that you can login to the server

            
    $ sudo su – postgres
    -bash-4.1$ psql
            
    psql (9.0.4)
    Type "help" for help.
            
    postgres=#

Done :-)

Adam Retter posted on Saturday, 9th July 2011 at 16.02 (GMT+02:00)
Updated: Saturday, 9th 2011 at July 16.02 (GMT+02:00)

tags: AmazonAWSEC2LinuxPostgres

Add Comment



(will not be shown)






MAY 2013
AUGUST 2012
APRIL 2012
JULY 2011
JUNE 2011
JANUARY 2011
NOVEMBER 2010
OCTOBER 2010
SEPTEMBER 2010
SEPTEMBER 2009
JULY 2009
JUNE 2009
MAY 2009
APRIL 2009
MARCH 2009

Tag Cloud

XQuery Full-Text Search eXist-db Frankfurt Bruxelles CityResidence CityBank Bergerstraße travel moving ZFS ZPOOL fail NAS disk OpenSolaris NASA Met Office Space Apps XML eXist IOS Android Code QBasic Hardware 8255A Software PC Interface OpenIndiana XDMCP Mac OSX Xephyr Solaris Open Indiana Open Solaris entic.net web hosting Nokia N95 N97 HTC Samsung i7500 Galaxy Battery XML Prague EXQuery XML Schema XSLT XSpec FunctX XProc Redstone XML-RPC Java HTTP Authentication Active Directory LDAP Primary Group SID Time Machine AFP Netatalk Avahi Chenbro DIY RAIDZ2 CIFS RAID Storage Open Source Highpoint Technologies Energy Efficient RAIDZ MSI Amazon AWS EC2 Linux Postgres EXPath HTTPClient User Agent HTTP 1.1 Persistent Connections cURL IIS NetBeans TEI java oXygen Xmx memory Hibernate ORM wildcard mapping package Spring Maven jQuery XHTML checkbox checked