Olá, 2010/7/17 Moisés P. Sena <[email protected]>
> Boa tarde pessoal! > > Tenho um VPS, CentOS 5.5, com 1,5 GB de RAM e Postgresql 8.4 > > alterei "shared_buffer" de 32MB para "368MB" e o mesmo nao quer mais > iniciar. > Sempre que você for modificar o parâmetro shared_buffers tenha cuidado em verificar antes os parâmetros do kernel. > > Veja o Log: > > # tail /var/lib/pgsql/pgstartup.log > --------------------- > FATAL: could not create shared memory segment: Invalid argument > DETAIL: Failed system call was shmget(key=5432001, size=395280384, 03600). > HINT: This error usually means that PostgreSQL's request for a shared > memory segment exceeded your kernel's SHMMAX parameter. You can either > reduce the request size or reconfigure the kernel with larger SHMMAX. To > reduce the request size (currently 395280384 bytes), reduce PostgreSQL's > shared_buffers parameter (currently 47104) and/or its max_connections > parameter (currently 103). > If the request size is already small, it's possible that it is less > than your kernel's SHMMIN parameter, in which case raising the request size > or reconfiguring SHMMIN is called for. > The PostgreSQL documentation contains more information about shared > memory configuration. > --------------------- > > -- > Moisés P. Sena > (Analista e desenvolvedor de sistemas WEB e mobile) > http://www.moisespsena.com > http://linux.moisespsena.com > > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > []s -- JotaComm http://jotacomm.wordpress.com
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
