Alvaro Herrera writes:
The problem is probably the ulimit.
The problem occurrs on i386, but not on 64bit architecture.
Tested 5 machines.
3 i386 FreeBSD 6.2
2 AMD64 FreeBSD 6.2
The 64 bit machines, with postgresql compiled from ports, worked.
One of the machines had default OS limit. The second is already a
dedicated postgresql machine so it already had OS limits increased.
So is this a bug in the i386 version of Postgresql or a limitation of the
FreeBSD i386?
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq