Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2009
    Posts
    4

    Question Unanswered: Multiple Postgres Instances on Ubuntu

    Hi people,

    I'm involved in several projects nowadays, and that makes me the need to install several postgresql versions.

    My actual problem is, how can I install postgresql-8.3.1 and postgresql-8.3.4 on ubuntu (linux).

    Anyone knows how can I do it?
    Thanks!

  2. #2
    Join Date
    Aug 2009
    Location
    Olympia, WA
    Posts
    337
    You shouldn't need to install both because there won't be any functionality differences between the two minor releases.

    You can install two major versions (like 8.3 and 8.4) on ubuntu because it puts the config and data files in separate folders by default (/etc/postgres/8.4/...).

    But to do this, you'll only be able to install 1 thru synaptic, and the other you'll need to install using 1-click installer or compile your own.

    Obviously you'll need to put them on different ports.

  3. #3
    Join Date
    Oct 2009
    Posts
    4
    Quote Originally Posted by artacus72 View Post
    You shouldn't need to install both because there won't be any functionality differences between the two minor releases.

    You can install two major versions (like 8.3 and 8.4) on ubuntu because it puts the config and data files in separate folders by default (/etc/postgres/8.4/...).

    But to do this, you'll only be able to install 1 thru synaptic, and the other you'll need to install using 1-click installer or compile your own.

    Obviously you'll need to put them on different ports.
    Hi, thank you for your answer
    I only need to use one at a time, so think that I can use the same ports.

    I am using: the following commands to install postgres:
    1) $ tar xvzf postgresql-8.3.5.tar.gz
    2) $ cd postgresql-8.3.5/
    3) $ ./configure --with-pam
    4) $ make
    5) $ sudo make install

    And it installs postgres into folder: /usr/local/pgsql.

    How can I decide were to put them?
    Thanks once more
    Last edited by pmlemos; 11-04-09 at 16:10.

Tags for this Thread

Posting Permissions

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