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: