Results 1 to 3 of 3

Thread: Recovering data from old postgresql install

  1. #1
    Join Date
    Feb 2005

    Recovering data from old postgresql install

    I was previously running postgresql 8.3, but upgrading to Ubuntu 10.04, has installed postgresql 8.4 and I'm now unable to start 8.3.

    I don't mind using 8.4, but I need to recover the data from my 8.3 installation, But I'm not sure how to do this as I can't start the 8.3 server, and 8.4 can't read my old data directory.

    Please help!

  2. #2
    Join Date
    Sep 2006

    Re: Recovering data from old postgresql install

    Unfortunately I found myself in the same situation. I was unable to find a solution on my PC.

    The solution for me was moving my data folder to another PC with 8.3 installed, creating dumps of the relevant db's, copying them back to my PC and restoring them...

  3. #3
    Join Date
    May 2009

    Re: Recovering data from old postgresql install

    Pretty easy fix actually.

    Add the following to your /etc/apt/sources.list:
    deb karmic main restricted universe
    deb-src karmic main restricted universe
    Then type:
    apt-get update && apt-get install postgresql-8.3
    If pg8.4 is running, dpkg will report an error that the port is already in use, so I would stop 8.4 first or the installation wont be completed. (dpkg has to run an init script to start the server for installation to be successful)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts