Install from source

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

"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:

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: