Skip site navigation (1) Skip section navigation (2)

BUG #3039: install completely but can't connect to server

From: "Jessica" <hxq7681(at)cs(dot)rit(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3039: install completely but can't connect to server
Date: 2007-02-20 18:05:30
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      3039
Logged by:          Jessica
Email address:      hxq7681(at)cs(dot)rit(dot)edu
PostgreSQL version: 8.2
Operating system:   Solaris 10
Description:        install completely but can't connect to server

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
    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
postmaster starting
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
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. 




pgsql-bugs by date

Next:From: Dreas NielsenDate: 2007-02-20 18:39:55
Subject: BUG #3040: Domain type handling change in 8.2.2 breaks declarations
Previous:From: Eli GreenDate: 2007-02-20 16:31:58
Subject: BUG #3038: information_schema.constraint_column_usage has wrong information for foreign keys

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group