Problem using postgresql in opensuse 11.1

[sarabha kumar]

I got stuck up with some problems as listed below; hence I seek your help.

Firstly, I tried to build a database, then got the following error :

linux-dz48:~/Desktop # createdb db1

createdb: could not connect to database postgres: 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"?

Then I tried to start the server :

 service postgresql start

service: no such service postgresql

 chkconfig --add postgresql

postgresql: unknown service

Then I learnt that postgresql server was not installed, so I tried installing it using the same rpm files then the following errors occured :

Package /home/sarabha/Documents/postgresql_rpm_files/postgresql-server-8.3.7-7.2.i586.rpm could not be installed.

Details:

Subprocess failed. Error: RPM failed: warning: /home/sarabha/Documents/postgresql_rpm_files/postgresql-server-8.3.7-7.2.i586.rpm: Header V3 DSA signature: NOKEY, key ID 05905ea8

error: Failed dependencies:

/usr/bin/strings is needed by postgresql-server-8.3.7-7.2.i586

Now, in starting software management(Yast2) also the following error occurs....although it never occured when I used opensuse 10.2

There was an error in the repository initialization.

'repo-update': [repo-update|http://download.opensuse.org/update/11.1/] Repository is not cached

I think this could be the root cause of the above problems.

Please suggest me some solutions.

[Roshan Singh]

use yast to install postgresql database. This should fulfill all dependencies.


--
Roshan Kumar Singh
http://roshansingh.wordpress.com
http://lug.nitdgp.ac.in
IRC - #nitdgplug on Freenode