LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 02-12-2003, 04:10 PM   #1
importboy03
Member
 
Registered: Feb 2003
Location: NorthEast
Distribution: RH 8.0
Posts: 34

Rep: Reputation: 15
can't installing Postgresql


When I try to install Postgesql, I got this message:
[root@localhost root]# rpm -iv postgresql-7.2.2*
warning: postgresql-7.2.2-1.i386.rpm: V3 DSA signature: NOKEY, key ID db42a60e
error: Failed dependencies:
postgresql-libs = 7.2.2 is needed by postgresql-7.2.2-1
libpq.so.2 is needed by postgresql-7.2.2-1

any idea?
 
Old 02-12-2003, 04:17 PM   #2
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
Install postgresql libs first? :)

cheers,
Tink
 
Old 02-12-2003, 05:25 PM   #3
importboy03
Member
 
Registered: Feb 2003
Location: NorthEast
Distribution: RH 8.0
Posts: 34

Original Poster
Rep: Reputation: 15
got it, thanks
 
Old 02-13-2003, 11:54 AM   #4
importboy03
Member
 
Registered: Feb 2003
Location: NorthEast
Distribution: RH 8.0
Posts: 34

Original Poster
Rep: Reputation: 15
After installation, I can't find any files associated with the postgresql. Does anybody know how to start the db? I got this error when running the 'psql' command:

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

How do I fix this problem and start the db? In addition, I like to access the db with JDBC. I read the doc on the postgresql.com and still don't understand how to communicate with the db. I already installed JDBC driver, but I don't know how to test it. BTW, I'm planning using JSP application for this db.
 
Old 02-13-2003, 01:28 PM   #5
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
You sure you read the docs? :)
They are quite straight forward ...

Check whether postgresql starts is up & running
Code:
ps -A | grep postmaster
If it's not, do:
Code:
su - postgres
pg_ctl start
Cheers,
Tink
 
Old 02-13-2003, 01:56 PM   #6
importboy03
Member
 
Registered: Feb 2003
Location: NorthEast
Distribution: RH 8.0
Posts: 34

Original Poster
Rep: Reputation: 15
got it it running finally. I found a differnet doc from http://www.opennet.ru/docs/HOWTO/Pos...-6.html#ss6.1.
that help me. The reason is that I must install all packages of postgresql. I didn't install postgresql-server-7.2.2-1.i386.rpm at the time. Oh, I don't understand why I must switch user to postgres without adding postgres user. I installed it with root. Is this mean I have to use postgres user everytime I want to work with the db?
 
Old 02-13-2003, 02:21 PM   #7
Tinkster
Moderator
 
Registered: Apr 2002
Location: in a fallen world
Distribution: slackware by choice, others too :} ... android.
Posts: 23,067
Blog Entries: 11

Rep: Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910Reputation: 910
I have never installed Postgres from RPM's,
so wouldn't know what the makers of an RPM
do to it ...

The default is *not* to run postmaster from
user root (security measures, I believe)

What one is supposed to do is to create an
entry in rc.local that starts the dbm as user
postgres.

And know, you don't have to su to postgres to
use the database :)

Cheers,
Tink
 
  


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
login and postgresql problem after installing openldap robertngo Linux - Software 1 07-18-2005 07:47 PM
problem with installing PostgreSQL . Configuring false with Java kernelvn Linux - Software 0 08-30-2004 04:15 AM
Installing PostgreSQL DBMS Hady Linux - Software 1 04-28-2004 05:44 AM
installing and running postgresql or MySql Whatshisface Linux - Software 3 02-22-2004 11:29 PM
postgresql -odbc & postgresql-jdbc installation kjsubbu Linux - Software 0 06-19-2003 02:50 AM


All times are GMT -5. The time now is 12:37 AM.

Main Menu
Advertisement
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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration