Postgresql 9.1 on ubuntu 9.10

by

I have a quick question. Did you install postgresql 9.1 on the ubuntu server 9.10 ?
If yes, it was a pure installation or update from 8.4 ? If update how did it go ?
Where did you get deb package ?
Oh, really, I need deb package because install from sources on a lot of server isn’t good idea.

Answer

Your choices in this situation are limited:

  1. Find someone who has already compiled a .deb package for your version of Ubuntu
    (As far as I’m aware that’s not possible for something as old as Karmic (9.10))

  2. Build/Install from source on each server

  3. Build from source and assemble a .deb package to install on your servers.
    (Probably the most viable option if you have lots of systems & can’t upgrade the OS.)

In any case you will need to observe the Postgres upgrade procedure – you can’t just dump the new DB binaries on your server and expect it to work with the old PGDATA format.

As Craig pointed out Karmic Koala (Ubuntu 9.10) is well past end of life — you should really be considering an upgrade path to a supported OS (I’m not even sure Postgres will build, or that your system libraries don’t have bugs that will cause Postgres to behave badly if it does compile) – If you ask a question about upgrade paths (describing your environment with enough detail) we can probably help you get onto more stable ground.

Attribution
Source : Link , Question Author : alterpub , Answer Author : voretaq7

Leave a Comment