Hi to all. Me again !
I can't get postgress to work on my red hat system.
I have tried a number of ways: using the rpms (versions 6.3.2-4.i386.rpm). These would
not allow me to add users, or to create a database, or to run the regression tests. I
played with the environmental variables, but to no avail.
At this point creatdb and initdb were complaining about not finding monitor, which was
on my path.
I gave up this tack, and decided to compile from the srpm, seeing that I might have
problems with finding libraries needed for the default distribution of rpm. I did the
rpm --rebuild ***.srpm and got executables. Same problems. No amount of frigging about
with env variables would make the bugger go. On the (good) advice recieved from the
net, I decided to screw the redhat approach, and just work up the tarball. It compiled
without error, and I proceded to install it as per the postgresql administrators
guide, without incident.
I have run everything up to the make install on page11. No problems, very few minor
warnings, mostly relating to c++ style issues: nothing fatal, what youd expect from a
make.
However, after setting all the variables exactly as per the manual, when I try to
initdb I get the following error:
initdb: warning: Make install has not been run
initdb: could not find template files
initdb: set POSTGRESTEMP to the proper directory and rerun.
I set POSTGRESTEMP to where my template files are, and it dies of something else. I
vary slightly to make POSTGRESTEMP point to the actual file and it varies. I try
variations, and it dies.
Additionally, in this current build, when I try to run postmaster, I get the error
[postgres@dingo postgres]$ postmaster &
postmaster: can't load library '/libm.so.4'
No such library.
What is the story on this program?
Any help will be gratefully appreciated, beleive me !!
cheers, Leon
Leon Harris
Visiting Fellow
Room 221, Bldg 3
3 Centre Drive, Bethesda, MD
National Heart, Lung, and Blood Institute
National Institutes of Health.
phone 301 496 6390