RE: 7.0.2 -> 7.0.3 problem - Mailing list pgsql-hackers

From Michael Ansley
Subject RE: 7.0.2 -> 7.0.3 problem
Date
Msg-id 7F124BC48D56D411812500D0B74725140614E8@fileserver002.intecsystems.co.uk
Whole thread Raw
In response to 7.0.2 -> 7.0.3 problem  ("Mitch Vincent" <mitch@venux.net>)
List pgsql-hackers
<p><font size="2">You have to dump/initdb/reload if you change the block size.  Simply recompiling is not going to
work.</font><p><fontsize="2">Cheers...</font><br /><p><font size="2">MikeA</font><p><font size="2">-----Original
Message-----</font><br/><font size="2">From: Mitch Vincent</font><br /><font size="2">To:
pgsql-hackers@postgresql.org</font><br/><font size="2">Sent: 11-13-00 12:57 AM</font><br /><font size="2">Subject:
[HACKERS]7.0.2 -> 7.0.3 problem</font><p><font size="2">I just upgraded to 7.0.3 and tried to start the backend
like</font><p><fontsize="2">/usr/local/pgsql/bin/postmaster -B 256 -o '-S 10240 -s' -D</font><br /><font
size="2">/usr/local/pgsql/data-i > /usr/local/pgsql/postgres.log 2>&1 &</font><p><font size="2">.. as
I'vedone with 7.0.2, it failed to start and got this in my</font><br /><font size="2">postgresql.log :</font><p><font
size="2">DEBUG: Data Base System is starting up at Sun Nov 12 18:20:04 2000</font><br /><font size="2">FATAL 2: 
Read("/usr/local/pgsql/data/pg_control")failed: 2</font><br /><font size="2">FATAL 2: 
Read("/usr/local/pgsql/data/pg_control")failed: 2</font><br /><font size="2">Startup failed - abort</font><p><font
size="2">Theonly compilation change I made was to increase BLCKSZ to 32k (which</font><br /><font
size="2">has</font><br/><font size="2">been running in a production 7.0.2 environment for quite some
time).</font><p><fontsize="2">So what's up? Just to make sure I made the permissions 777 all the way</font><br /><font
size="2">down</font><br/><font size="2">to pg_control but it had no effect.</font><p><font size="2">----</font><p><font
size="2">Hmm,I just re-installed 7.0.2 and I get the same error with it -- not</font><br /><font
size="2">good.</font><p><fontsize="2">My development server, which is virtually the same, did fine when I</font><br
/><fontsize="2">installed 7.0.3 so I'm guessing it's not a problem across the board..</font><p><font size="2">I also
noticein the log that it's</font><br /><font size="2">Read("/usr/local/pgsql/data/pg_control")</font><br /><font
size="2">that'sfailing and when I move pg_control out of the way, it's Open()</font><br /><font size="2">that</font><br
/><fontsize="2">fails..</font><p><font size="2">I did nothing but stop the postmaster, compile and install 7.0.3
and</font><br/><font size="2">start</font><br /><font size="2">the postmaster. then compiled and installed 7.0.2 again
andall of the</font><br /><font size="2">sudden the 7.0.2 or 7.0.3 backend doesn't start -- it makes no
sense.</font><p><fontsize="2">As always, any help is appreciated. Thanks!</font><p><font size="2">-Mitch</font> 

pgsql-hackers by date:

Previous
From: "Mitch Vincent"
Date:
Subject: 7.0.2 -> 7.0.3 problem
Next
From: "Mitch Vincent"
Date:
Subject: Re: 7.0.2 -> 7.0.3 problem