Hi,
is there anyone using PostgreSQL on FreeBSD 7.0 starting from scratch?
I compiled 8.3.3 and wanted to run initdb in my home directory but
it fails with the error below.
--------------------------------------------
[zozo@freebsd1 ~]$ PGDATA=/home/zozo/pgd833
PATH=/home/zozo/pgc833/bin:$PATH initdb
The files belonging to this database system will be owned by user "zozo".
This user must also own the server process.
The database cluster will be initialized with locale C.
The default database encoding has accordingly been set to SQL_ASCII.
The default text search configuration will be set to "english".
creating directory /home/zozo/pgd833 ... ok
creating subdirectories ... ok
selecting default max_connections ... 10
selecting default shared_buffers/max_fsm_pages ... 400kB/20000
creating configuration files ... ok
creating template1 database in /home/zozo/pgd833/base/1 ... FATAL:
could not create shared memory segment: Cannot allocate memory
DETAIL: Failed system call was shmget(key=16, size=1785856, 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 1785856 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 50) and/or its max_connections
parameter (currently 13).
The PostgreSQL documentation contains more information about shared
memory configuration.
child process exited with exit code 1
initdb: removing data directory "/home/zozo/pgd833"
--------------------------------------------
I configured the shared memory settings in advance according to
the PostgreSQL 8.3 online docs:
$ cat /etc/sysctl.conf
...
kern.ipc.shmall=32768
kern.ipc.shmmax=134217728
kern.ipc.semmap=256
These three settings were also set with "sysctl -w ..." to take effect
immediately.
So, there is enough shared memory, especially for the downsized
configuration
determined at initdb time. Why can't I get some shared memory as a
regular user?
It's a fresh install of FreeBSD 7.0, only bison and gmake were added
from the ports
repository and the above sysctls were set in the system. No matter if I
log in from
the console or via ssh, I get the same error above. Is there a magic to
enable a user
to allocate shared memory?
Best regards,
Zoltán Böszörményi
--
----------------------------------
Zoltán Böszörményi
Cybertec Schönig & Schönig GmbH
http://www.postgresql.at/