"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> DEBUG: Data Base System is starting up at Sun Nov 12 18:20:04 2000
> FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed: 2
> FATAL 2: Read("/usr/local/pgsql/data/pg_control") failed: 2
> Startup failed - abort
> The only compilation change I
I said:
> if (ControlFile->blcksz != BLCKSZ)
> elog(STOP, "database was initialized with BLCKSZ %d,\n\tbut the backend was
>compiled with BLCKSZ %d.\n\tlooks like you need to initdb.",
ControlFile-> blcksz, BLCKSZ);
> But I haven't stress-tested it. From your report, it sounds like
"Mitch Vincent" <[EMAIL PROTECTED]> writes:
> It wasn't PostgreSQL, it was me of course!
> Seeing as it was so long ago, I forgot that the BLCKSZ on the production
> server wasn't 32k, it was 31k (for whatever reason).. When I set the BLCKSZ
> lower than that and tried to start the backend it told
, I'm off to sit in the corner for a while...
-Mitch
- Original Message -
From: "Bruce Momjian" <[EMAIL PROTECTED]>
To: "Mitch Vincent" <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 6:47 PM
Subject: Re: [HACKERS] 7.0.2 -> 7.0.3 problem - anyo
[ Charset ISO-8859-1 unsupported, converting... ]
> I think I might have explained this wrong..
>
> Ok, both databases had a BLCKSZ of 32k before the upgrade (in 7.0.2), one
> database that I upgraded first to 7.0.3 went flawlessly, it started, I can
> do every operation fine and it's BLCKSZ is 3
;[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 6:34 PM
Subject: Re: [HACKERS] 7.0.2 -> 7.0.3 problem - anyone?
> Block size can not be changes without dump/reload. If you think it
> worked once, you are wrong. Sorry.
>
> > Cheers...
> >
> >
> > MikeA
> >
> > -Original Message-
> > From: Mitch Vincent
> > To: [EMAIL PROTECTED]
> > Sent: 11-13-00 12:57 AM
> > Subject: [HACKERS] 7.0.2 -> 7.0.3 problem
> >
> > I just upgraded to 7.0.3 and
>
> -Original Message-
> From: Mitch Vincent
> To: [EMAIL PROTECTED]
> Sent: 11-13-00 12:57 AM
> Subject: [HACKERS] 7.0.2 -> 7.0.3 problem
>
> I just upgraded to 7.0.3 and tried to start the backend like
>
> /usr/local/pgsql/bin/postmaster -B 256 -o '-S
By the way, what is pg_control and what does it do?
-Mitch
- Original Message -
From: "Michael Ansley" <[EMAIL PROTECTED]>
To: "'Mitch Vincent '" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Sunday, November 12, 2000 4:02 PM
Subje
Title: RE: [HACKERS] 7.0.2 -> 7.0.3 problem
You have to dump/initdb/reload if you change the block size. Simply recompiling is not going to work.
Cheers...
MikeA
-Original Message-
From: Mitch Vincent
To: [EMAIL PROTECTED]
Sent: 11-13-00 12:57 AM
Subject: [HACKERS] 7.
I just upgraded to 7.0.3 and tried to start the backend like
/usr/local/pgsql/bin/postmaster -B 256 -o '-S 10240 -s' -D
/usr/local/pgsql/data -i > /usr/local/pgsql/postgres.log 2>&1 &
.. as I've done with 7.0.2, it failed to start and got this in my
postgresql.log :
DEBUG: Data Base System is
11 matches
Mail list logo