LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Suse/Novell
User Name
Password
Suse/Novell This Forum is for the discussion of Suse Linux.

Notices

Reply
 
Search this Thread
Old 02-21-2011, 07:22 PM   #1
aarsh
Member
 
Registered: Mar 2010
Location: ATL, GA
Distribution: openSUSE 11.2 , salckware ,ubuntu
Posts: 169

Rep: Reputation: 18
Unhappy issues with PostgreSQL


hello, all.

At work site my company uses ubuntu and there, the installation was flawless.
but at home I use openSUSE 11.2, I want to install the same on my home PC also.
so I tried to do so with "install software" option from the "start" menu, which started YasT2. from where I downloaded the packages and installed. [ I doubt I have not done this work correctly ]. And hence lastly I goggled and found something relevant and useful at this page :

http://www.susegeek.com/database/ins...-opensuse-110/

all the commands on this page [ i didn't tried all commands after : "postgres=# \q".]

but though I am not able to open the GUI screen of the same.

please assist me...
 
Old 02-21-2011, 07:39 PM   #2
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,619
Blog Entries: 29

Rep: Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896
PostgreSQL is already in the opensuse dvd, try it once again,
insert the dvd, press Alt F2 , type yast, in the search box type, postgres,

Last edited by TheIndependentAquarius; 02-21-2011 at 07:41 PM.
 
Old 02-22-2011, 07:50 PM   #3
aarsh
Member
 
Registered: Mar 2010
Location: ATL, GA
Distribution: openSUSE 11.2 , salckware ,ubuntu
Posts: 169

Original Poster
Rep: Reputation: 18
Thumbs down

I done so, but there I did not found anything relevant ... please check the screen-shot attached herewith.


On my other workplace , where I use Ubuntu 10.10 , I did the same by issuing a command : "sudo apt-get install postgres".

Can the similar thing my be applied via zypper command.
please give me the command if this is possible , as I have never done any installation from command line in OpenSUSE.
Attached Images
File Type: jpg Screenshot.jpg (41.9 KB, 6 views)

Last edited by aarsh; 02-22-2011 at 07:57 PM.
 
Old 02-22-2011, 08:38 PM   #4
aarsh
Member
 
Registered: Mar 2010
Location: ATL, GA
Distribution: openSUSE 11.2 , salckware ,ubuntu
Posts: 169

Original Poster
Rep: Reputation: 18
can anyone please give the direct link to download the tar ball file, from which I can directly install PostgreSQL...
 
Old 02-22-2011, 09:31 PM   #5
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,619
Blog Entries: 29

Rep: Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896
Read the output of:
Code:
anisha@linux-uitj:~> cnf postgres

Last edited by TheIndependentAquarius; 02-22-2011 at 09:36 PM.
 
Old 02-24-2011, 07:21 PM   #6
aarsh
Member
 
Registered: Mar 2010
Location: ATL, GA
Distribution: openSUSE 11.2 , salckware ,ubuntu
Posts: 169

Original Poster
Rep: Reputation: 18
I tried to install postgresql from the source tar-ball of [perhaps, i am not sure] stable verion, version >> postgresql-8.0.26

using the commands :

./configure
gmake
su
gmake install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test


and last few lines of this were :

Success. You can now start the database server using:

/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start

postgres@linux-n21j:~>

but the next time I tried to execute

/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data ,

the error said :
postmaster cannot access the server configuration file "/usr/local/pgsql/data/postgresql.conf": Permission denied

when executed as a root user, it said :

FATAL: lock file "/usr/local/pgsql/data/postmaster.pid" already exists
HINT: Is another postmaster (PID 19581) running in data directory "/usr/local/pgsql/data"?

and when , switched to postgres 'user' it told :

postgres@linux-n21j:/home/aarsh> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
pg_ctl: another postmaster may be running; trying to start postmaster anyway
sh: logfile: Permission denied
pg_ctl: could not start postmaster
Examine the log output.





Additionally, I can't still see the entry of postgres in my main menu ???


So, is it that , I am missing PgAdmin ?

Last edited by aarsh; 02-24-2011 at 07:30 PM.
 
Old 02-24-2011, 09:31 PM   #7
TheIndependentAquarius
Senior Member
 
Registered: Dec 2008
Posts: 4,619
Blog Entries: 29

Rep: Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896Reputation: 896
Can you tell why you didn't try cnf postgres?

Check this out: http://www.yolinux.com/TUTORIALS/Lin...ostgreSQL.html
 
Old 02-26-2011, 06:10 PM   #8
michaelk
Moderator
 
Registered: Aug 2002
Posts: 11,806

Rep: Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721Reputation: 721
When installing from source the only client is the console based psql. However the binary installer from EnterpriseDB (http://www.enterprisedb.com/products...ing/pgdownload) does include pgAdmin.

postmaster is the database server and runs in the background. Typically you would configure postmaster as a service to start at boot time. Once it is started all transctions are accomplished using a client.

The advantage with installing using the distribution's repository is that everything is automatically configured for you.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
installing postgresql on RH9 issues mikepeters76 Linux - Software 3 05-04-2009 05:43 AM
postgresql issues wyzgreg Linux - Software 14 03-22-2008 11:12 PM
PostgreSQL thinker Red Hat 7 12-05-2006 03:39 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM
PostgreSQL 7.2.2 Released due to security issues rverlander Linux - Software 0 08-24-2002 07:15 PM


All times are GMT -5. The time now is 02:42 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration