Fábio Gibon - Comex System<gibon@xxxxxxxxxxxxxxxxxx> wrote:
are there how define high more than 512Mb to shared_buffer on
windows?
What happens when you set it higher than that?
Database don't start e show this message (português):
2011-04-12 12:10:22 BRT FATAL: não pôde criar segmento de memória
compartilhada: 8 (can't create a shared memory segment)
2011-04-12 12:10:22 BRT DETALHE: Falhou ao executar chamada de sistema
MapViewOfFileEx. (fail on run system call mapviewoffileex, or like this...)
Also, it would be useful to know the version of PostgreSQL, the
version of Windows, the amount of RAM on the system, etc.
Windows Server 2003 - Standard Edition - SP1 - 32bits
PostgreSQL 8.4.3
RAM 4GB
This error ocurred when I try set shared_buffers to 1GB, with 768MB work
fine.
-Kevin
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin