I have tried for days to get postgresql working on OpenBSD on an old sparc32
box which I use to learn OpenBSD and Postgresql. I'll try to describe the
steps I went through as precise as possible.
First, I bought a sparc station 2 - an old box in a good condition, I've run
debian gnu/linux on it for a while and now I'm trying OpenBSD 3.1. The thing
has a 40 MHz sparc32 cpu, 2 scsi disks, a cg6 framebuffer and 64 megs of
This are the packages ("ports") I installed on it:
bash-2.05a GNU Bourne Again Shell
libiconv-1.7 character set conversion library
gettext-0.10.40 GNU gettext
vim-6.1-no_x11 vi clone, many additional features
samba-2.2.3a SMB and CIFS client and server for UNIX
bzip2-1.0.2 block-sorting file compressor, unencumbered
squid-2.5.PRE5 WWW and FTP proxy cache and accelerator
bind-9.2.0 Berkeley Internet Name Daemon
iodbc-2.50.3 ODBC 2.x driver manager
bison-1.32 GNU parser generator
xfstt-1.1 TrueType font server for X11
gmake-3.79.1 GNU make
tcl-8.3.4 Tool Command Language
tcl-8.0.5 Tool Command Language
I didn't have any problems to get other things working and the system is
stable so I think a part failure is highly unlikely.
Then, I downloaded the OpenBSD ports tree, which as you may know, is merely a
collection of Makefiles which help you to download and compile a source tree
of a program, make a package out of it and install that. OpenBSD 3.1 has a
port for 7.1.3. The "make && make install" went fine and the package
installed with no errors.
Then, according to the openBSD Readme files, I added a new user "postgresql"
# useradd -c "PostgreSQL Admin User" -g =uid -m -d /var/postgresql \
-s /bin/sh postgresql
Then, upon creating a new database,The proces coredumps (where? I cannot find
the core file back!). I also asked it to output extra debugging info.
# su - postgresql
# initdb -D /var/postgresql/data -d 2>initdb-errors >initdb-output
These 2 files are in attachment. I also tried a pre-built binary package of
Postgresql 7.1.3 which gave exactly the same error.
7.1.3 failed to initialise so I checked out wether it really was the latest
version. I downloaded 7.2.2 from your website and tried to build that.
To make a long story short, the build failed. I extracted the tarbal somewhere
and ran the following commands:
# ./configure --prefix=/usr/local/postgresql-7.2.2 --enable-multibyte
--enable-odbc --with-unixodbc >configure-output 2>configure-errors
This went OK and the errors file was empty. Those
# gmake >gmake-output 2>gmake-errors
This took about an hour and a half, the results are in attachment.
This writer has a writer block and hopes for the postgresql crew to finish the
story. A final note: I also tried installing OpenBSD 3.1 for x86 and using
the port (7.1.3). Building, installing and initialising went without a hitch,
so it must be something sparc32-specific.
Frank Van Damme
jabber (=IM): yalu(at)jabber(dot)com
pgsql-bugs by date
|Next:||From: Sean Chittenden||Date: 2002-09-29 00:21:43|
|Subject: Re: SET autocommit begins transaction?|
|Previous:||From: Bruce Momjian||Date: 2002-09-28 17:52:56|
|Subject: Re: Bug #788: configure script confused by gcc-3.2|