Thread: postgresql 7.0 problems on NT (initdb failure, Invalid NextTransactionId/NextOID)
postgresql 7.0 problems on NT (initdb failure, Invalid NextTransactionId/NextOID)
From
"Garfield Hamilton"
Date:
Platform: NT Server 4.0 SP 5./ Cygwin 20.1 (dll upgrade) / cywin32ipc 1.03 (binaries)/ Andy Piper tools. Friends, I am having quite a problem getting postgresql to work on NT. I've read many of the posts on NT problems, looked in the archives, documentation, sourcefiles, played around and I am stuck. I cannot get initdb to complete successfully. initdb outputs the following in debug mode: ( I added a couple of statements to get a better view of what was happening ) Creating view pg_user. DEBUG: Data Base System is starting up at Mon Mar 06 20:25:55 2000 DEBUG: Data Base System was shut down at Mon Mar 06 20:25:55 2000 DEBUG: CheckPoint record at (0, 104) DEBUG: CheckPoint nextXid, nextOid = (1024, 4952582) DEBUG: FirstTransactionId, BootstrapObjectIdData= (514, 16384) DEBUG: Redo record at (0, 104); Undo record at (0, 0) DEBUG: NextTransactionId: 1539; NextOid: 0 DEBUG: Invalid NextTransactionId/NextOid DEBUG: Data Base System is in production state at Mon Mar 06 20:25:55 2000 DEBUG: Data Base System shutting down at Mon Mar 06 20:25:55 2000 DEBUG: Data Base System shut down at Mon Mar 06 20:25:55 2000 Creating view pg_rules. DEBUG: Data Base System is starting up at Mon Mar 06 20:25:55 2000 DEBUG: Data Base System was shut down at Mon Mar 06 20:25:55 2000 DEBUG: CheckPoint record at (0, 152) DEBUG: CheckPoint nextXid, nextOid = (1024, 4952582) DEBUG: FirstTransactionId, BootstrapObjectIdData= (514, 16384) FATAL 2: ReadRecord: read(logfile 0 seg 0 off 0) failed: 2 FATAL 2: ReadRecord: read(logfile 0 seg 0 off 0) failed: 2 initdb failed. Removing //d/usr/local/pgsql/data. Removing temp file /tmp/initdb.7743. ------------------------------------- Any ideas on what is not working properly? If there are any binaries for NT that would just short circuit any build problems I might have injected (I am new to cygwin) then I would really appreciate that as well. Thanks in advance. Garfield -------------------- Garfield Hamilton Internet Strategist Asset Foundry, Inc. 211 S. Federal Hwy Suite 14 Boynton Beach, FL 33435 Tel. 561-733-9366 Fax. 561-733-3277