check-check.log
text/plain
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "gsmith".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
fixing permissions on existing directory /Users/gsmith/pgwork/data/checksum ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
creating configuration files ... ok
creating template1 database in /Users/gsmith/pgwork/data/checksum/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
postgres -D /Users/gsmith/pgwork/data/checksum
or
pg_ctl -D /Users/gsmith/pgwork/data/checksum -l logfile start
Data page checksums: disabled
waiting for server to start.... done
server started
LOG: Checking page header in block 2 of relation base/12292/12046
LOG: Checking page header in block 0 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12046
LOG: Checking page header in block 4 of relation base/12292/12046
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: Checking page header in block 0 of relation global/12291
LOG: Checking page header in block 1 of relation global/12291
LOG: Checking page header in block 0 of relation global/12173
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
creating tables...
10000 tuples done.
20000 tuples done.
30000 tuples done.
40000 tuples done.
50000 tuples done.
60000 tuples done.
70000 tuples done.
80000 tuples done.
90000 tuples done.
100000 tuples done.
set primary key...
vacuum...done.
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started
LOG: Checking page header in block 2 of relation base/12292/12046
LOG: Checking page header in block 0 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12046
LOG: Checking page header in block 4 of relation base/12292/12046
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: Checking page header in block 0 of relation global/12291
LOG: Checking page header in block 1 of relation global/12291
LOG: Checking page header in block 0 of relation global/12173
Reading byte 14 within file /Users/gsmith/pgwork/data/checksum/base/16384/16397
Current byte= 128 / $80
Modified byte= 129 / $81
File modified successfully
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started
LOG: Checking page header in block 2 of relation base/12292/12046
LOG: Checking page header in block 0 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12081
LOG: Checking page header in block 1 of relation base/12292/12046
LOG: Checking page header in block 4 of relation base/12292/12046
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: Checking page header in block 0 of relation global/12291
LOG: Checking page header in block 1 of relation global/12291
LOG: Checking page header in block 0 of relation global/12173
sum
-----
0
(1 row)
waiting for server to shut down.... done
server stopped
The files belonging to this database system will be owned by user "gsmith".
This user must also own the server process.
The database cluster will be initialized with locale "en_US.UTF-8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".
fixing permissions on existing directory /Users/gsmith/pgwork/data/checksum ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
creating configuration files ... ok
creating template1 database in /Users/gsmith/pgwork/data/checksum/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
syncing data to disk ... ok
WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.
Success. You can now start the database server using:
postgres -D /Users/gsmith/pgwork/data/checksum
or
pg_ctl -D /Users/gsmith/pgwork/data/checksum -l logfile start
Data page checksums: enabled
waiting for server to start.... done
server started
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: page verification done block 19, calculated checksum 58162 expected 58162
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: page verification done block 2, calculated checksum 24458 expected 24458
LOG: Checking page header in block 0 of relation global/12291
LOG: page verification done block 0, calculated checksum 33798 expected 33798
LOG: Checking page header in block 1 of relation global/12291
LOG: page verification done block 1, calculated checksum 6275 expected 6275
LOG: Checking page header in block 0 of relation global/12173
LOG: page verification done block 0, calculated checksum 33798 expected 33798
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping
creating tables...
10000 tuples done.
20000 tuples done.
30000 tuples done.
40000 tuples done.
50000 tuples done.
60000 tuples done.
70000 tuples done.
80000 tuples done.
90000 tuples done.
100000 tuples done.
set primary key...
vacuum...done.
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: page verification done block 19, calculated checksum 58162 expected 58162
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: page verification done block 2, calculated checksum 24458 expected 24458
LOG: Checking page header in block 0 of relation global/12291
LOG: page verification done block 0, calculated checksum 33798 expected 33798
LOG: Checking page header in block 1 of relation global/12291
LOG: page verification done block 1, calculated checksum 22810 expected 22810
LOG: Checking page header in block 0 of relation global/12173
LOG: page verification done block 0, calculated checksum 33798 expected 33798
Reading byte 14 within file /Users/gsmith/pgwork/data/checksum/base/16384/16397
Current byte= 128 / $80
Modified byte= 129 / $81
File modified successfully
waiting for server to shut down.... done
server stopped
waiting for server to start.... done
server started
LOG: Checking page header in block 19 of relation base/12292/12043
LOG: page verification done block 19, calculated checksum 58162 expected 58162
LOG: Checking page header in block 2 of relation base/12292/12078
LOG: page verification done block 2, calculated checksum 24458 expected 24458
LOG: Checking page header in block 0 of relation global/12291
LOG: page verification done block 0, calculated checksum 33798 expected 33798
LOG: Checking page header in block 1 of relation global/12291
LOG: page verification done block 1, calculated checksum 22810 expected 22810
LOG: Checking page header in block 0 of relation global/12173
LOG: page verification done block 0, calculated checksum 33798 expected 33798
WARNING: page verification failed, calculated checksum 5900 but expected 9227
ERROR: invalid page header in block 0 of relation base/16384/16397