Hi

Sorry if itï¿½s the wrong place to post this. Please let me know where is the
correct place.

I'm upgrading from PostgreSQL 6.4 to 6.5.2. I compiled 6.5.2 and installed
it in an machine (that was not running 6.4) for tests but Postmaster want
not run.

Os: Sun sparc solaris 2.5
compiled with GCC 2.8.1, FLEX 2.5.4

Compilation and install runs OK! 
Initidb could not tell what username to use (I was su postgres) so I tried
initdb -u postgres and works, see bellow:

$ LD_LIBRARY_PATH=/usr/local/pgsql/lib
$ export  LD_LIBRARY_PATH
$
initdb

Can't tell what username to use.  You don't have the
USER
environment variable set to your username and didn't specify the

--username option
$ initdb -u postgres

We are initializing the database
system with username postgres (uid=1156).
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
$

I tried to start postmaster and it report an error, see bellow:

$ nohup  postmaster -i > pserver.log 2>&1 &
[1]	17192
$ ps -ef | grep
post
postgres  6006   529  0 10:22:05 pts/1    0:00 ksh
postgres 17225
6006  1 11:01:41 pts/1    0:00 grep post
[1] +  Done
nohup  postmaster -i > pserver.log 2>&1 &
$ cat
pserver.log
IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
size=1073152, permission=600
FATAL 1:  ShmemCreate: cannot create region
$ 
  
I have tried 3 times this installation and the result is the same. I
installed 6.5.2 in my house linux machine and work well.

Thank you for your attention

Roberto


Tue, 26 Oct 1999 12:25:15 -0200
Roberto Joao Lopes Garcia <roberto@mha.com.br>
Error: shmget failed
Roberto Joao Lopes Garcia <roberto@mha.com.br> writes:
> I tried to start postmaster and it report an error, see bellow:
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=1073152, permission=600
> FATAL 1:  ShmemCreate: cannot create region

As a quick hack you can start the postmaster with smaller-than-
normal -B and -N (say -B 40 -N 20).  Long term solution is to
increase your kernel's SHMMAX limit to more than 1 megabyte.

I thought we had adjusted the default -B and -N to stay just
under a meg, which is the default SHMMAX value on many kernels.
But it looks like someone chewed up some more shared memory when
I wasn't looking :-(.

			regards, tom lane

Tue, 26 Oct 1999 12:22:04 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Error: shmget failed 
> Roberto Joao Lopes Garcia <roberto@mha.com.br> writes:
> > I tried to start postmaster and it report an error, see bellow:
> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> > size=1073152, permission=600
> > FATAL 1:  ShmemCreate: cannot create region
> 
> As a quick hack you can start the postmaster with smaller-than-
> normal -B and -N (say -B 40 -N 20).  Long term solution is to
> increase your kernel's SHMMAX limit to more than 1 megabyte.
> 
> I thought we had adjusted the default -B and -N to stay just
> under a meg, which is the default SHMMAX value on many kernels.
> But it looks like someone chewed up some more shared memory when
> I wasn't looking :-(.

7.0 backend will point them to FAQ on such errors.

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 26 Oct 1999 12:51:11 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Error: shmget failed
Hi

To change maximun Shared Memory segment size in my Sparc Solaris 2.5, I
have to add the following line into /etc/system file and then reboot the
system

	set  shmsys:shminfo_shmmax=268435456

It solved the problem. 

Also, Solaris ANSWER BOOK recomends to change the follow. Please note that
I do not test the lines bellow in my system, only the above change in
/etc/system solved the problem.

	set  semsys:seminfo_semmap=250
	set  semsys:seminfo_semmni=500
	set
semsys:seminfo_semmns=500
	set  semsys:seminfo_semmsl=500
	set
semsys:seminfo_semmnu=500
	set  semsys:seminfo_semume=100
	set
semsys:seminfo_shmmin=200
	set  semsys:seminfo_shmmni=200
	set
semsys:seminfo_shmseg=200

To see the actual system sets one can use the command sysdef that, in my
system produce the follow:

#sysdef
	.
	.
	. ...
*
* IPC Semaphores
*
    10	entries in semaphore map (SEMMAP)
    10
semaphore identifiers (SEMMNI)
    60	semaphores in system (SEMMNS)
    30
undo structures in system (SEMMNU)
    25	max semaphores per id (SEMMSL)

 10	max operations per semop call (SEMOPM)
    10	max undo entries per
process (SEMUME)
 32767	semaphore maximum value (SEMVMX)
 16384	adjust on
exit max value (SEMAEM)
*
* IPC Shared Memory
*
268435456	max shared memory
segment size (SHMMAX)
     1	min shared memory segment size (SHMMIN)
   100
shared memory identifiers (SHMMNI)
     6	max attached shm segments per
process (SHMSEG)
*
* Time Sharing Scheduler Tunables
*
60	maximum time
sharing user priority (TSMAXUPRI)
SYS	system class name (SYS_NAME)
# 

Please read the man pages before execute this command or the changes showed
above.

Thank you for you help

Roberto

At 12:51 26/10/99 -0400, you wrote:
>> Roberto Joao Lopes Garcia <roberto@mha.com.br> writes:
>> > I tried to start postmaster and it report an error, see bellow:
>> > IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
>> > size=1073152, permission=600
>> > FATAL 1:  ShmemCreate: cannot create region
>> 
>> As a quick hack you can start the postmaster with smaller-than-
>> normal -B and -N (say -B 40 -N 20).  Long term solution is to
>> increase your kernel's SHMMAX limit to more than 1 megabyte.
>> 
>> I thought we had adjusted the default -B and -N to stay just
>> under a meg, which is the default SHMMAX value on many kernels.
>> But it looks like someone chewed up some more shared memory when
>> I wasn't looking :-(.
>
>7.0 backend will point them to FAQ on such errors.
>
>-- 
>  Bruce Momjian                        |  http://www.op.net/~candle
>  maillist@candle.pha.pa.us            |  (610) 853-3000
>  +  If your life is a hard drive,     |  830 Blythe Avenue
>  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
>
>************
>
>


Wed, 27 Oct 1999 10:20:57 -0200
Roberto Joao Lopes Garcia <roberto@mha.com.br>
Re: [HACKERS] Error: shmget failed - SOLVED!