Pessoal,
tenho um HP proliant com 2 processadores quad-core, 16 GB de Ram,
rodando FreeBSD 7.1-RELEASE-p4 FreeBSD 7.1-RELEASE-p4 #0: Wed Apr 1
15:50:37 BRT 2009 :/usr/obj/usr/src/sys/GAMA-KERNEL amd64 e
postgresql 8.3.5.
Meu shmmax no SO é :
kern.ipc.shmall: 2621440 # 10 GB/4096
kern.ipc.shmseg: 256
kern.ipc.shmmni: 192
kern.ipc.shmmin: 1
kern.ipc.shmmax: 10737418240 # 10 GB
Estou tentando startar um banco com 5GB de shared_buffers, mas está
estranho ... o postmaster é gerado mas eu não consigo logar no banco,
nem mesmo pelo psql.
postg...@gama >ll *.pid
-rw------- 1 postgres wheel - 55 Apr 17 11:55 postmaster.pid
postg...@gama >../bin/psql faturamento
psql: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5431"?
Quando tento parar o banco:
postg...@gama >../bin/pg_ctl -D /dados/bancos/pg835_fat/data stop
pg_ctl: could not send stop signal (PID: 97959): No such process
Só que quando inicio o banco com 2GB de shared_buffers, um erro é gerado
no log e o postmaster não é criado.
Log :
DETAIL: Failed system call was shmget(key=5431001, size=2199420928,
03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space
. To reduce the request size (currently 2199420928 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 262144) an
d/or its max_connections parameter (currently 53).
The PostgreSQL documentation contains more information about
shared memory configuration.
Só consigo iniciar o banco com 1GB de shared_buffers.
Vcs podem me ajudar nesta tarefa ??? Gostaria que o banco iniciasse com
5GB.
Minha configuração do kernel do SO está correta ??
Obrigado
André
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
