Thread: Install from source
OK, I downloaded the source and followed the directions from here (http://www.postgresql.org/docs/admin/installation.htm) and when I run the command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data >logfile 2>&1 & I get the error: [1] 28156 bash: logfile: Permission denied I try to createdb anyway and I get: /usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: cannot open sh ared object file: No such file or directory createdb: database creation failed [1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data>logfile 2>&1 I do not know what to do from this point. I would have thought if this was missing I would have had an error on compile. (Hence my infatuation with RPMs :) ) Adam Lang Systems Engineer Rutgers Casualty Insurance Company
ldconfig? No I didn't... (read back over the instructions) I guess I was too naive to think I could get away with the short instructions... I see in post installation that some other stuff is mentioned. Thanks. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Karl DeBisschop" <kdebisschop@h00a0cc3b7988.ne.mediaone.net> To: "Adam Lang" <aalang@rutgersinsurance.com> Sent: Wednesday, August 30, 2000 3:28 PM Subject: Re: [GENERAL] Install from source > Adam Lang wrote: > > > > OK, I downloaded the source and followed the directions from here > > (http://www.postgresql.org/docs/admin/installation.htm) and when I run the > > command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data > > >logfile 2>&1 & > > > > I get the error: > > [1] 28156 > > bash: logfile: Permission denied > > > > I try to createdb anyway and I get: > > /usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: > > cannot open sh > > ared object file: No such file or directory > > createdb: database creation failed > > [1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -D > > /usr/local/pgsql/data>logfile 2>&1 > > > > I do not know what to do from this point. I would have thought if this was > > missing I would have had an error on compile. > > did you run ldconfig (or its equivalent)? > > -- > Karl DeBisschop kdebisschop@alert.infoplease.com > Family Education Network/Information Please http://www.infoplease.com > Netsaint Plugin Developer kdebisschop@users.sourceforge.net
"Adam Lang" <aalang@rutgersinsurance.com> writes: > OK, I downloaded the source and followed the directions from here > (http://www.postgresql.org/docs/admin/installation.htm) and when I run the > command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data >> logfile 2>&1 & > I get the error: > [1] 28156 > bash: logfile: Permission denied Do you have write permission in the directory you're doing this in? > I try to createdb anyway and I get: > /usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: > cannot open shared object file: No such file or directory > createdb: database creation failed > [1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -D > /usr/local/pgsql/data>logfile 2>&1 Sounds like you have not done the incantation to make the shared libraries available --- see step 8 in http://www.postgresql.org/users-lounge/docs/7.0/postgres/install17165.htm The ldconfig method is probably what you want to use. regards, tom lane
Also, thanks for the point out of that installation page. I was going by www.postgresql.org/docs and the administrators link. Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Adam Lang" <aalang@rutgersinsurance.com> Cc: "PGSQL General" <pgsql-general@postgresql.org> Sent: Wednesday, August 30, 2000 4:36 PM Subject: Re: [GENERAL] Install from source > "Adam Lang" <aalang@rutgersinsurance.com> writes: > > OK, I downloaded the source and followed the directions from here > > (http://www.postgresql.org/docs/admin/installation.htm) and when I run the > > command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data > >> logfile 2>&1 & > > > I get the error: > > [1] 28156 > > bash: logfile: Permission denied > > Do you have write permission in the directory you're doing this in? > > > I try to createdb anyway and I get: > > /usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: > > cannot open shared object file: No such file or directory > > createdb: database creation failed > > [1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -D > > /usr/local/pgsql/data>logfile 2>&1 > > Sounds like you have not done the incantation to make the shared > libraries available --- see step 8 in > http://www.postgresql.org/users-lounge/docs/7.0/postgres/install17165.htm > The ldconfig method is probably what you want to use. > > regards, tom lane
Yeah, I caught the first stupid mistake. What happened was I was logged in as postgres and su'ed to root to remove the previous RPM of postgres 6.5. I then did the compiling, etc. I exited and went back to the postgres user. Well, removing the RPM removed the user that the RPM made so the owner of /home/postgres became uid 26 as opposed to postgres which was what I was technically logged in as. And since I was in the home directory trying to dump the logfile, permission was denied. As for the later, yeah, I went by the short instructions and and the ldconfig step was skipped. I guess I tried to get out of it too easy. :) Adam Lang Systems Engineer Rutgers Casualty Insurance Company ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Adam Lang" <aalang@rutgersinsurance.com> Cc: "PGSQL General" <pgsql-general@postgresql.org> Sent: Wednesday, August 30, 2000 4:36 PM Subject: Re: [GENERAL] Install from source > "Adam Lang" <aalang@rutgersinsurance.com> writes: > > OK, I downloaded the source and followed the directions from here > > (http://www.postgresql.org/docs/admin/installation.htm) and when I run the > > command: /usr/local/pgsql/bin/postmaster -i -D /usr/local/pgsql/data > >> logfile 2>&1 & > > > I get the error: > > [1] 28156 > > bash: logfile: Permission denied > > Do you have write permission in the directory you're doing this in? > > > I try to createdb anyway and I get: > > /usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: > > cannot open shared object file: No such file or directory > > createdb: database creation failed > > [1]+ Exit 1 /usr/local/pgsql/bin/postmaster -i -D > > /usr/local/pgsql/data>logfile 2>&1 > > Sounds like you have not done the incantation to make the shared > libraries available --- see step 8 in > http://www.postgresql.org/users-lounge/docs/7.0/postgres/install17165.htm > The ldconfig method is probably what you want to use. > > regards, tom lane