The following bug has been logged online:
Bug reference: 3039
Logged by: Jessica
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Solaris 10
Description: install completely but can't connect to server
Details:
The procedure of installation as follows:
configure --prefix=(absolute path of MyInstall Directory) --bindir=(abs path
of MyInstall/bin)
--datadir=(abs path of MyInstall/share) --sysconfdir=(abs path of
MyInstall/etc) --libdir=(abs
path of MyInstall/lib) --includedir=(abs path of MyInstall/include)
--mandir=(abs path of
MyInstall/man --enable-debug --enable-cassert
//after this, I checked the subdirectory MyInstall, no //subdirectory etc
and man created . Is it a problem? //why? how to solve it?
4. use gmake to build the PostgreSQL
5. gmake install to install PostgreSQL
*****************************************
//Success. You can now start the database server using:
postmaster -D /home/group/s772/p772-01f/pgsql/CLUST/sys
or
pg_ctl -D /home/group/s772/p772-01f/pgsql/CLUST/sys -l logfile start
*********************
6. Create the required filesystem
1. Make directory CLUST
2. Make Directories CLUST/sys, CLUST/wal, CLUST/archwal, CLUST/data
----Setting the Environment Variables ---
bash-3.00$ LD_LIBRARY_PATH=/home/group/s772/p772-01b/pgsql/MyInstall/lib
bash-3.00$ PATH=/home/group/s772/p772-01b/pgsql/MyInstall/bin:$PATH
bash-3.00$ export PATH LD_LIBRARY_PATH
bash-3.00$ PGDATA=/home/group/s772/p772-01b/pgsql/CLUST/sys
bash-3.00$ export PGDATA
----Create Database Cluster ---
bash-3.00$ initdb -E UNICODE -A password -W
----Startup and Shutdown of PostgreSQL cluster--
bash-3.00$ pg_ctl -D /home/group/s772/p772-01f/pgsql/CLUST/sys -l logfile
start
postmaster starting
****************************************
logfile:
LOG: could not bind IPv6 socket: Cannot assign requested address
HINT: Is another postmaster already running on port 5432? If not, wait a
few seconds and retry.
FATAL: could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission
denied
**************
How to solve it? I had repeated n times for installation. but I failed. How
to solve?
This really makes me upset. The documentation reads like puzzle, taking you
here, and there, but no usful instructions.
Thanks.
Thanks.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
