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

Request for Postgres help

From: TALMAN(at)LNS62(dot)LNS(dot)CORNELL(dot)EDU
To: pgsql-ports(at)postgresql(dot)org
Subject: Request for Postgres help
Date: 1999-10-30 16:26:16
Message-ID: 01JHQUJSCJ2A8XYPSV@LNS62.LNS.CORNELL.EDU (view raw or flat)
Thread:
Lists: pgsql-ports
Mindlessly followed instructions using
	Vanilla Solaris 5.7
	gcc sparc-sun-solaris2.7
setting up user postgres (~ = a/usr/local/pgsql) and doing 
everything as postgres.

	$ cd /usr/src/pgsql
	$ gunzip -c ~/postgresql-6.5.2.tar.gz | tar xvf -
Perhaps your instructions leave out a step since, instead of
	$ cd /usr/src/pgsql/src
I had to move something, or make link, or (what I did) use   
	$ cd /usr/src/pgsql/postgresql-6.5.2/src
        $ ./configure --without-CXX
(since libpq++ failed; I don't care) and otherwise accepted 
all defaults. 

Entire build and installation went as advertised.

Set environment variables as instructed
	LD_LIBRARY_PATH=/usr/local/pgsql/lib
	PATH=$PATH:/usr/local/pgsql/bin
        MANPATH=$MANPATH:/usr/local/pgsql/man
        PGLIB=/usr/local/pgsql/lib
        PGDATA=/usr/local/pgsql/data

Left /usr/local/pgsql/data/pg_hba.conf unchanged

Ran	$ initdb

We are initializing the database system with username postgres (uid=1003).
This user will own all the files and must also own the server process.
Creating Postgres database system directory /usr/local/pgsql/data
Creating Postgres database system directory /usr/local/pgsql/data/base
Creating template database in /usr/local/pgsql/data/base/template1
Creating global classes in /usr/local/pgsql/data/base
Adding template1 database to pg_database...
Vacuuming template1
Creating public pg_user view
Creating view pg_rules
Creating view pg_views
Creating view pg_tables
Creating view pg_indexes
Loading pg_description

Which I took to be satisfactory. But then things failed as follows
	$ nohup postmaster -i > pgserver.log 2>&1 &
	$ cat pgserver.log

IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1073152, permission=600
FATAL 1:  ShmemCreate: cannot create region

Any help on what have I failed to do? Thanks.

Richard Talman



pgsql-ports by date

Next:From: Mario SimeoneDate: 1999-10-31 09:50:44
Subject: subscribe
Previous:From: Ryan KirkpatrickDate: 1999-10-30 01:03:30
Subject: Possible invalid Pgsql-Alpha patch floating around...

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