Koozali.org: home of the SME Server

Pleas help with PostgreSQL update to 8.3

Offline Cosmyn

  • *
  • 12
  • +0/-0
Pleas help with PostgreSQL update to 8.3
« on: January 18, 2010, 12:48:22 PM »
Hi,

I have a problem: i need postgresql ver. 8.3 or newer, but in repository is only 8.1.15, which i`ve install. How do i upgrade it? How can i make yum see the newest version, or which version should i download from their server for a local install ?

Thanks

PS: It`s kind of urgent... so any help will be appreciated !

Offline CharlieBrady

  • *
  • 6,918
  • +3/-0
Re: Pleas help with PostgreSQL update to 8.3
« Reply #1 on: January 18, 2010, 05:06:59 PM »
Your post is off-topic for this forum, since SME server CDROM does not contain (any version of) postgresql.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Pleas help with PostgreSQL update to 8.3
« Reply #2 on: January 18, 2010, 05:09:30 PM »
Moving this topic to SME Server 7.x Contribs where it is more appropriate.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Pleas help with PostgreSQL update to 8.3
« Reply #3 on: January 18, 2010, 05:13:28 PM »
I have a problem: i need postgresql ver. 8.3 or newer, but in repository is only 8.1.15, which i`ve install. How do i upgrade it?
By finding newer packages and crossing your fingers :-) while installing them.

How can i make yum see the newest version, or which version should i download from their server for a local install ?
Your best bet for SME Server 7.x is the redhat el4-i386 versions, this should be the latest: ftp://ftp.postgresql.org/pub/binary/v8.4.2/linux/rpms/redhat/rhel-4-i386/ , but I am not sure if they will install and work OK.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)

Offline Cosmyn

  • *
  • 12
  • +0/-0
Re: Pleas help with PostgreSQL update to 8.3
« Reply #4 on: January 19, 2010, 11:12:04 PM »
Thank you very much.

I will try to use the current version since the server is in production and i have no time to setup an dedicated test server.
However, i`ve downloaded those packages for later use.

Offline cactus

  • *
  • 4,880
  • +3/-0
    • http://www.snetram.nl
Re: Pleas help with PostgreSQL update to 8.3
« Reply #5 on: January 20, 2010, 03:12:14 PM »
Thank you very much.

I will try to use the current version since the server is in production and i have no time to setup an dedicated test server.
However, i`ve downloaded those packages for later use.
You could try a virtualization software package like VirtualBox, Xen or VMWare for that as well.
Be careful whose advice you buy, but be patient with those who supply it. Advice is a form of nostalgia, dispensing it is a way of fishing the past from the disposal, wiping it off, painting over the ugly parts and recycling it for more than its worth ~ Baz Luhrmann - Everybody's Free (To Wear Sunscreen)