Hi!

I can reproduce the problem on my notebook, where I don't have any hurry
of working around the issue. The output of ipcs:

> # ipcs
> 
> ------ Shared Memory Segments --------
> key        shmid      owner      perms      bytes      nattch     status      
> 0x4e545030 0          root       600        80         1                      
>  
> 0x4e545031 32769      root       600        80         1                      
>  
> 0x4e545032 65538      root       666        80         1                      
>  
> 0x4e545033 98307      root       666        80         1                      
>  
> 0x0056a4d5 54394884   willi      660        488        1                      
>  
> 0x0056a4d6 54427653   willi      660        65536      1                      
>  
> 0x00000000 491526     willi      600        393216     2          dest        
>  
> 0x00000000 458759     willi      600        393216     2          dest        
>  
> 0x00000000 53936136   willi      600        393216     2          dest        
>  
> 0x00000000 53968905   willi      600        393216     2          dest        
>  
> 0x00000000 54001674   willi      600        393216     2          dest        
>  
> 0x00000000 54034443   willi      600        393216     2          dest        
>  
> 0x00000000 54362127   willi      600        4129584    2          dest        
>  
> 0x47505344 52101137   root       666        6728       1                      
>  
> 
> ------ Semaphore Arrays --------
> key        semid      owner      perms      nsems     
> 0x0056a4d5 43810816   willi      660        1         
> 0xcbc384f8 42598414   willi      600        1         
> 
> ------ Message Queues --------
> key        msqid      owner      perms      used-bytes   messages

and shared mem sizes:

> # grep -H shared_buffers /etc/postgresql/*/*/postgresql.conf
> /etc/postgresql/9.0/main/postgresql.conf:shared_buffers = 28MB                
>   # min 128kB
> /etc/postgresql/9.1/main/postgresql.conf:shared_buffers = 28MB                
>   # min 128kB

> # sysctl -a 2> /dev/null | grep kernel.shm
> kernel.shmmax = 33554432
> kernel.shmall = 2097152
> kernel.shmmni = 4096
> kernel.shm_rmid_forced = 0

Note that this is not the first time I'm upgrading postgres, so it's
really possible that the 28MB are an artifact from some older version.
(I'm quite sure I did not set this parameter by hand).

I now worked around the problem by commenting out the shared_memory
line, but it would be great of pg_upgradecluster would refuse to upgrade
if the upgrade is going to end up with this error message and print a
clear explanation what shared_buffer should be set to (or it should
recommend to comment out the shared_buffer value if the default is sane)

WM



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to