[mitsu-ko@localhost postgresql-9.2.3]$ sh replication_test.sh #### initial settings #### mkdir: ディレクトリ `arc' を作成できません: ファイルが存在します Postgresql is "/home/mitsu-ko/postgresql-9.2.3/bin/postgres" postgres: どのプロセスもkillされませんでした The files belonging to this database system will be owned by user "mitsu-ko". This user must also own the server process. The database cluster will be initialized with locale "ja_JP.utf8". The default database encoding has accordingly been set to "UTF8". initdb: could not find suitable text search configuration for locale "ja_JP.utf8" The default text search configuration will be set to "simple". creating directory Master ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 32MB creating configuration files ... ok creating template1 database in Master/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 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 Master or pg_ctl -D Master -l logfile start #### Startup master #### waiting for server to start....[Master] 2013-04-22 03:15:57 EDTLOG: 00000: database system was shut down at 2013-04-22 03:15:57 EDT [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6200 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: checkpoint record is at 0/1803B30 [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6369 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: redo record is at 0/1803B30; shutdown TRUE [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6404 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: next transaction ID: 0/1808; next OID: 12871 [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6408 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6411 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 03:15:57 EDTLOCATION: StartupXLOG, xlog.c:6414 [Master] 2013-04-22 03:15:57 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 03:15:57 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 03:15:57 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 03:15:57 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Master] 2013-04-22 03:15:57 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 03:15:57 EDTLOCATION: reaper, postmaster.c:2408 done server started #### basebackup #### [Master] 2013-04-22 03:15:58 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 03:15:58 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:15:58 EDTDEBUG: 00000: received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' NOWAIT [Master] 2013-04-22 03:15:58 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:15:58 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:15:58 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:15:58 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:15:58 EDTLOG: 00000: checkpoint starting: force wait xlog [Master] 2013-04-22 03:15:58 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:15:58 EDTDEBUG: 00000: archived transaction log file "000000010000000000000001" [Master] 2013-04-22 03:15:58 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: checkpoint sync: number=1 file=global/12619 time=6.121 msec [Master] 2013-04-22 03:15:59 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: checkpoint sync: number=2 file=global/12617 time=1.081 msec [Master] 2013-04-22 03:15:59 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: checkpoint sync: number=3 file=global/12617_vm time=1.133 msec [Master] 2013-04-22 03:15:59 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: checkpoint sync: number=4 file=global/12620 time=1.165 msec [Master] 2013-04-22 03:15:59 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:15:59 EDTLOG: 00000: checkpoint complete: wrote 4 buffers (0.1%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.302 s, sync=0.009 s, total=0.530 s; sync files=4, longest=0.006 s, average=0.002 s [Master] 2013-04-22 03:15:59 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 03:15:59 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/2000000 [Master] 2013-04-22 03:15:59 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: standby "pg_basebackup" has now caught up with primary [Master] 2013-04-22 03:15:59 EDTLOCATION: WalSndLoop, walsender.c:797 [Master] 2013-04-22 03:15:59 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:15:59 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:15:59 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:15:59 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:15:59 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: archived transaction log file "000000010000000000000002.00000020.backup" [Master] 2013-04-22 03:15:59 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:15:59 EDTDEBUG: 00000: archived transaction log file "000000010000000000000002" [Master] 2013-04-22 03:15:59 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:15:59 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=0.000 s, total=0.184 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 03:15:59 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 #### Startup standby #### server starting #### Sleep for 5 seconds #### [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 03:15:59 EDT [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6224 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: creating missing WAL directory "pg_xlog/archive_status" [Standby] 2013-04-22 03:16:05 EDTLOCATION: ValidateXLOGDirectoryStructure, xlog.c:3697 cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: entering standby mode [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6290 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: restored log file "000000010000000000000002" from archive [Standby] 2013-04-22 03:16:05 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:16:05 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: checkpoint record is at 0/2000058 [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6329 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: redo record is at 0/2000020; shutdown FALSE [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6404 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6408 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6411 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6414 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 03:16:05 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Standby] 2013-04-22 03:16:05 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: initializing for hot standby [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6580 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: redo starts at 0/2000020 [Standby] 2013-04-22 03:16:05 EDTLOCATION: StartupXLOG, xlog.c:6712 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: recovery snapshots are now enabled [Standby] 2013-04-22 03:16:05 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Standby] 2013-04-22 03:16:05 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Standby] 2013-04-22 03:16:05 EDTDEBUG: 00000: end of backup reached [Standby] 2013-04-22 03:16:05 EDTCONTEXT: xlog redo backup end: 0/2000020 [Standby] 2013-04-22 03:16:05 EDTLOCATION: xlog_redo, xlog.c:8950 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: consistent recovery state reached at 0/20000E0 [Standby] 2013-04-22 03:16:05 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7249 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: database system is ready to accept read only connections [Standby] 2013-04-22 03:16:05 EDTLOCATION: sigusr1_handler, postmaster.c:4272 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:05 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 03:16:05 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:16:05 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/3000000 [Master] 2013-04-22 03:16:05 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:16:05 EDTDEBUG: 00000: standby "walreceiver" has now caught up with primary [Master] 2013-04-22 03:16:05 EDTLOCATION: WalSndLoop, walsender.c:797 [Standby] 2013-04-22 03:16:05 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 03:16:05 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 #### Shutdown standby #### waiting for server to shut down....[Standby] 2013-04-22 03:16:10 EDTLOG: 00000: received fast shutdown request [Standby] 2013-04-22 03:16:10 EDTLOCATION: pmdie, postmaster.c:2187 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: aborting any active transactions [Standby] 2013-04-22 03:16:10 EDTLOCATION: pmdie, postmaster.c:2211 [Standby] 2013-04-22 03:16:10 EDTFATAL: 57P01: terminating walreceiver process due to administrator command [Standby] 2013-04-22 03:16:10 EDTLOCATION: ProcessWalRcvInterrupts, walreceiver.c:150 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: shutting down [Standby] 2013-04-22 03:16:10 EDTLOCATION: ShutdownXLOG, xlog.c:7672 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: restartpoint starting: shutdown immediate [Standby] 2013-04-22 03:16:10 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: restartpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.001 s; sync files=0, longest=0.000 s, average=0.000 s [Standby] 2013-04-22 03:16:10 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: recovery restart point at 0/3000020 [Standby] 2013-04-22 03:16:10 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:16:10 EDTLOG: 00000: database system is shut down [Standby] 2013-04-22 03:16:10 EDTLOCATION: ShutdownXLOG, xlog.c:7694 done server stopped PG_VERSION base pg_clog pg_ident.conf pg_notify pg_snapshots pg_subtrans pg_twophase postgresql.conf recovery.conf backup_label.old global pg_hba.conf pg_multixact pg_serial pg_stat_tmp pg_tblspc pg_xlog postmaster.opts #### Shutdown master in immediate mode #### [Master] 2013-04-22 03:16:11 EDTLOG: 00000: received immediate shutdown request [Master] 2013-04-22 03:16:11 EDTLOCATION: pmdie, postmaster.c:2240 [Master] 2013-04-22 03:16:11 EDTWARNING: 57P02: terminating connection because of crash of another server process [Master] 2013-04-22 03:16:11 EDTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. [Master] 2013-04-22 03:16:11 EDTHINT: In a moment you should be able to reconnect to the database and repeat your command. [Master] 2013-04-22 03:16:11 EDTLOCATION: quickdie, postgres.c:2546 waiting for server to shut down... done server stopped #### Sleep for 5 seconds #### #### Starting master as a standby, and next promote#### waiting for server to start....[Master] 2013-04-22 03:16:16 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 03:15:59 EDT [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6224 cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:16 EDTLOG: 00000: entering standby mode [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6290 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: checkpoint record is at 0/3000058 [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6369 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: redo record is at 0/3000020; shutdown FALSE [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6404 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6408 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6411 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6414 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 03:16:16 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Master] 2013-04-22 03:16:16 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: initializing for hot standby [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6580 [Master] 2013-04-22 03:16:16 EDTLOG: 00000: consistent recovery state reached at 0/30000B8 [Master] 2013-04-22 03:16:16 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7249 [Master] 2013-04-22 03:16:16 EDTLOG: 00000: redo starts at 0/3000020 [Master] 2013-04-22 03:16:16 EDTLOCATION: StartupXLOG, xlog.c:6712 [Master] 2013-04-22 03:16:16 EDTDEBUG: 00000: recovery snapshots are now enabled [Master] 2013-04-22 03:16:16 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Master] 2013-04-22 03:16:16 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Master] 2013-04-22 03:16:16 EDTLOG: 00000: record with zero length at 0/30000B8 [Master] 2013-04-22 03:16:16 EDTLOCATION: ReadRecord, xlog.c:4050 [Master] 2013-04-22 03:16:16 EDTLOG: 00000: database system is ready to accept read only connections [Master] 2013-04-22 03:16:16 EDTLOCATION: sigusr1_handler, postmaster.c:4272 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:16 EDTFATAL: XX000: could not connect to the primary server: could not connect to server: 接続を拒否されました Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 65433? could not connect to server: 接続を拒否されました Is the server running on host "localhost" (127.0.0.1) and accepting TCP/IP connections on port 65433? [Master] 2013-04-22 03:16:16 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:102 done server started server promoting #### Sleep for 5 seconds #### cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:17 EDTDEBUG: 00000: record with zero length at 0/30000B8 [Master] 2013-04-22 03:16:17 EDTLOCATION: ReadRecord, xlog.c:4050 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:17 EDTLOG: 00000: received promote request [Master] 2013-04-22 03:16:17 EDTLOCATION: CheckForStandbyTrigger, xlog.c:10667 [Master] 2013-04-22 03:16:17 EDTLOG: 00000: redo done at 0/3000058 [Master] 2013-04-22 03:16:17 EDTLOCATION: StartupXLOG, xlog.c:6849 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:17 EDTLOG: 00000: selected new timeline ID: 2 [Master] 2013-04-22 03:16:17 EDTLOCATION: StartupXLOG, xlog.c:6955 cp: cannot stat `../arc/00000001.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:17 EDTLOG: 00000: archive recovery complete [Master] 2013-04-22 03:16:17 EDTLOCATION: exitArchiveRecovery, xlog.c:5793 [Master] 2013-04-22 03:16:17 EDTLOG: 00000: checkpoint starting: end-of-recovery immediate wait [Master] 2013-04-22 03:16:17 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:17 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=0.000 s, total=0.019 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 03:16:17 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:17 EDTDEBUG: 00000: resetting unlogged relations: cleanup 0 init 1 [Master] 2013-04-22 03:16:17 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 03:16:17 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 03:16:17 EDTLOCATION: reaper, postmaster.c:2408 [Master] 2013-04-22 03:16:17 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 03:16:17 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Master] 2013-04-22 03:16:17 EDTDEBUG: 00000: archived transaction log file "000000010000000000000003" [Master] 2013-04-22 03:16:17 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:17 EDTDEBUG: 00000: archived transaction log file "00000002.history" [Master] 2013-04-22 03:16:17 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:22 EDTNOTICE: 00000: table "pgbench_branches" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_branches" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTNOTICE: 00000: table "pgbench_tellers" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_tellers" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTNOTICE: 00000: table "pgbench_accounts" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_accounts" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTNOTICE: 00000: table "pgbench_history" does not exist, skipping [Master] 2013-04-22 03:16:22 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 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. 110000 tuples done. 120000 tuples done. 130000 tuples done. 140000 tuples done. 150000 tuples done. 160000 tuples done. [Master] 2013-04-22 03:16:23 EDTLOG: 00000: checkpoints are occurring too frequently (6 seconds apart) [Master] 2013-04-22 03:16:23 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:23 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:23 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:23 EDTLOCATION: LogCheckpointStart, xlog.c:7714 170000 tuples done. 180000 tuples done. [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: archived transaction log file "000000020000000000000003" [Master] 2013-04-22 03:16:23 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 190000 tuples done. 200000 tuples done. 210000 tuples done. [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=1.910 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12741 time=0.470 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12639 time=0.242 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12616 time=0.296 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/24579 time=1.253 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 220000 tuples done. [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24579_fsm time=0.723 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=7 file=global/12763 time=0.884 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=8 file=global/12763_vm time=0.924 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/24588 time=239.456 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/12613 time=0.415 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=11 file=global/12617 time=0.458 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12636 time=0.468 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12636_fsm time=0.390 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=14 file=global/12765 time=1.469 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=15 file=global/12766 time=1.332 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=16 file=base/12870/12738 time=0.523 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12740 time=0.515 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/12615 time=0.403 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/24576 time=1.321 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/12627 time=0.423 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12638 time=0.360 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12628 time=0.275 msec [Master] 2013-04-22 03:16:23 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:23 EDTLOG: 00000: checkpoint complete: wrote 27 buffers (0.7%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.101 s, sync=0.255 s, total=0.365 s; sync files=22, longest=0.239 s, average=0.011 s [Master] 2013-04-22 03:16:23 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 230000 tuples done. 240000 tuples done. 250000 tuples done. 260000 tuples done. 270000 tuples done. 280000 tuples done. 290000 tuples done. 300000 tuples done. 310000 tuples done. [Master] 2013-04-22 03:16:23 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:23 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:23 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:23 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:23 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:23 EDTDEBUG: 00000: archived transaction log file "000000020000000000000004" [Master] 2013-04-22 03:16:23 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 320000 tuples done. 330000 tuples done. 340000 tuples done. 350000 tuples done. [Master] 2013-04-22 03:16:24 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=169.335 msec [Master] 2013-04-22 03:16:24 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:24 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=0.260 s, sync=0.169 s, total=0.434 s; sync files=1, longest=0.169 s, average=0.169 s [Master] 2013-04-22 03:16:24 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 360000 tuples done. 370000 tuples done. 380000 tuples done. 390000 tuples done. 400000 tuples done. 410000 tuples done. 420000 tuples done. 430000 tuples done. 440000 tuples done. 450000 tuples done. 460000 tuples done. 470000 tuples done. 480000 tuples done. [Master] 2013-04-22 03:16:24 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:24 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:24 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:24 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:24 EDTLOCATION: LogCheckpointStart, xlog.c:7714 490000 tuples done. 500000 tuples done. [Master] 2013-04-22 03:16:24 EDTDEBUG: 00000: archived transaction log file "000000020000000000000005" [Master] 2013-04-22 03:16:24 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 510000 tuples done. 520000 tuples done. 530000 tuples done. [Master] 2013-04-22 03:16:24 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=243.603 msec [Master] 2013-04-22 03:16:24 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:24 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.243 s, total=0.365 s; sync files=1, longest=0.243 s, average=0.243 s [Master] 2013-04-22 03:16:24 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 540000 tuples done. 550000 tuples done. [Master] 2013-04-22 03:16:24 EDTDEBUG: 00000: archived transaction log file "000000010000000000000004" [Master] 2013-04-22 03:16:24 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 560000 tuples done. 570000 tuples done. 580000 tuples done. 590000 tuples done. 600000 tuples done. 610000 tuples done. 620000 tuples done. 630000 tuples done. [Master] 2013-04-22 03:16:25 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:25 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:25 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:25 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:25 EDTLOCATION: LogCheckpointStart, xlog.c:7714 640000 tuples done. 650000 tuples done. [Master] 2013-04-22 03:16:25 EDTDEBUG: 00000: archived transaction log file "000000020000000000000006" [Master] 2013-04-22 03:16:25 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 660000 tuples done. 670000 tuples done. [Master] 2013-04-22 03:16:25 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=209.356 msec [Master] 2013-04-22 03:16:25 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:25 EDTLOG: 00000: checkpoint complete: wrote 14 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=0.108 s, sync=0.209 s, total=0.328 s; sync files=1, longest=0.209 s, average=0.209 s [Master] 2013-04-22 03:16:25 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 680000 tuples done. 690000 tuples done. 700000 tuples done. 710000 tuples done. 720000 tuples done. 730000 tuples done. 740000 tuples done. 750000 tuples done. 760000 tuples done. 770000 tuples done. 780000 tuples done. 790000 tuples done. [Master] 2013-04-22 03:16:25 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:25 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:25 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:25 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:25 EDTLOCATION: LogCheckpointStart, xlog.c:7714 800000 tuples done. 810000 tuples done. [Master] 2013-04-22 03:16:25 EDTDEBUG: 00000: archived transaction log file "000000020000000000000007" [Master] 2013-04-22 03:16:25 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 820000 tuples done. 830000 tuples done. 840000 tuples done. 850000 tuples done. [Master] 2013-04-22 03:16:26 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=203.194 msec [Master] 2013-04-22 03:16:26 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.203 s, total=0.318 s; sync files=1, longest=0.203 s, average=0.203 s [Master] 2013-04-22 03:16:26 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 860000 tuples done. 870000 tuples done. 880000 tuples done. 890000 tuples done. 900000 tuples done. 910000 tuples done. 920000 tuples done. 930000 tuples done. 940000 tuples done. [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:26 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:26 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:26 EDTLOCATION: LogCheckpointStart, xlog.c:7714 950000 tuples done. 960000 tuples done. [Master] 2013-04-22 03:16:26 EDTDEBUG: 00000: archived transaction log file "000000020000000000000008" [Master] 2013-04-22 03:16:26 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 970000 tuples done. 980000 tuples done. 990000 tuples done. 1000000 tuples done. [Master] 2013-04-22 03:16:26 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=220.703 msec [Master] 2013-04-22 03:16:26 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.101 s, sync=0.220 s, total=0.343 s; sync files=1, longest=0.220 s, average=0.220 s [Master] 2013-04-22 03:16:26 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1010000 tuples done. 1020000 tuples done. 1030000 tuples done. 1040000 tuples done. 1050000 tuples done. 1060000 tuples done. 1070000 tuples done. 1080000 tuples done. 1090000 tuples done. [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:26 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:26 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:26 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:26 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1100000 tuples done. 1110000 tuples done. 1120000 tuples done. [Master] 2013-04-22 03:16:27 EDTDEBUG: 00000: archived transaction log file "000000020000000000000009" [Master] 2013-04-22 03:16:27 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1130000 tuples done. 1140000 tuples done. 1150000 tuples done. [Master] 2013-04-22 03:16:27 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=202.414 msec [Master] 2013-04-22 03:16:27 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:27 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.202 s, total=0.313 s; sync files=1, longest=0.202 s, average=0.202 s [Master] 2013-04-22 03:16:27 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1160000 tuples done. 1170000 tuples done. 1180000 tuples done. 1190000 tuples done. 1200000 tuples done. 1210000 tuples done. 1220000 tuples done. 1230000 tuples done. 1240000 tuples done. 1250000 tuples done. 1260000 tuples done. [Master] 2013-04-22 03:16:27 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:27 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:27 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:27 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:27 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1270000 tuples done. 1280000 tuples done. [Master] 2013-04-22 03:16:27 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000A" [Master] 2013-04-22 03:16:27 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1290000 tuples done. 1300000 tuples done. 1310000 tuples done. [Master] 2013-04-22 03:16:27 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=202.953 msec [Master] 2013-04-22 03:16:27 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:27 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.203 s, total=0.319 s; sync files=1, longest=0.202 s, average=0.202 s [Master] 2013-04-22 03:16:27 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1320000 tuples done. 1330000 tuples done. 1340000 tuples done. 1350000 tuples done. 1360000 tuples done. 1370000 tuples done. 1380000 tuples done. 1390000 tuples done. 1400000 tuples done. [Master] 2013-04-22 03:16:28 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:28 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:28 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:28 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:28 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1410000 tuples done. 1420000 tuples done. 1430000 tuples done. [Master] 2013-04-22 03:16:28 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000B" [Master] 2013-04-22 03:16:28 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1440000 tuples done. 1450000 tuples done. [Master] 2013-04-22 03:16:28 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=205.162 msec [Master] 2013-04-22 03:16:28 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:28 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.205 s, total=0.314 s; sync files=1, longest=0.205 s, average=0.205 s [Master] 2013-04-22 03:16:28 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1460000 tuples done. 1470000 tuples done. 1480000 tuples done. 1490000 tuples done. 1500000 tuples done. 1510000 tuples done. 1520000 tuples done. 1530000 tuples done. 1540000 tuples done. 1550000 tuples done. 1560000 tuples done. 1570000 tuples done. [Master] 2013-04-22 03:16:28 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:28 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:28 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:28 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:28 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1580000 tuples done. 1590000 tuples done. [Master] 2013-04-22 03:16:28 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000C" [Master] 2013-04-22 03:16:28 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1600000 tuples done. 1610000 tuples done. 1620000 tuples done. 1630000 tuples done. 1640000 tuples done. [Master] 2013-04-22 03:16:29 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=427.642 msec [Master] 2013-04-22 03:16:29 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:29 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.427 s, total=0.538 s; sync files=1, longest=0.427 s, average=0.427 s [Master] 2013-04-22 03:16:29 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1650000 tuples done. 1660000 tuples done. 1670000 tuples done. 1680000 tuples done. 1690000 tuples done. 1700000 tuples done. 1710000 tuples done. 1720000 tuples done. 1730000 tuples done. [Master] 2013-04-22 03:16:29 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:29 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:29 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:29 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:29 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1740000 tuples done. [Master] 2013-04-22 03:16:29 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000D" [Master] 2013-04-22 03:16:29 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1750000 tuples done. 1760000 tuples done. 1770000 tuples done. 1780000 tuples done. [Master] 2013-04-22 03:16:29 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=185.104 msec [Master] 2013-04-22 03:16:29 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:29 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.185 s, total=0.303 s; sync files=1, longest=0.185 s, average=0.185 s [Master] 2013-04-22 03:16:29 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1790000 tuples done. 1800000 tuples done. 1810000 tuples done. 1820000 tuples done. 1830000 tuples done. 1840000 tuples done. 1850000 tuples done. 1860000 tuples done. 1870000 tuples done. 1880000 tuples done. [Master] 2013-04-22 03:16:30 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:30 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:30 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:30 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:30 EDTLOCATION: LogCheckpointStart, xlog.c:7714 1890000 tuples done. [Master] 2013-04-22 03:16:30 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000E" [Master] 2013-04-22 03:16:30 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1900000 tuples done. 1910000 tuples done. 1920000 tuples done. 1930000 tuples done. [Master] 2013-04-22 03:16:30 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=220.702 msec [Master] 2013-04-22 03:16:30 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:30 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.122 s, sync=0.220 s, total=0.351 s; sync files=1, longest=0.220 s, average=0.220 s [Master] 2013-04-22 03:16:30 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 1940000 tuples done. 1950000 tuples done. 1960000 tuples done. 1970000 tuples done. 1980000 tuples done. 1990000 tuples done. 2000000 tuples done. 2010000 tuples done. 2020000 tuples done. 2030000 tuples done. 2040000 tuples done. [Master] 2013-04-22 03:16:30 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:30 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:30 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:30 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:30 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2050000 tuples done. 2060000 tuples done. [Master] 2013-04-22 03:16:30 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000F" [Master] 2013-04-22 03:16:30 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2070000 tuples done. 2080000 tuples done. 2090000 tuples done. [Master] 2013-04-22 03:16:31 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=220.985 msec [Master] 2013-04-22 03:16:31 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:31 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.221 s, total=0.331 s; sync files=1, longest=0.220 s, average=0.220 s [Master] 2013-04-22 03:16:31 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2100000 tuples done. 2110000 tuples done. 2120000 tuples done. 2130000 tuples done. 2140000 tuples done. 2150000 tuples done. 2160000 tuples done. 2170000 tuples done. 2180000 tuples done. 2190000 tuples done. [Master] 2013-04-22 03:16:31 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:31 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:31 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:31 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:31 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2200000 tuples done. 2210000 tuples done. [Master] 2013-04-22 03:16:31 EDTDEBUG: 00000: archived transaction log file "000000020000000000000010" [Master] 2013-04-22 03:16:31 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2220000 tuples done. 2230000 tuples done. 2240000 tuples done. 2250000 tuples done. 2260000 tuples done. [Master] 2013-04-22 03:16:31 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=224.822 msec [Master] 2013-04-22 03:16:31 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:31 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.224 s, total=0.335 s; sync files=1, longest=0.224 s, average=0.224 s [Master] 2013-04-22 03:16:31 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2270000 tuples done. 2280000 tuples done. 2290000 tuples done. 2300000 tuples done. 2310000 tuples done. 2320000 tuples done. 2330000 tuples done. 2340000 tuples done. 2350000 tuples done. [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:32 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:32 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:32 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2360000 tuples done. [Master] 2013-04-22 03:16:32 EDTDEBUG: 00000: archived transaction log file "000000020000000000000011" [Master] 2013-04-22 03:16:32 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2370000 tuples done. 2380000 tuples done. 2390000 tuples done. 2400000 tuples done. [Master] 2013-04-22 03:16:32 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=186.173 msec [Master] 2013-04-22 03:16:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.186 s, total=0.302 s; sync files=1, longest=0.186 s, average=0.186 s [Master] 2013-04-22 03:16:32 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2410000 tuples done. 2420000 tuples done. 2430000 tuples done. 2440000 tuples done. 2450000 tuples done. 2460000 tuples done. 2470000 tuples done. 2480000 tuples done. 2490000 tuples done. 2500000 tuples done. [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:32 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:32 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:32 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2510000 tuples done. 2520000 tuples done. [Master] 2013-04-22 03:16:32 EDTDEBUG: 00000: archived transaction log file "000000020000000000000012" [Master] 2013-04-22 03:16:32 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2530000 tuples done. 2540000 tuples done. [Master] 2013-04-22 03:16:32 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=189.749 msec [Master] 2013-04-22 03:16:32 EDTLOCATION: mdsync, md.c:1161 2550000 tuples done. [Master] 2013-04-22 03:16:32 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.101 s, sync=0.189 s, total=0.301 s; sync files=1, longest=0.189 s, average=0.189 s [Master] 2013-04-22 03:16:32 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2560000 tuples done. 2570000 tuples done. 2580000 tuples done. 2590000 tuples done. 2600000 tuples done. 2610000 tuples done. 2620000 tuples done. 2630000 tuples done. 2640000 tuples done. 2650000 tuples done. 2660000 tuples done. [Master] 2013-04-22 03:16:33 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:33 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:33 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:33 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:33 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2670000 tuples done. 2680000 tuples done. [Master] 2013-04-22 03:16:33 EDTDEBUG: 00000: archived transaction log file "000000020000000000000013" [Master] 2013-04-22 03:16:33 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2690000 tuples done. 2700000 tuples done. 2710000 tuples done. [Master] 2013-04-22 03:16:33 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=212.154 msec [Master] 2013-04-22 03:16:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:33 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.212 s, total=0.325 s; sync files=1, longest=0.212 s, average=0.212 s [Master] 2013-04-22 03:16:33 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2720000 tuples done. 2730000 tuples done. 2740000 tuples done. 2750000 tuples done. 2760000 tuples done. 2770000 tuples done. 2780000 tuples done. 2790000 tuples done. 2800000 tuples done. 2810000 tuples done. [Master] 2013-04-22 03:16:33 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:33 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:33 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:33 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:33 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2820000 tuples done. 2830000 tuples done. [Master] 2013-04-22 03:16:33 EDTDEBUG: 00000: archived transaction log file "000000020000000000000014" [Master] 2013-04-22 03:16:33 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2840000 tuples done. 2850000 tuples done. 2860000 tuples done. 2870000 tuples done. [Master] 2013-04-22 03:16:34 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=197.394 msec [Master] 2013-04-22 03:16:34 EDTLOCATION: mdsync, md.c:1161 2880000 tuples done. 2890000 tuples done. [Master] 2013-04-22 03:16:34 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.101 s, sync=0.197 s, total=0.601 s; sync files=1, longest=0.197 s, average=0.197 s [Master] 2013-04-22 03:16:34 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 2900000 tuples done. 2910000 tuples done. 2920000 tuples done. 2930000 tuples done. 2940000 tuples done. 2950000 tuples done. 2960000 tuples done. 2970000 tuples done. 2980000 tuples done. [Master] 2013-04-22 03:16:34 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:34 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:34 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:34 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:34 EDTLOCATION: LogCheckpointStart, xlog.c:7714 2990000 tuples done. [Master] 2013-04-22 03:16:34 EDTDEBUG: 00000: archived transaction log file "000000020000000000000015" [Master] 2013-04-22 03:16:34 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3000000 tuples done. 3010000 tuples done. 3020000 tuples done. [Master] 2013-04-22 03:16:34 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=200.922 msec [Master] 2013-04-22 03:16:34 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.110 s, sync=0.201 s, total=0.319 s; sync files=1, longest=0.200 s, average=0.200 s [Master] 2013-04-22 03:16:35 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3030000 tuples done. 3040000 tuples done. 3050000 tuples done. 3060000 tuples done. 3070000 tuples done. 3080000 tuples done. 3090000 tuples done. 3100000 tuples done. 3110000 tuples done. 3120000 tuples done. 3130000 tuples done. [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:35 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:35 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:35 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3140000 tuples done. 3150000 tuples done. [Master] 2013-04-22 03:16:35 EDTDEBUG: 00000: archived transaction log file "000000020000000000000016" [Master] 2013-04-22 03:16:35 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3160000 tuples done. 3170000 tuples done. 3180000 tuples done. 3190000 tuples done. [Master] 2013-04-22 03:16:35 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=189.493 msec [Master] 2013-04-22 03:16:35 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.189 s, total=0.323 s; sync files=1, longest=0.189 s, average=0.189 s [Master] 2013-04-22 03:16:35 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3200000 tuples done. 3210000 tuples done. 3220000 tuples done. 3230000 tuples done. 3240000 tuples done. 3250000 tuples done. 3260000 tuples done. 3270000 tuples done. 3280000 tuples done. [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:35 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:35 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:35 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:35 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3290000 tuples done. 3300000 tuples done. [Master] 2013-04-22 03:16:35 EDTDEBUG: 00000: archived transaction log file "000000020000000000000017" [Master] 2013-04-22 03:16:35 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3310000 tuples done. 3320000 tuples done. [Master] 2013-04-22 03:16:36 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=200.774 msec [Master] 2013-04-22 03:16:36 EDTLOCATION: mdsync, md.c:1161 3330000 tuples done. [Master] 2013-04-22 03:16:36 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.103 s, sync=0.200 s, total=0.316 s; sync files=1, longest=0.200 s, average=0.200 s [Master] 2013-04-22 03:16:36 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3340000 tuples done. 3350000 tuples done. 3360000 tuples done. 3370000 tuples done. 3380000 tuples done. 3390000 tuples done. 3400000 tuples done. 3410000 tuples done. 3420000 tuples done. 3430000 tuples done. 3440000 tuples done. [Master] 2013-04-22 03:16:36 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:36 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:36 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:36 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:36 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3450000 tuples done. 3460000 tuples done. [Master] 2013-04-22 03:16:36 EDTDEBUG: 00000: archived transaction log file "000000020000000000000018" [Master] 2013-04-22 03:16:36 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3470000 tuples done. 3480000 tuples done. 3490000 tuples done. 3500000 tuples done. [Master] 2013-04-22 03:16:36 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=224.811 msec [Master] 2013-04-22 03:16:36 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:36 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.224 s, total=0.341 s; sync files=1, longest=0.224 s, average=0.224 s [Master] 2013-04-22 03:16:36 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3510000 tuples done. 3520000 tuples done. 3530000 tuples done. 3540000 tuples done. 3550000 tuples done. 3560000 tuples done. 3570000 tuples done. 3580000 tuples done. 3590000 tuples done. 3600000 tuples done. [Master] 2013-04-22 03:16:37 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:37 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:37 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:37 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:37 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3610000 tuples done. 3620000 tuples done. [Master] 2013-04-22 03:16:37 EDTDEBUG: 00000: archived transaction log file "000000020000000000000019" [Master] 2013-04-22 03:16:37 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3630000 tuples done. 3640000 tuples done. 3650000 tuples done. [Master] 2013-04-22 03:16:37 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=202.380 msec [Master] 2013-04-22 03:16:37 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:37 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.108 s, sync=0.202 s, total=0.318 s; sync files=1, longest=0.202 s, average=0.202 s [Master] 2013-04-22 03:16:37 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3660000 tuples done. 3670000 tuples done. 3680000 tuples done. 3690000 tuples done. 3700000 tuples done. 3710000 tuples done. 3720000 tuples done. 3730000 tuples done. 3740000 tuples done. 3750000 tuples done. 3760000 tuples done. [Master] 2013-04-22 03:16:37 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:37 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:37 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:37 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:37 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3770000 tuples done. [Master] 2013-04-22 03:16:37 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001A" [Master] 2013-04-22 03:16:37 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3780000 tuples done. 3790000 tuples done. 3800000 tuples done. [Master] 2013-04-22 03:16:38 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=216.992 msec [Master] 2013-04-22 03:16:38 EDTLOCATION: mdsync, md.c:1161 3810000 tuples done. [Master] 2013-04-22 03:16:38 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.217 s, total=0.336 s; sync files=1, longest=0.216 s, average=0.216 s [Master] 2013-04-22 03:16:38 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3820000 tuples done. 3830000 tuples done. 3840000 tuples done. 3850000 tuples done. 3860000 tuples done. 3870000 tuples done. 3880000 tuples done. 3890000 tuples done. 3900000 tuples done. [Master] 2013-04-22 03:16:38 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:38 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:38 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:38 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:38 EDTLOCATION: LogCheckpointStart, xlog.c:7714 3910000 tuples done. 3920000 tuples done. [Master] 2013-04-22 03:16:38 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001B" [Master] 2013-04-22 03:16:38 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3930000 tuples done. 3940000 tuples done. 3950000 tuples done. 3960000 tuples done. [Master] 2013-04-22 03:16:38 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=189.466 msec [Master] 2013-04-22 03:16:38 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:38 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.189 s, total=0.295 s; sync files=1, longest=0.189 s, average=0.189 s [Master] 2013-04-22 03:16:38 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 3970000 tuples done. 3980000 tuples done. 3990000 tuples done. 4000000 tuples done. 4010000 tuples done. 4020000 tuples done. 4030000 tuples done. 4040000 tuples done. 4050000 tuples done. 4060000 tuples done. 4070000 tuples done. [Master] 2013-04-22 03:16:39 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:39 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:39 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:39 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:39 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4080000 tuples done. 4090000 tuples done. [Master] 2013-04-22 03:16:39 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001C" [Master] 2013-04-22 03:16:39 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4100000 tuples done. 4110000 tuples done. [Master] 2013-04-22 03:16:39 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=314.622 msec [Master] 2013-04-22 03:16:39 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:39 EDTLOG: 00000: checkpoint complete: wrote 2 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.159 s, sync=0.314 s, total=0.485 s; sync files=1, longest=0.314 s, average=0.314 s [Master] 2013-04-22 03:16:39 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4120000 tuples done. 4130000 tuples done. 4140000 tuples done. 4150000 tuples done. 4160000 tuples done. 4170000 tuples done. 4180000 tuples done. 4190000 tuples done. 4200000 tuples done. 4210000 tuples done. 4220000 tuples done. 4230000 tuples done. [Master] 2013-04-22 03:16:39 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:39 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:39 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:39 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:39 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4240000 tuples done. [Master] 2013-04-22 03:16:39 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001D" [Master] 2013-04-22 03:16:39 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4250000 tuples done. 4260000 tuples done. 4270000 tuples done. [Master] 2013-04-22 03:16:40 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=228.399 msec [Master] 2013-04-22 03:16:40 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:40 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.228 s, total=0.346 s; sync files=1, longest=0.228 s, average=0.228 s [Master] 2013-04-22 03:16:40 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4280000 tuples done. 4290000 tuples done. 4300000 tuples done. 4310000 tuples done. 4320000 tuples done. 4330000 tuples done. 4340000 tuples done. 4350000 tuples done. 4360000 tuples done. 4370000 tuples done. [Master] 2013-04-22 03:16:40 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:40 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:40 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:40 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:40 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4380000 tuples done. 4390000 tuples done. [Master] 2013-04-22 03:16:40 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001E" [Master] 2013-04-22 03:16:40 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4400000 tuples done. 4410000 tuples done. 4420000 tuples done. [Master] 2013-04-22 03:16:40 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=213.733 msec [Master] 2013-04-22 03:16:40 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:40 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.101 s, sync=0.213 s, total=0.317 s; sync files=1, longest=0.213 s, average=0.213 s [Master] 2013-04-22 03:16:40 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4430000 tuples done. 4440000 tuples done. 4450000 tuples done. 4460000 tuples done. 4470000 tuples done. 4480000 tuples done. 4490000 tuples done. 4500000 tuples done. 4510000 tuples done. 4520000 tuples done. 4530000 tuples done. 4540000 tuples done. [Master] 2013-04-22 03:16:41 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:41 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:41 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:41 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:41 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4550000 tuples done. [Master] 2013-04-22 03:16:41 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001F" [Master] 2013-04-22 03:16:41 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4560000 tuples done. 4570000 tuples done. 4580000 tuples done. 4590000 tuples done. [Master] 2013-04-22 03:16:41 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=232.186 msec [Master] 2013-04-22 03:16:41 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:41 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.121 s, sync=0.232 s, total=0.361 s; sync files=1, longest=0.232 s, average=0.232 s [Master] 2013-04-22 03:16:41 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4600000 tuples done. 4610000 tuples done. 4620000 tuples done. 4630000 tuples done. 4640000 tuples done. 4650000 tuples done. 4660000 tuples done. 4670000 tuples done. 4680000 tuples done. 4690000 tuples done. [Master] 2013-04-22 03:16:41 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:41 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:41 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:41 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:41 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4700000 tuples done. 4710000 tuples done. [Master] 2013-04-22 03:16:41 EDTDEBUG: 00000: archived transaction log file "000000020000000000000020" [Master] 2013-04-22 03:16:41 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4720000 tuples done. 4730000 tuples done. 4740000 tuples done. [Master] 2013-04-22 03:16:42 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=214.964 msec [Master] 2013-04-22 03:16:42 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:42 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.109 s, sync=0.215 s, total=0.333 s; sync files=1, longest=0.214 s, average=0.214 s [Master] 2013-04-22 03:16:42 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4750000 tuples done. 4760000 tuples done. 4770000 tuples done. 4780000 tuples done. 4790000 tuples done. 4800000 tuples done. 4810000 tuples done. 4820000 tuples done. 4830000 tuples done. 4840000 tuples done. 4850000 tuples done. [Master] 2013-04-22 03:16:42 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:42 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:42 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:42 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:42 EDTLOCATION: LogCheckpointStart, xlog.c:7714 4860000 tuples done. [Master] 2013-04-22 03:16:42 EDTDEBUG: 00000: archived transaction log file "000000020000000000000021" [Master] 2013-04-22 03:16:42 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4870000 tuples done. 4880000 tuples done. 4890000 tuples done. 4900000 tuples done. [Master] 2013-04-22 03:16:43 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=382.323 msec [Master] 2013-04-22 03:16:43 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:43 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.120 s, sync=0.382 s, total=0.505 s; sync files=1, longest=0.382 s, average=0.382 s [Master] 2013-04-22 03:16:43 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 4910000 tuples done. 4920000 tuples done. 4930000 tuples done. 4940000 tuples done. 4950000 tuples done. 4960000 tuples done. 4970000 tuples done. 4980000 tuples done. 4990000 tuples done. 5000000 tuples done. [Master] 2013-04-22 03:16:43 EDTLOG: 00000: duration: 20759.584 ms statement: copy pgbench_accounts from stdin [Master] 2013-04-22 03:16:43 EDTLOCATION: exec_simple_query, postgres.c:1123 [Master] 2013-04-22 03:16:43 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:43 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:43 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:43 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:43 EDTLOCATION: LogCheckpointStart, xlog.c:7714 set primary key... [Master] 2013-04-22 03:16:43 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_branches_pkey" for table "pgbench_branches" [Master] 2013-04-22 03:16:43 EDTLOCATION: DefineIndex, indexcmds.c:581 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_branches_pkey" for table "pgbench_branches" [Master] 2013-04-22 03:16:43 EDTDEBUG: 00000: building index "pgbench_branches_pkey" on table "pgbench_branches" [Master] 2013-04-22 03:16:43 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 03:16:43 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_tellers_pkey" for table "pgbench_tellers" [Master] 2013-04-22 03:16:43 EDTLOCATION: DefineIndex, indexcmds.c:581 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_tellers_pkey" for table "pgbench_tellers" [Master] 2013-04-22 03:16:43 EDTDEBUG: 00000: building index "pgbench_tellers_pkey" on table "pgbench_tellers" [Master] 2013-04-22 03:16:43 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 03:16:43 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_accounts_pkey" for table "pgbench_accounts" [Master] 2013-04-22 03:16:43 EDTLOCATION: DefineIndex, indexcmds.c:581 NOTICE: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_accounts_pkey" for table "pgbench_accounts" [Master] 2013-04-22 03:16:43 EDTDEBUG: 00000: building index "pgbench_accounts_pkey" on table "pgbench_accounts" [Master] 2013-04-22 03:16:43 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 03:16:43 EDTDEBUG: 00000: archived transaction log file "000000020000000000000022" [Master] 2013-04-22 03:16:43 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=913.528 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12647 time=72.701 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12647_vm time=44.756 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12741 time=0.004 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12639 time=0.003 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/12663 time=0.001 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12662 time=0.002 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: archived transaction log file "000000020000000000000023" [Master] 2013-04-22 03:16:48 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/12655 time=47.038 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:48 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/24579 time=159.144 msec [Master] 2013-04-22 03:16:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:49 EDTDEBUG: 00000: archived transaction log file "000000020000000000000024" [Master] 2013-04-22 03:16:49 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:50 EDTDEBUG: 00000: archived transaction log file "000000020000000000000025" [Master] 2013-04-22 03:16:50 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24588 time=4857.837 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/12636 time=0.006 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12636_fsm time=0.005 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12738 time=0.003 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/12740 time=0.003 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=15 file=base/12870/12654 time=0.725 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=16 file=base/12870/12652 time=7.889 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12660 time=0.004 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/24576 time=0.003 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/12627 time=0.002 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/12653 time=0.373 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12638 time=0.004 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12628 time=0.003 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTLOG: 00000: checkpoint complete: wrote 538 buffers (13.1%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=4.293 s, sync=6.104 s, total=10.412 s; sync files=22, longest=4.857 s, average=0.277 s [Master] 2013-04-22 03:16:53 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:53 EDTLOG: 00000: checkpoints are occurring too frequently (10 seconds apart) [Master] 2013-04-22 03:16:53 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:53 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:53 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:53 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:53 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=6.828 msec [Master] 2013-04-22 03:16:53 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:16:53 EDTLOG: 00000: checkpoint complete: wrote 60 buffers (1.5%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.100 s, sync=0.006 s, total=0.192 s; sync files=1, longest=0.006 s, average=0.006 s [Master] 2013-04-22 03:16:53 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 03:16:54 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:54 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 1 removed, 2 recycled; write=0.000 s, sync=0.000 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:54 EDTDEBUG: 00000: archived transaction log file "000000020000000000000026" [Master] 2013-04-22 03:16:54 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:54 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:54 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=0.000 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:54 EDTDEBUG: 00000: archived transaction log file "000000020000000000000027" [Master] 2013-04-22 03:16:54 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 03:16:54 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:54 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:54 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=0.000 s, total=0.012 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 03:16:54 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Master] 2013-04-22 03:16:54 EDTDEBUG: 00000: archived transaction log file "000000020000000000000028" [Master] 2013-04-22 03:16:54 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 vacuum...[Master] 2013-04-22 03:16:56 EDTLOG: 00000: checkpoints are occurring too frequently (2 seconds apart) [Master] 2013-04-22 03:16:56 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 03:16:56 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 03:16:56 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 03:16:56 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:16:56 EDTDEBUG: 00000: archived transaction log file "000000020000000000000029" [Master] 2013-04-22 03:16:56 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 03:16:56 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Master] 2013-04-22 03:16:56 EDTCONTEXT: writing block 72330 of relation base/12870/24588 [Master] 2013-04-22 03:16:56 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Master] 2013-04-22 03:16:56 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Master] 2013-04-22 03:16:56 EDTCONTEXT: writing block 76423 of relation base/12870/24588 [Master] 2013-04-22 03:16:56 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 done. #### Shutdown master in immediate mode #### waiting for server to shut down....[Master] 2013-04-22 03:16:56 EDTLOG: 00000: received immediate shutdown request [Master] 2013-04-22 03:16:56 EDTLOCATION: pmdie, postmaster.c:2240 [Master] 2013-04-22 03:16:56 EDTWARNING: 57P02: terminating connection because of crash of another server process [Master] 2013-04-22 03:16:56 EDTDETAIL: The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory. [Master] 2013-04-22 03:16:56 EDTHINT: In a moment you should be able to reconnect to the database and repeat your command. [Master] 2013-04-22 03:16:56 EDTLOCATION: quickdie, postgres.c:2546 done server stopped #### Starting master as a standby, and next promote#### waiting for server to start....[Master] 2013-04-22 03:16:57 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 03:16:54 EDT [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6224 cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:16:57 EDTLOG: 00000: restored log file "00000002.history" from archive [Master] 2013-04-22 03:16:57 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-22 03:16:57 EDTLOG: 00000: entering standby mode [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6290 [Master] 2013-04-22 03:16:57 EDTLOG: 00000: restored log file "000000020000000000000029" from archive [Master] 2013-04-22 03:16:57 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: got WAL segment from archive [Master] 2013-04-22 03:16:57 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: checkpoint record is at 0/291001F0 [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6369 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: redo record is at 0/290FE130; shutdown FALSE [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6404 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: next transaction ID: 0/1818; next OID: 32768 [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6408 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6411 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6414 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 03:16:57 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Master] 2013-04-22 03:16:57 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: initializing for hot standby [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6580 [Master] 2013-04-22 03:16:57 EDTLOG: 00000: consistent recovery state reached at 0/29100250 [Master] 2013-04-22 03:16:57 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7249 [Master] 2013-04-22 03:16:57 EDTLOG: 00000: redo starts at 0/290FE130 [Master] 2013-04-22 03:16:57 EDTLOCATION: StartupXLOG, xlog.c:6712 [Master] 2013-04-22 03:16:57 EDTDEBUG: 00000: recovery snapshots are now enabled [Master] 2013-04-22 03:16:57 EDTCONTEXT: xlog redo running xacts: nextXid 1818 latestCompletedXid 1816 oldestRunningXid 1817; 1 xacts: 1817 [Master] 2013-04-22 03:16:57 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Master] 2013-04-22 03:16:57 EDTLOG: 00000: database system is ready to accept read only connections [Master] 2013-04-22 03:16:57 EDTLOCATION: sigusr1_handler, postmaster.c:4272 done server started server promoting #### Sleep for 5 seconds #### cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:17:02 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 1 entries [Master] 2013-04-22 03:17:02 EDTCONTEXT: writing block 64384 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 68478 [Master] 2013-04-22 03:17:02 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Master] 2013-04-22 03:17:03 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 1 entries [Master] 2013-04-22 03:17:03 EDTCONTEXT: writing block 68479 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 72573 [Master] 2013-04-22 03:17:03 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Master] 2013-04-22 03:17:03 EDTLOG: 00000: record with zero length at 0/2A0F9768 [Master] 2013-04-22 03:17:03 EDTLOCATION: ReadRecord, xlog.c:4050 cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:17:03 EDTLOG: 00000: received promote request [Master] 2013-04-22 03:17:03 EDTLOCATION: CheckForStandbyTrigger, xlog.c:10667 [Master] 2013-04-22 03:17:03 EDTLOG: 00000: redo done at 0/2A0F96B8 [Master] 2013-04-22 03:17:03 EDTLOCATION: StartupXLOG, xlog.c:6849 [Master] 2013-04-22 03:17:03 EDTLOG: 00000: last completed transaction was at log time 2013-04-22 03:16:56.815311-04 [Master] 2013-04-22 03:17:03 EDTLOCATION: StartupXLOG, xlog.c:6854 cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:17:03 EDTLOG: 00000: selected new timeline ID: 3 [Master] 2013-04-22 03:17:03 EDTLOCATION: StartupXLOG, xlog.c:6955 [Master] 2013-04-22 03:17:03 EDTLOG: 00000: restored log file "00000002.history" from archive [Master] 2013-04-22 03:17:03 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Master] 2013-04-22 03:17:04 EDTLOG: 00000: archive recovery complete [Master] 2013-04-22 03:17:04 EDTLOCATION: exitArchiveRecovery, xlog.c:5793 [Master] 2013-04-22 03:17:04 EDTLOG: 00000: checkpoint starting: end-of-recovery immediate wait [Master] 2013-04-22 03:17:04 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Master] 2013-04-22 03:17:04 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12612 time=1.399 msec [Master] 2013-04-22 03:17:04 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:04 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24579 time=0.601 msec [Master] 2013-04-22 03:17:04 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:04 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/24579_vm time=0.004 msec [Master] 2013-04-22 03:17:04 EDTLOCATION: mdsync, md.c:1161 #### Was latest .history file archived ??? #### #### Starting standby #### waiting for server to start.....[Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/24588 time=5008.508 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/24588_vm time=0.762 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24589 time=9.914 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12607 time=0.613 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/12607_fsm time=0.551 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/12607_vm time=0.653 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/12636 time=0.590 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/24591 time=0.724 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/24593 time=0.540 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/24576 time=1.418 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/24576_vm time=0.003 msec [Master] 2013-04-22 03:17:09 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 03:17:09 EDTLOG: 00000: checkpoint complete: wrote 5 buffers (0.1%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=5.026 s, total=5.033 s; sync files=14, longest=5.008 s, average=0.359 s [Master] 2013-04-22 03:17:09 EDTLOCATION: LogCheckpointEnd, xlog.c:7802 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: database system was shut down in recovery at 2013-04-22 03:16:10 EDT [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6204 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "00000002.history" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: resetting unlogged relations: cleanup 0 init 1 [Master] 2013-04-22 03:17:09 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 03:17:09 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 03:17:09 EDTLOCATION: reaper, postmaster.c:2408 [Master] 2013-04-22 03:17:09 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 03:17:09 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "00000002.history" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: entering standby mode [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6290 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: archived transaction log file "00000002000000000000002A" [Master] 2013-04-22 03:17:09 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "000000020000000000000003" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: checkpoint record is at 0/3000058 [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6369 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: redo record is at 0/3000020; shutdown FALSE [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6404 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6408 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6411 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6414 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 03:17:09 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 03:17:09 EDTDEBUG: 00000: archived transaction log file "00000003.history" [Master] 2013-04-22 03:17:09 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Standby] 2013-04-22 03:17:09 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: initializing for hot standby [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6580 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: consistent recovery state reached at 0/30000B8 [Standby] 2013-04-22 03:17:09 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7249 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: redo starts at 0/3000020 [Standby] 2013-04-22 03:17:09 EDTLOCATION: StartupXLOG, xlog.c:6712 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: recovery snapshots are now enabled [Standby] 2013-04-22 03:17:09 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Standby] 2013-04-22 03:17:09 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 03:17:09 EDTCONTEXT: xlog redo checkpoint: redo 0/30000B8; tli 2; fpw true; xid 0/1809; oid 24576; multi 1; offset 0; oldest xid 1798 in DB 1; oldest running xid 0; shutdown [Standby] 2013-04-22 03:17:09 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: database system is ready to accept read only connections [Standby] 2013-04-22 03:17:09 EDTLOCATION: sigusr1_handler, postmaster.c:4272 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:09 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "000000020000000000000004" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "000000020000000000000005" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 done server started [mitsu-ko@localhost postgresql-9.2.3]$ [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "000000020000000000000006" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:09 EDTLOG: 00000: restored log file "000000020000000000000007" from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:09 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:09 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:10 EDTLOG: 00000: restored log file "000000020000000000000008" from archive [Standby] 2013-04-22 03:17:10 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:10 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=0.327 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12625_fsm time=0.263 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12741 time=0.341 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12639 time=0.229 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12616 time=0.472 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24579 time=1.460 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/24579_fsm time=0.912 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=8 file=global/12763 time=0.242 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: checkpoint sync: number=9 file=global/12763_vm time=0.228 msec [Standby] 2013-04-22 03:17:10 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:10 EDTLOG: 00000: restored log file "000000020000000000000009" from archive [Standby] 2013-04-22 03:17:10 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:10 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:10 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:11 EDTCONTEXT: writing block 13544 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 17390; 61 tuples [Standby] 2013-04-22 03:17:11 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24588 time=1097.024 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/24588_fsm time=0.569 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12613 time=0.245 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12636 time=0.249 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/12636_fsm time=0.251 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=15 file=global/12765 time=0.187 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=16 file=global/12766 time=0.162 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12738 time=0.201 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/12740 time=0.202 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/12615 time=0.189 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/24576 time=0.676 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12627 time=0.220 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12638 time=0.196 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: checkpoint sync: number=23 file=base/12870/12628 time=0.165 msec [Standby] 2013-04-22 03:17:11 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restartpoint complete: wrote 11 buffers (0.3%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.823 s, sync=1.105 s, total=1.941 s; sync files=23, longest=1.097 s, average=0.048 s [Standby] 2013-04-22 03:17:11 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: recovery restart point at 0/30000B8 [Standby] 2013-04-22 03:17:11 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:11 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:11 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restored log file "00000002000000000000000A" from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restored log file "00000002000000000000000B" from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restored log file "00000002000000000000000C" from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:11 EDTLOG: 00000: restored log file "00000002000000000000000D" from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:11 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:11 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:12 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=854.995 msec [Standby] 2013-04-22 03:17:12 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:12 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=2.569 msec [Standby] 2013-04-22 03:17:12 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:12 EDTLOG: 00000: restored log file "00000002000000000000000E" from archive [Standby] 2013-04-22 03:17:12 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:12 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:12 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:12 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:12 EDTCONTEXT: writing block 25066 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 28950; 61 tuples [Standby] 2013-04-22 03:17:12 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:12 EDTLOG: 00000: restartpoint complete: wrote 8 buffers (0.2%); 1 transaction log file(s) added, 0 removed, 0 recycled; write=0.586 s, sync=0.857 s, total=1.620 s; sync files=2, longest=0.854 s, average=0.428 s [Standby] 2013-04-22 03:17:12 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:12 EDTLOG: 00000: recovery restart point at 0/9032E80 [Standby] 2013-04-22 03:17:12 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:12 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:12 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:12 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:12 EDTLOG: 00000: restored log file "00000002000000000000000F" from archive [Standby] 2013-04-22 03:17:12 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:12 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:12 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:13 EDTLOG: 00000: restored log file "000000020000000000000010" from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:13 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:13 EDTLOG: 00000: restored log file "000000020000000000000011" from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:13 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:13 EDTLOG: 00000: restored log file "000000020000000000000012" from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:13 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:13 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=891.664 msec [Standby] 2013-04-22 03:17:14 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=1.156 msec [Standby] 2013-04-22 03:17:14 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restartpoint complete: wrote 8 buffers (0.2%); 0 transaction log file(s) added, 4 removed, 3 recycled; write=0.501 s, sync=0.893 s, total=1.406 s; sync files=2, longest=0.891 s, average=0.446 s [Standby] 2013-04-22 03:17:14 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: recovery restart point at 0/E101B40 [Standby] 2013-04-22 03:17:14 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:14 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:14 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restored log file "000000020000000000000013" from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restored log file "000000020000000000000014" from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:14 EDTCONTEXT: writing block 41697 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 45557; 61 tuples [Standby] 2013-04-22 03:17:14 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restored log file "000000020000000000000015" from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:14 EDTLOG: 00000: restored log file "000000020000000000000016" from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:14 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:14 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:15 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=896.061 msec [Standby] 2013-04-22 03:17:15 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:15 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=1.564 msec [Standby] 2013-04-22 03:17:15 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: restartpoint complete: wrote 7 buffers (0.2%); 0 transaction log file(s) added, 2 removed, 3 recycled; write=0.422 s, sync=0.897 s, total=1.326 s; sync files=2, longest=0.896 s, average=0.448 s [Standby] 2013-04-22 03:17:15 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: recovery restart point at 0/11101838 [Standby] 2013-04-22 03:17:15 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:15 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:15 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: restored log file "000000020000000000000017" from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:15 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: restored log file "000000020000000000000018" from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:15 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:15 EDTLOG: 00000: restored log file "000000020000000000000019" from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:15 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:15 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:16 EDTLOG: 00000: restored log file "00000002000000000000001A" from archive [Standby] 2013-04-22 03:17:16 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:16 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:16 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:17 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=931.332 msec [Standby] 2013-04-22 03:17:17 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:17 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=2.221 msec [Standby] 2013-04-22 03:17:17 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: restartpoint complete: wrote 9 buffers (0.2%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=0.498 s, sync=0.933 s, total=1.433 s; sync files=2, longest=0.931 s, average=0.466 s [Standby] 2013-04-22 03:17:17 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: recovery restart point at 0/16100920 [Standby] 2013-04-22 03:17:17 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:17 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:17 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: restored log file "00000002000000000000001B" from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:17 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: restored log file "00000002000000000000001C" from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:17 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:17 EDTLOG: 00000: restored log file "00000002000000000000001D" from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:17 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:17 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=680.025 msec [Standby] 2013-04-22 03:17:18 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=6.918 msec [Standby] 2013-04-22 03:17:18 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restartpoint complete: wrote 6 buffers (0.1%); 0 transaction log file(s) added, 2 removed, 3 recycled; write=0.429 s, sync=0.687 s, total=1.134 s; sync files=2, longest=0.680 s, average=0.343 s [Standby] 2013-04-22 03:17:18 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: recovery restart point at 0/1A0FF328 [Standby] 2013-04-22 03:17:18 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:18 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:18 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restored log file "00000002000000000000001E" from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restored log file "00000002000000000000001F" from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:18 EDTCONTEXT: xlog redo multi-insert (init): rel 1663/12870/24588; blk 73725; 61 tuples [Standby] 2013-04-22 03:17:18 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restored log file "000000020000000000000020" from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 1 entries [Standby] 2013-04-22 03:17:18 EDTCONTEXT: writing block 72409 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 76285; 61 tuples [Standby] 2013-04-22 03:17:18 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:18 EDTLOG: 00000: restored log file "000000020000000000000021" from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:18 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:18 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:19 EDTCONTEXT: writing block 72592 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 78399; 61 tuples [Standby] 2013-04-22 03:17:19 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=892.377 msec [Standby] 2013-04-22 03:17:19 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=1.935 msec [Standby] 2013-04-22 03:17:19 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restartpoint complete: wrote 6 buffers (0.1%); 0 transaction log file(s) added, 1 removed, 3 recycled; write=0.382 s, sync=0.894 s, total=1.283 s; sync files=2, longest=0.892 s, average=0.447 s [Standby] 2013-04-22 03:17:19 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: recovery restart point at 0/1D0FEED8 [Standby] 2013-04-22 03:17:19 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:22.596264-04 [Standby] 2013-04-22 03:17:19 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:19 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restored log file "000000020000000000000022" from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restored log file "000000020000000000000023" from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restored log file "000000020000000000000024" from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:19 EDTLOG: 00000: restored log file "000000020000000000000025" from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:19 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12647_vm time=0.509 msec [Standby] 2013-04-22 03:17:19 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:19 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12625_fsm time=1.431 msec [Standby] 2013-04-22 03:17:19 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTLOG: 00000: restored log file "000000020000000000000026" from archive [Standby] 2013-04-22 03:17:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 4 entries [Standby] 2013-04-22 03:17:20 EDTCONTEXT: xlog redo newpage: rel 1663/12870/24593; fork 0, blk 7667 [Standby] 2013-04-22 03:17:20 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/24588 time=408.223 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/24588_fsm time=2.401 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/24589 time=1.467 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/12636 time=0.539 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12636_fsm time=0.337 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/24591 time=1.357 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/12738_fsm time=0.432 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTLOG: 00000: restored log file "000000020000000000000027" from archive [Standby] 2013-04-22 03:17:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:20 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24593 time=601.169 msec [Standby] 2013-04-22 03:17:20 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:20 EDTLOG: 00000: restartpoint complete: wrote 9 buffers (0.2%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=0.517 s, sync=1.018 s, total=1.537 s; sync files=10, longest=0.601 s, average=0.101 s [Standby] 2013-04-22 03:17:20 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:20 EDTLOG: 00000: recovery restart point at 0/211026B8 [Standby] 2013-04-22 03:17:20 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:43.371954-04 [Standby] 2013-04-22 03:17:20 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:20 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:20 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:21 EDTLOG: 00000: restored log file "000000020000000000000028" from archive [Standby] 2013-04-22 03:17:21 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:21 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:21 EDTLOG: 00000: restored log file "000000020000000000000029" from archive [Standby] 2013-04-22 03:17:21 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:21 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 9 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 511 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 4596 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 10 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 4590 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 8683 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=0.583 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12647 time=0.286 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12741 time=0.285 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12639 time=0.258 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12662 time=0.238 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/12663 time=0.185 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12655 time=0.321 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/24579 time=0.843 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/24579_vm time=0.787 msec [Standby] 2013-04-22 03:17:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 11333 of relation base/12870/24588 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 15428 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 19523 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 19521 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 23616 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 23614 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 27709 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 27707 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 31802 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 31800 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 35895 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 35893 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 39988 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 39986 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 44081 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 44079 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 48174 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 3 entries [Standby] 2013-04-22 03:17:21 EDTCONTEXT: writing block 48172 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 52267 [Standby] 2013-04-22 03:17:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24588 time=1228.258 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/24588_fsm time=0.008 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/24588_vm time=4.596 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/24589 time=1.557 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/12607_vm time=1.028 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=15 file=base/12870/12636 time=0.004 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=16 file=base/12870/24591 time=1.096 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12738 time=0.003 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/12740 time=0.002 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/12654 time=2.759 msec [Standby] 2013-04-22 03:17:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 1 entries [Standby] 2013-04-22 03:17:22 EDTCONTEXT: writing block 56336 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 60431 [Standby] 2013-04-22 03:17:22 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:22 EDTLOG: 00000: restored log file "00000002000000000000002A" from archive [Standby] 2013-04-22 03:17:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 1 entries [Standby] 2013-04-22 03:17:22 EDTCONTEXT: writing block 60431 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 64526 [Standby] 2013-04-22 03:17:22 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:22 EDTCONTEXT: writing block 64525 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 68619 [Standby] 2013-04-22 03:17:22 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:22 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:22 EDTCONTEXT: writing block 68614 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 72707 [Standby] 2013-04-22 03:17:22 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:23 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/24593 time=606.812 msec [Standby] 2013-04-22 03:17:23 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:23 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12652 time=140.544 msec [Standby] 2013-04-22 03:17:23 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:23 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12660 time=0.004 msec [Standby] 2013-04-22 03:17:23 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:23 EDTDEBUG: 00000: checkpoint sync: number=23 file=base/12870/24576 time=0.003 msec [Standby] 2013-04-22 03:17:23 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:24 EDTCONTEXT: writing block 72712 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 76807 [Standby] 2013-04-22 03:17:24 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: checkpoint sync: number=24 file=base/12870/24576_vm time=932.032 msec [Standby] 2013-04-22 03:17:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: checkpoint sync: number=25 file=base/12870/12627 time=0.005 msec [Standby] 2013-04-22 03:17:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: checkpoint sync: number=26 file=base/12870/12653 time=0.001 msec [Standby] 2013-04-22 03:17:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: checkpoint sync: number=27 file=base/12870/12638 time=0.002 msec [Standby] 2013-04-22 03:17:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: checkpoint sync: number=28 file=base/12870/12628 time=0.001 msec [Standby] 2013-04-22 03:17:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:24 EDTCONTEXT: writing block 76806 of relation base/12870/24588 xlog redo visible: rel 1663/12870/24588; blk 80901 [Standby] 2013-04-22 03:17:24 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:24 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 03:17:24 EDTCONTEXT: writing block 80900 of relation base/12870/24588 xlog redo vacuum: rel 1663/12870/24593; blk 13712, lastBlockVacuumed 0 [Standby] 2013-04-22 03:17:24 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: restartpoint complete: wrote 7 buffers (0.2%); 0 transaction log file(s) added, 1 removed, 3 recycled; write=0.347 s, sync=2.924 s, total=4.035 s; sync files=28, longest=1.228 s, average=0.104 s [Standby] 2013-04-22 03:17:25 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: recovery restart point at 0/270FE688 [Standby] 2013-04-22 03:17:25 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:55.917972-04 [Standby] 2013-04-22 03:17:25 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 03:17:25 EDTLOCATION: LogCheckpointStart, xlog.c:7714 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: record with zero length at 0/2A0F9768 [Standby] 2013-04-22 03:17:25 EDTLOCATION: ReadRecord, xlog.c:4050 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: record with zero length at 0/2A0F9768 [Standby] 2013-04-22 03:17:25 EDTLOCATION: ReadRecord, xlog.c:4050 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: restored log file "00000003.history" from archive [Standby] 2013-04-22 03:17:25 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: restored log file "00000003.history" from archive [Standby] 2013-04-22 03:17:25 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: new target timeline is 3 [Standby] 2013-04-22 03:17:25 EDTLOCATION: rescanLatestTimeLine, xlog.c:4575 cp: cannot stat `../arc/00000003000000000000002A': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: restored log file "00000002000000000000002A" from archive [Standby] 2013-04-22 03:17:25 EDTLOCATION: RestoreArchivedFile, xlog.c:3259 [Standby] 2013-04-22 03:17:25 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 03:17:25 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2916 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: record with zero length at 0/2A0F9768 [Standby] 2013-04-22 03:17:25 EDTLOCATION: ReadRecord, xlog.c:4050 [Standby] 2013-04-22 03:17:25 EDTDEBUG: 00000: record with zero length at 0/2A0F9768 [Standby] 2013-04-22 03:17:25 EDTLOCATION: ReadRecord, xlog.c:4050 cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 03:17:25 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 03:17:25 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 03:17:25 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/2A000000 [Master] 2013-04-22 03:17:25 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Standby] 2013-04-22 03:17:25 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 03:17:25 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 [Master] 2013-04-22 03:17:25 EDTDEBUG: 00000: standby "walreceiver" has now caught up with primary [Master] 2013-04-22 03:17:25 EDTLOCATION: WalSndLoop, walsender.c:797 [Standby] 2013-04-22 03:17:25 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 03:17:25 EDTCONTEXT: xlog redo checkpoint: redo 0/2A0F9768; tli 3; fpw true; xid 0/1821; oid 32768; multi 1; offset 0; oldest xid 1798 in DB 1; oldest running xid 0; shutdown [Standby] 2013-04-22 03:17:25 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 03:17:26 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12612 time=235.860 msec [Standby] 2013-04-22 03:17:26 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588 time=2812.684 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/24588_vm time=0.552 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12607 time=0.466 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12607_fsm time=0.460 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/12636 time=0.402 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/24593 time=0.428 msec [Standby] 2013-04-22 03:17:29 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 03:17:29 EDTLOG: 00000: restartpoint complete: wrote 5 buffers (0.1%); 0 transaction log file(s) added, 3 removed, 3 recycled; write=0.658 s, sync=3.051 s, total=4.070 s; sync files=7, longest=2.812 s, average=0.435 s [Standby] 2013-04-22 03:17:29 EDTLOCATION: LogCheckpointEnd, xlog.c:7786 [Standby] 2013-04-22 03:17:29 EDTLOG: 00000: recovery restart point at 0/290FE130 [Standby] 2013-04-22 03:17:29 EDTDETAIL: last completed transaction was at log time 2013-04-22 03:16:56.815311-04 [Standby] 2013-04-22 03:17:29 EDTLOCATION: CreateRestartPoint, xlog.c:8494 [Master] 2013-04-22 03:18:09 EDTDEBUG: 00000: autovacuum: processing database "postgres" [Master] 2013-04-22 03:18:09 EDTLOCATION: AutoVacWorkerMain, autovacuum.c:1638