Find the answer to your Linux question:
Results 1 to 5 of 5
Hi. I'm currently studying by myself on Linux environment. I was a 3D CAD engineer until this March and I do not really have much knowledge on IT. I am ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    Sep 2009
    Location
    Japan
    Posts
    5

    How do I download and install PostgreSQL??


    Hi. I'm currently studying by myself on Linux environment. I was a 3D CAD engineer until this March and I do not really have much knowledge on IT.

    I am on a Linux (Tera Term) environment on windows XP, and I want to download and install PostgreSQL by myself from the internet source. My question is... how am I supposed to make it?

    I tried to get some info on the internet but everything has different commands to enter. Why there are so many different ways to do that?

    I may be asking about a silly question, but please help me do it.
    Or if there are any similar topics in the forum, please let me know.


    Thanks,
    Bert
    Last edited by Bert0528; 09-10-2009 at 03:01 AM. Reason: to make myself more clear

  2. #2
    Linux Guru coopstah13's Avatar
    Join Date
    Nov 2007
    Location
    NH, USA
    Posts
    3,149
    Do you have root access to the machine? What distro is it running? Normally you don't need to compile things from source, but if you don't have root access you will need to compile. Most likely there will be a lot of dependencies for libraries and stuff too, this could become quite difficult. The easiest way to install it would be through the package manager of the system.

  3. #3
    Just Joined!
    Join Date
    Sep 2009
    Location
    Japan
    Posts
    5
    Thank you, coopstah13.

    Yes, I do have root access to the machine and I used debian for distro.
    The process I took is:

    # groupadd postgres
    # useradd -g postgres -m postgres
    #passwd postgres
    Enter new UNIX password: *********
    Retype new UNIX password: ********

    (passwd: password updated successfully)

    #w-get -P /usr/local/src ftp.jp.postgresql.org/source/8.3.7/postgresql-8.3.7
    #mkdir /usr/local/postgresql-8.3.7
    #chown postgresostgres /usr/local/postgresql-8.3.7
    #cd /usr/local/src
    #tar xzf postgresql-8.3.7.tar.gz
    #chown -R postgresostgres /usr/local/src/postgresql-8.3.7

    #su - postgres
    #cd /usr/local/src/postgres-8.3.7

    #.configure --prefix=/usr/local/postgresql-8.3.7

    --After I enter this command I had an error message, so I was unable to enter "make" & "make install."

    So next, I used a command "apt-get install libreadline5-dev libnsurses5-dev zliblg-v" and I made it for installation.

    But here's something I don't really get...Why there are things to find & get from source that is here and there...? (libreadline5-dev, libnsurses5-dev, zliblg-v...)
    Is there an almighty, one single command to complete an installation?

    (I think I'm confused and I don't even know if I am making myself clear, but this is what I have been trying figure out.)
    Last edited by Bert0528; 09-16-2009 at 01:43 AM. Reason: to make it clear

  4. #4
    Linux Guru coopstah13's Avatar
    Join Date
    Nov 2007
    Location
    NH, USA
    Posts
    3,149
    with debian you should just need to run
    Code:
    apt-get install postgresql
    as root, there is no need to compile this package from source.

  5. #5
    Just Joined!
    Join Date
    Sep 2009
    Location
    Japan
    Posts
    5
    coopstah13,

    Thank you for the kind note. Now I know what you meant at your first comment and this time's one to get a clear idea about it

Posting Permissions

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