Postgres 7 on Alpha
Hi!
I have an old Alpha system which I use as a database server. I have
successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7
to solve some problems. I downloaded the source of 7.0.2 as I could not
find any RPM of Postgres 7 for Alpha.
I compiled and installed it without a glitch but I can not initialize the
database. I get the following error:
bash$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
This database system will be initialized with username "postgres".
This user will own all the data files and must also own the server
process.
Creating database system directory /usr/local/pgsql/data
Creating database system directory /usr/local/pgsql/data/base
Creating database XLOG directory /usr/local/pgsql/data/pg_xlog
Creating template database in /usr/local/pgsql/data/base/template1
FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
initdb failed.
Removing /usr/local/pgsql/data.
Removing temp file /tmp/initdb.26953.
I run Red Hat Linux release 6.2 (Zoot), Kernel 2.2.14-6.0 on an alpha.
What do I do now? What is a spinlock?
/Roger
Roger Wernersson <roger.wernersson@mindark.com> writes:
I have an old Alpha system which I use as a database server. I have
successufully run Postgres 6.5 on it but needed to upgrade to Postgres 7
to solve some problems. I downloaded the source of 7.0.2 as I could not
find any RPM of Postgres 7 for Alpha.
FATAL: s_lock(20306f80) at spin.c:116, stuck spinlock. Aborting.
According to my notes, this happens if you compile with -O2 on at least
some versions of Alpha egcs. Try -O0 instead. There are still some
glitches exposed by the regress tests, though, particularly in date/time
handling. Now that we have an Alpha box available to the project, the
problems in this port should get cleaned up for 7.1. (Given a favorable
tailwind or 25 hours in the day, that is ;-))
regards, tom lane
Roger Wernersson wrote:
I run Red Hat Linux release 6.2 (Zoot), Kernel 2.2.14-6.0 on an alpha.
What do I do now? What is a spinlock?
Apply Ryan Kirkpatrick's patches for PostgreSQL 7.0.x, available at
http://www.rkirkpat.net/software/#linux-alpha and rebuild.
You will need to start with a fresh tarball extraction, pre-configure,
then apply the patches according to Ryan's instructions.
The RPMset does this automatically if you are building on an alpha.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11