Hello,
I am having some difficulty performing the "short install" on RHL 6.1
/usr/local/pgsql/bin/createdb test
CAUSES THIS ERROR:
/usr/local/pgsql/bin/psql: error in loading shared libraries:
libpq.so.2.1: cann
ot open shared object file: No such file or directory
createdb: database creation failed
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -D
/usr/local/pgsq
l/data >logfile 2>&1
??????????????
Now from the instruction(which are entered here verbosely from the
INSTALL file:
1. Create the PostgreSQL superuser account. This is the user the server
will run as. For production use you should create a separate,
unprivileged account (postgres is commonly used). If you do not
have
root access or just want to play around, your own user account is
enough.
NOW I'm familiar with THE 'root' account, user accounts and group
accounts,
but I've never seen an 'application superuser account'?????????
sudo or something like that?????????
Also, I had to run the installation as 'root' as users do not
have priviledges to write to the /usr/local/ directories, so the
aforementioned warning about the server running as the user
account, are somewhat confusing to me
I'm experimenting on RedHat Linux 6.1
Apache(1.3.12), DBI(1.14) and DBD-Pg(0.95) and Perl(5.005_03)
are all installed have passed several tests. All these
packages are installed from source, all RPMs have been
uninstalled.
:
Also I have attached file on the results of following the short method
for installation.
Any help is appreciated, and If upgrading to RHL 7.0 is the answer, that
OK too.
Location of installation:
/usr/local/src/postgresql-7.0.2/src
./configure ran just fine
gmake ran just fine:
All of PostgreSQL is successfully made. Ready to install.
gmake install
runs but here are a few of the missing items:
gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I.. -c fmgrtab.c -o
fmgrtab.o
ld -r -o SUBSYS.o fmgrtab.o adt/SUBSYS.o cache/SUBSYS.o error/SUBSYS.o fmgr/SUBSYS.o hash/SUBSYS.o init/SUBSYS.o
misc/SUBSYS.ommgr/SUBSYS.o sort/SUBSYS.o time/SUBSYS.o
gmake[2]: Entering directory `/usr/local/src/postgresql-7.0.2/src/backend/tcop'
gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I.. -Wno-error -c
fastpath.c-o fastpath.o
gmake[2]: Entering directory `/usr/local/src/postgresql-7.0.2/src/backend/libpq'
gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I.. -c be-dumpdata.c -o
be-dumpdata.o
gcc -I../../include -I../../backend -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -I.. -c be-pqexec.c -o
be-pqexec.o
<Note: these were clipped in reverse of execution order>
but I did get this ending message:
Thank you for choosing PostgreSQL, the most advanced open source database
engine.
next
adduser postgres
adduser: user postgres exists
su - postgres worked fine:
[postgres@frost pgsql]$
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
runs fine(initdb already exists)
/usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1 &
pgsql seems to load correctly
/usr/local/pgsql/bin/createdb test
CAUSES THIS ERROR:
/usr/local/pgsql/bin/psql: error in loading shared libraries: libpq.so.2.1: cannot open shared object file: No such
fileor directory
createdb: database creation failed
[1]+ Exit 1 /usr/local/pgsql/bin/postmaster -D /usr/local/pgsql/data >logfile 2>&1
??????????????
Now from the instruction(which are entered here verbosely from the INSTALL file:
1. Create the PostgreSQL superuser account. This is the user the server
will run as. For production use you should create a separate,
unprivileged account (postgres is commonly used). If you do not have
root access or just want to play around, your own user account is
enough.
NOW I'm familiar with THE 'root' account, user accounts and group accounts,
but I've never seen an 'application superuser account'?????????
sudo or something like that?????????
Also, I had to run the installation as 'root' as users do not
have priviledges to write to the /usr/local/ directories, so the
aforementioned warning about the server running as the user
account, are somewhat confusing to me
I'm experimenting on RedHat Linux 6.1
Apache(1.3.12), DBI(1.14) and DBD-Pg(0.95) and Perl(5.005_03)
are all installed have passed several tests. All these
packages are installed from source, all RPMs have been
uninstalled.
Ideas??????
wireless@tampabay.rr.com