Thread: installing postgresql 8.1.4

installing postgresql 8.1.4

From
Folkert van Heusden
Date:
Hi,

I'm trying to install PostgreSQL 8.1.4 on my computer.
It is a Linux system with GCC 3.4.6 and GLIBC 2.3.6.
Things run on a pentium 4 (32bit) with plenty (2GB) of ram.
I can ./configure --disable-spinlocks with CFLAGS: -O2 -march=pentium4
-fprefetch-loop-arrays.

Now when I run: /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
I get the following errors:

postgres@muur:/tmp$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale C.

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
creating directory /usr/local/pgsql/data/pg_xlog ... ok
creating directory /usr/local/pgsql/data/pg_xlog/archive_status ... ok
creating directory /usr/local/pgsql/data/pg_clog ... ok
creating directory /usr/local/pgsql/data/pg_subtrans ... ok
creating directory /usr/local/pgsql/data/pg_twophase ... ok
creating directory /usr/local/pgsql/data/pg_multixact/members ... ok
creating directory /usr/local/pgsql/data/pg_multixact/offsets ... ok
creating directory /usr/local/pgsql/data/base ... ok
creating directory /usr/local/pgsql/data/base/1 ... ok
creating directory /usr/local/pgsql/data/pg_tblspc ... ok
selecting default max_connections ... sh: line 1:   793 Aborted                 (core dumped)
"/usr/local/pgsql/bin/postgres"-boot -x0 -F -c shared_buffers=500 -c max_connections=100 template1 <"/dev/null"
>"/dev/null"2>&1 
sh: line 1:   798 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=250-c max_connections=50 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   800 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=200-c max_connections=40 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   805 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=150-c max_connections=30 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   807 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=100-c max_connections=20 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   809 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=50-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
10
selecting default shared_buffers ... sh: line 1:   814 Aborted                 (core dumped)
"/usr/local/pgsql/bin/postgres"-boot -x0 -F -c shared_buffers=900 -c max_connections=10 template1 <"/dev/null"
>"/dev/null"2>&1 
sh: line 1:   817 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=800-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   819 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=700-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   821 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=600-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   825 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=500-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   827 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=400-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   829 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=300-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   831 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=200-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   837 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=100-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
sh: line 1:   840 Aborted                 (core dumped) "/usr/local/pgsql/bin/postgres" -boot -x0 -F -c
shared_buffers=50-c max_connections=10 template1 <"/dev/null" >"/dev/null" 2>&1 
50
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... PANIC:  too many semaphores created
child process was terminated by signal 6
initdb: removing contents of data directory "/usr/local/pgsql/data"


How can I fix this?


Folkert van Heusden

www.vanheusden.com/multitail - multitail is tail on steroids. multiple
               windows, filtering, coloring, anything you can think of
----------------------------------------------------------------------
Phone: +31-6-41278122, PGP-key: 1F28D8AE, www.vanheusden.com

Re: installing postgresql 8.1.4

From
Tom Lane
Date:
Folkert van Heusden <folkert@vanheusden.com> writes:
> I can ./configure --disable-spinlocks with CFLAGS: -O2 -march=pentium4
> -fprefetch-loop-arrays.

--disable-spinlocks is broken in 8.1.*.  It took us a long time to
notice that, because no one in their right mind uses the option.
The performance cost is enormous.

            regards, tom lane

Re: installing postgresql 8.1.4

From
Folkert van Heusden
Date:
> > I can ./configure --disable-spinlocks with CFLAGS: -O2 -march=pentium4
> > -fprefetch-loop-arrays.
> --disable-spinlocks is broken in 8.1.*.  It took us a long time to
> notice that, because no one in their right mind uses the option.
> The performance cost is enormous.

Yes, without that switch things work flawlessly.


Folkert van Heusden

--
Looking for a cheap but fast webhoster with an excellent helpdesk?
http://keetweej.vanheusden.com/redir.php?id=1001
----------------------------------------------------------------------
Phone: +31-6-41278122, PGP-key: 1F28D8AE, www.vanheusden.com