Обсуждение: Problem starting the postmaster

Поиск
Список
Период
Сортировка

Problem starting the postmaster

От
douggorley@shaw.ca
Дата:
Hello list,

I'm having a problem starting the postmaster.  My command line is:

/usr/pkg/bin/postmaster -D /usr/local/pgsql/data -i

The error I get is:

IpcMemoryCreate: shmget(key=5432001, size=1417216, 03600) failed: Cannot allocate memory

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 1417216 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 64) and/or
its max_connections parameter (currently 32).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.

I tried reducing the connections and buffers, but it didn't help.  There's lots of hard drive space and RAM free; any
ideas?

Thanks,

Doug Gorley | douggorley@shaw.ca