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