Hi geeks

I have installed postgressql on my slackware v 10 system.
Everything worked nice and normal. I compiled the package.

i wanted to start the database with : "psql"
but there was this error :
rock@rockshome:/usr/local/pgsql/bin$ psql
psql: error while loading shared libraries: libssl.so.4: cannot open shared object file: No such file or directory

I googled about this error !

I found some similar problems which where solved by installing the new open ssl version (i think its 2.7a)
but there still was this f*** error.... i have tryed to install pqsql with rpms but there was the same error too !

Pleas help me i am not sure but i would describe myself as bloody newbie

Thanks in advance for your help and your time !

Rock aka Steffen B.

Hi, and welcome to LQ!

If you compiled PosrgreSQL on the machine you're
trying to run it on this shouldn't occur. I've compiled
7.4.6 just a few days ago on a standard Slack 10
installation with the default OpenSSL install, and it
works just fine. What exactly did you do?


Cheers,
Tink


P.S.: Move to Slackware forum, more suitable there.

You may want to try running ldconfig as root.
I seem to remember that I had to do this so it could find the shared library that it installed.
I have it running from source on Slack 10 and it runs great!

Jim

ldconfig won't do any good unless you
a) Install postgres with prefix=/usr
or
b) Add /usr/local/pgsql/lib to /etc/ls.co.conf


Cheers,
Tink

Thanks a lot.
I realised that the problem is, that pgsql cant find my libssl.so !
The file is located at /usr/libexec/apache/libssl.so so how and where can i configure/edit that postgressql finds this lib at this path?

May you post the url/ftp url where you downloaded the packs for slackware? would be very nice.

hmm will google/code/food for help

thanks in advance !

mfg Rock

-------------------- UPDATE -------------------------

Okay i have now reinstalled the hole package !

I have done everything like in the install manule (http://www7.de.postgresql.org/docs/7...tallation.html)


Now it shows me this errors :

root@rockshome:/home/rock/downloads/gamerirc/postgresql-7.4.6# chown postgres /usr/local/pgsql/data
root@rockshome:/home/rock/downloads/gamerirc/postgresql-7.4.6# su - postgres
/dev/pts/1: Operation not permitted

In the beginning there was nothing. And the Lord said "Let There Be Light!"
And still there was nothing, but at least now you could see it.

postgres@rockshome:~$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales:
COLLATE: C
CTYPE: en_US
MESSAGES: en_US
MONETARY: en_US
NUMERIC: en_US
TIME: en_US

initdb: directory "/usr/local/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data" or run initdb with an argument other than
"/usr/local/pgsql/data".
postgres@rockshome:~$ initdb -D /usr/local/pgsql/data
-su: initdb: command not found
postgres@rockshome:~$ ls
postgres@rockshome:~$ cd /usr/local/pgsql
postgres@rockshome:/usr/local/pgsql$ initdb -D /usr/local/pgsql/data
-su: initdb: command not found
postgres@rockshome:/usr/local/pgsql$ cd bin
postgres@rockshome:/usr/local/pgsql/bin$ initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locales:
COLLATE: C
CTYPE: en_US
MESSAGES: en_US
MONETARY: en_US
NUMERIC: en_US
TIME: en_US

initdb: directory "/usr/local/pgsql/data" exists but is not empty
If you want to create a new database system, either remove or empty
the directory "/usr/local/pgsql/data" or run initdb with an argument other than
"/usr/local/pgsql/data".
postgres@rockshome:/usr/local/pgsql/bin$ /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
[1] 3457
postgres@rockshome:/usr/local/pgsql/bin$ -su: logfile: Permission denied
/usr/local/pgsql/bin/createdb test
createdb: could not connect to database template1: 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"?
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1
postgres@rockshome:/usr/local/pgsql/bin$ /usr/local/pgsql/bin/psql test
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"?
postgres@rockshome:/usr/local/pgsql/bin$ psql test
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"?
postgres@rockshome:/usr/local/pgsql/bin$ ls
clusterdb* createuser* dropuser* initlocation* pg_controldata* pg_dumpall* pg_resetxlog* postmaster@
createdb* dropdb* ecpg* ipcclean* pg_ctl* pg_encoding* pg_restore* psql*
createlang* droplang* initdb* pg_config* pg_dump* pg_id* postgres* vacuumdb*
postgres@rockshome:/usr/local/pgsql/bin$

Thanks for your help

Create this file (as root) ...

chomd ugo+x /etc/profile.d/postgres.sh


Cheers,
Tink

Oki i have done it
Now the "new" problem

i really think that i am a fucking

Well I said create that file, and just posted the cat
so you can see it's name and what to put in it ;)


Cheers,
Tink

hmm i have done it

Here MY solution

First
"chown -R postgres:users /usr/local/pqsql/ "

afterwards
starting from the user postgres ./postmaster
then with postgres /.pgsql test
done hopefully
yea done thanks a lot guys