Re: initdb fails on ultra2. followup - Mailing list pgsql-bugs

From David Walker
Subject Re: initdb fails on ultra2. followup
Date
Msg-id 20050513160900.A9C1A117@daahman.cosmicfires.com
Whole thread Raw
List pgsql-bugs
On a Sun ultra2 sparc64 with 200mhz cpu initdb hangs.

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

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data ... ok
creating directory /usr/local/pgsql/data/global ... ok
...
selecting default max_connections ... 100
selecting default shared_buffers ... 1000
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ...
** initdb hangs here

I have heard ultra sparc 200mhz cpus have a bug that can cause processes to
hang. I have run postgresql 8.0.n on a similar machine with 250mhz cpus. I
suspect this is the problem here. Anyone have experience with this?


After killing initdb with ^C postgres is still running
 PID USERNAME PRI NICE   SIZE    RES STATE    TIME   WCPU    CPU COMMAND
 23061 pgsql     -8    0 30264K  8984K piperd   0:10  0.00%  0.00% postgres

$ uname -a
FreeBSD ultra2 5.4-RELEASE FreeBSD 5.4-RELEASE #0: Sun May  8 22:21:34 UTC
2005    root@binkley.cse.buffalo.edu:/usr/obj/usr/src/sys/GENERIC  sparc64

$ gcc -v
Using built-in specs.
Configured with: FreeBSD/sparc64 system compiler
Thread model: posix
gcc version 3.4.2 [FreeBSD] 20040728


PostgreSQL config.status 8.0.3
configured by ./configure, generated by GNU Autoconf 2.53,
  with options \"'--with-libraries=/usr/local/lib'
'--with-includes=/usr/local/include' '--with-docdir=/usr/local/share/doc/postgr
esql' '--with-openssl'
'--disable-nls' '--enable-thread-safety' '--prefix=/usr/local'
'sparc64-portbld-freebsd5.4' 'LDFLAGS= -rpath=/usr/lib:/usr/local/lib
-L/usr/local/lib' 'CFLAGS=-O -pipe' 'CPPFLAGS=-I/usr/local/include'
'host_alias=sparc64-portbld-freebsd5.4' 'build_alias=sparc64-portbld-freebsd5.4
' 'target_alias=sparc64-portbld-freebsd5.4'
'CC=cc'\"

David
--
http://howto.mainstreamlinux.com

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Fwd: Bug#308535: postgresql-client: [psql] manual page does not document ~/.pgpass file
Next
From: Tom Lane
Date:
Subject: Re: Fwd: Bug#308513: postgresql-client: [manual] createuser(1) Add example '...WITH PASSWORD'