Take the 2-minute tour ×
Ask Ubuntu is a question and answer site for Ubuntu users and developers. It's 100% free, no registration required.

I am a newbie in using Ubuntu (more precisely never used linux except the production deployment ). Now I choose to hold a grip on the system and intalled a latest 11.10 Ubuntu in my 32 bit Intel** desktop. In this machine **I have a 'administrator' user 'tusar'.

I want to install the PostgreSQL graphical version so downloaded this file postgresql-8.4.9-1-linux.bin from here

Now If run the file with ./filename command (refuses if I am not root), it opens up the graphical interface and completes the installation (creates user postgres and ask for password, wont complete if I dont give valid password).

I checked with /etc/inint.d/postgresql-8.4 status , that postgres is running.

But the problem is I am unable to open the GUI (I installed it in /opt/Postgresql ), its telling permission denied even if I am logged in as 'tusar'. Then I tried using the su postgres command and it directly changed the user without password. Now if I run the psql , createdb , its prompting me to install the postgres-client-package but this utilies are already installed and I can view them in my /opt/Postgresql/8.4/bin folder.

I can run query through my JDBC utility programs but unable to use neither terminal nor the graphical interface (although I can see pgAdmin3 is there ). Urgent help needed.

I have used this guide for the installation.

share|improve this question
add comment

1 Answer 1

My suggestion would be to not use that all-in-one installer in the first place. Ubuntu already includes all the tools you need to make use of PostgreSQL in its software archive, including the graphical administration utility pgAdmin III. And since these programs are part of the software archive, you get the benefit of Ubuntu security updates (which you won't get with a 3rd party installer).

I'm not sure of the best way to clean up after the installer you tried, but I can give some tips on configuring PostgreSQL on a fresh system.

You can install the database with the following command:

sudo apt-get install postgresql

You can then find instructions on creating an account to log in to the database in /usr/share/doc/postgresql-9.1/README.Debian.gz. Once you've done that you can use the graphical administrative front end, which can be installed from the software centre or with the following command:

sudo apt-get install pgadmin3

If you need to access PostgreSQL via JDBC, you can install the Java drivers with the following command:

sudo apt-get install libpg-java
share|improve this answer
    
Is this true - 'Ubuntu already includes all the tools you need to make use of PostgreSQL in its software archive, including the graphical administration utility pgAdmin III' ? Then why it downloads again ? I'm not agree. By the way I got to work with psql and pgAdmin by going into 'scripts' folder and running the 'runpsql.sh' and 'launchpgadmin.sh' files with './' command as superuser. –  tusar Nov 30 '11 at 3:52
    
Some benefits of all-in-one package is if I download it once, I can keep the the file for future re-use and can send to other users for use. apt-get does not allow sending my installer to friends they have to download individually. In case of 'apt-get', if I uninstall the package, whole software will be lost and again I'll have to download and install. correct ? –  tusar Nov 30 '11 at 3:59
    
The instructions I've provided do require an Internet connection to complete, but they also have the benefit that if any security updates are released, they will install the fully patched version of the tool. If security vulnerabilities are discovered and you're using that all-in-one installer, it will be up to you to download a new version of the installer. And that download is likely to be larger than that from the Ubuntu archive, since it will include copies of all the packages that didn't need patching. –  James Henstridge Nov 30 '11 at 7:28
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.