[mitsu-ko@localhost postgresql-9.2.4]$ sh replication_test.sh #### initial settings #### mkdir: ディレクトリ `arc' を作成できません: ファイルが存在します Postgresql is "/home/mitsu-ko/postgresql-9.2.4/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 01:26:06 EDTLOG: 00000: database system was shut down at 2013-04-22 01:26:06 EDT [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6269 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: checkpoint record is at 0/1803B30 [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6474 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: redo record is at 0/1803B30; shutdown TRUE [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6509 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: next transaction ID: 0/1808; next OID: 12871 [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6513 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6516 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 01:26:06 EDTLOCATION: StartupXLOG, xlog.c:6519 [Master] 2013-04-22 01:26:06 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 01:26:06 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 01:26:06 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 01:26:06 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Master] 2013-04-22 01:26:06 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 01:26:06 EDTLOCATION: reaper, postmaster.c:2408 done server started #### basebackup #### [Master] 2013-04-22 01:26:07 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:26:07 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:07 EDTDEBUG: 00000: received replication command: BASE_BACKUP LABEL 'pg_basebackup base backup' NOWAIT [Master] 2013-04-22 01:26:07 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:07 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:07 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:07 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:07 EDTLOG: 00000: checkpoint starting: force wait xlog [Master] 2013-04-22 01:26:07 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:07 EDTDEBUG: 00000: archived transaction log file "000000010000000000000001" [Master] 2013-04-22 01:26:07 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: checkpoint sync: number=1 file=global/12619 time=8.037 msec [Master] 2013-04-22 01:26:08 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: checkpoint sync: number=2 file=global/12617 time=1.246 msec [Master] 2013-04-22 01:26:08 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: checkpoint sync: number=3 file=global/12617_vm time=1.300 msec [Master] 2013-04-22 01:26:08 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: checkpoint sync: number=4 file=global/12620 time=1.347 msec [Master] 2013-04-22 01:26:08 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:08 EDTLOG: 00000: checkpoint complete: wrote 4 buffers (0.1%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.303 s, sync=0.012 s, total=0.503 s; sync files=4, longest=0.008 s, average=0.002 s [Master] 2013-04-22 01:26:08 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:26:08 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/2000000 [Master] 2013-04-22 01:26:08 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: standby "pg_basebackup" has now caught up with primary [Master] 2013-04-22 01:26:08 EDTLOCATION: WalSndLoop, walsender.c:797 [Master] 2013-04-22 01:26:08 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:08 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:08 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:08 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:08 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: archived transaction log file "000000010000000000000002.00000020.backup" [Master] 2013-04-22 01:26:08 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:08 EDTDEBUG: 00000: archived transaction log file "000000010000000000000002" [Master] 2013-04-22 01:26:08 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:08 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.177 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 01:26:08 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 #### Startup standby #### server starting #### Sleep for 5 seconds #### [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 01:26:08 EDT [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6293 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: creating missing WAL directory "pg_xlog/archive_status" [Standby] 2013-04-22 01:26:14 EDTLOCATION: ValidateXLOGDirectoryStructure, xlog.c:3711 cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: entering standby mode [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6359 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: restored log file "000000010000000000000002" from archive [Standby] 2013-04-22 01:26:14 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:26:14 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: checkpoint record is at 0/2000058 [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6407 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: redo record is at 0/2000020; shutdown FALSE [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6509 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6513 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6516 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6519 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 01:26:14 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Standby] 2013-04-22 01:26:14 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: initializing for hot standby [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6685 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: redo starts at 0/2000020 [Standby] 2013-04-22 01:26:14 EDTLOCATION: StartupXLOG, xlog.c:6817 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: recovery snapshots are now enabled [Standby] 2013-04-22 01:26:14 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Standby] 2013-04-22 01:26:14 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Standby] 2013-04-22 01:26:14 EDTDEBUG: 00000: end of backup reached [Standby] 2013-04-22 01:26:14 EDTCONTEXT: xlog redo backup end: 0/2000020 [Standby] 2013-04-22 01:26:14 EDTLOCATION: xlog_redo, xlog.c:9057 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: consistent recovery state reached at 0/20000E0 [Standby] 2013-04-22 01:26:14 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7356 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: database system is ready to accept read only connections [Standby] 2013-04-22 01:26:14 EDTLOCATION: sigusr1_handler, postmaster.c:4267 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:14 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:26:14 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:14 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/3000000 [Master] 2013-04-22 01:26:14 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:26:14 EDTDEBUG: 00000: standby "walreceiver" has now caught up with primary [Master] 2013-04-22 01:26:14 EDTLOCATION: WalSndLoop, walsender.c:797 [Standby] 2013-04-22 01:26:14 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 01:26:14 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 #### Shutdown standby #### waiting for server to shut down....[Standby] 2013-04-22 01:26:19 EDTLOG: 00000: received fast shutdown request [Standby] 2013-04-22 01:26:19 EDTLOCATION: pmdie, postmaster.c:2187 [Standby] 2013-04-22 01:26:19 EDTLOG: 00000: aborting any active transactions [Standby] 2013-04-22 01:26:19 EDTLOCATION: pmdie, postmaster.c:2211 [Standby] 2013-04-22 01:26:19 EDTFATAL: 57P01: terminating walreceiver process due to administrator command [Standby] 2013-04-22 01:26:19 EDTLOCATION: ProcessWalRcvInterrupts, walreceiver.c:150 [Standby] 2013-04-22 01:26:19 EDTLOG: 00000: shutting down [Standby] 2013-04-22 01:26:19 EDTLOCATION: ShutdownXLOG, xlog.c:7779 [Standby] 2013-04-22 01:26:19 EDTLOG: 00000: restartpoint starting: shutdown immediate [Standby] 2013-04-22 01:26:19 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Standby] 2013-04-22 01:26:19 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 01:26:19 EDTLOCATION: LogCheckpointEnd, xlog.c:7893 [Standby] 2013-04-22 01:26:19 EDTLOG: 00000: recovery restart point at 0/3000020 [Standby] 2013-04-22 01:26:19 EDTLOCATION: CreateRestartPoint, xlog.c:8601 [Standby] 2013-04-22 01:26:19 EDTLOG: 00000: database system is shut down [Standby] 2013-04-22 01:26:19 EDTLOCATION: ShutdownXLOG, xlog.c:7801 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 #### waiting for server to shut down....[Master] 2013-04-22 01:26:20 EDTLOG: 00000: received immediate shutdown request [Master] 2013-04-22 01:26:20 EDTLOCATION: pmdie, postmaster.c:2240 [Master] 2013-04-22 01:26:20 EDTWARNING: 57P02: terminating connection because of crash of another server process [Master] 2013-04-22 01:26:20 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 01:26:20 EDTHINT: In a moment you should be able to reconnect to the database and repeat your command. [Master] 2013-04-22 01:26:20 EDTLOCATION: quickdie, postgres.c:2546 done server stopped #### Sleep for 5 seconds #### #### Starting master as a standby, and next promote#### waiting for server to start....[Master] 2013-04-22 01:26:26 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 01:26:08 EDT [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6293 cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:26 EDTLOG: 00000: entering standby mode [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6359 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: checkpoint record is at 0/3000058 [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6474 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: redo record is at 0/3000020; shutdown FALSE [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6509 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6513 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6516 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6519 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 01:26:26 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 01:26:26 EDTLOG: 00000: database system was not properly shut down; automatic recovery in progress [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6589 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Master] 2013-04-22 01:26:26 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: initializing for hot standby [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6685 [Master] 2013-04-22 01:26:26 EDTLOG: 00000: redo starts at 0/3000020 [Master] 2013-04-22 01:26:26 EDTLOCATION: StartupXLOG, xlog.c:6817 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: recovery snapshots are now enabled [Master] 2013-04-22 01:26:26 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Master] 2013-04-22 01:26:26 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Master] 2013-04-22 01:26:26 EDTLOG: 00000: record with zero length at 0/30000B8 [Master] 2013-04-22 01:26:26 EDTLOCATION: ReadRecord, xlog.c:4073 [Master] 2013-04-22 01:26:26 EDTDEBUG: 00000: reached end of WAL in pg_xlog, entering archive recovery [Master] 2013-04-22 01:26:26 EDTLOCATION: ReadRecord, xlog.c:4286 [Master] 2013-04-22 01:26:26 EDTLOG: 00000: consistent recovery state reached at 0/30000B8 [Master] 2013-04-22 01:26:26 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7356 [Master] 2013-04-22 01:26:26 EDTLOG: 00000: database system is ready to accept read only connections [Master] 2013-04-22 01:26:26 EDTLOCATION: sigusr1_handler, postmaster.c:4267 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:26 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 01:26:26 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:102 done server started server promoting #### Sleep for 5 seconds #### cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:27 EDTDEBUG: 00000: record with zero length at 0/30000B8 [Master] 2013-04-22 01:26:27 EDTLOCATION: ReadRecord, xlog.c:4073 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:27 EDTLOG: 00000: received promote request [Master] 2013-04-22 01:26:27 EDTLOCATION: CheckForStandbyTrigger, xlog.c:10777 [Master] 2013-04-22 01:26:27 EDTLOG: 00000: redo done at 0/3000058 [Master] 2013-04-22 01:26:27 EDTLOCATION: StartupXLOG, xlog.c:6954 cp: cannot stat `../arc/000000010000000000000003': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000002.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:27 EDTLOG: 00000: selected new timeline ID: 2 [Master] 2013-04-22 01:26:27 EDTLOCATION: StartupXLOG, xlog.c:7062 cp: cannot stat `../arc/00000001.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:26:27 EDTLOG: 00000: archive recovery complete [Master] 2013-04-22 01:26:27 EDTLOCATION: exitArchiveRecovery, xlog.c:5862 [Master] 2013-04-22 01:26:27 EDTLOG: 00000: checkpoint starting: end-of-recovery immediate wait [Master] 2013-04-22 01:26:27 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:27 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 01:26:27 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:26:27 EDTDEBUG: 00000: resetting unlogged relations: cleanup 0 init 1 [Master] 2013-04-22 01:26:27 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 01:26:27 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 01:26:27 EDTLOCATION: reaper, postmaster.c:2408 [Master] 2013-04-22 01:26:27 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 01:26:27 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Master] 2013-04-22 01:26:27 EDTDEBUG: 00000: archived transaction log file "000000010000000000000003" [Master] 2013-04-22 01:26:27 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:27 EDTDEBUG: 00000: archived transaction log file "00000002.history" [Master] 2013-04-22 01:26:27 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:32 EDTNOTICE: 00000: table "pgbench_branches" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_branches" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTNOTICE: 00000: table "pgbench_tellers" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_tellers" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTNOTICE: 00000: table "pgbench_accounts" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTLOCATION: DropErrorMsgNonExistent, tablecmds.c:697 NOTICE: table "pgbench_accounts" does not exist, skipping [Master] 2013-04-22 01:26:32 EDTNOTICE: 00000: table "pgbench_history" does not exist, skipping [Master] 2013-04-22 01:26:32 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 01:26:32 EDTLOG: 00000: checkpoints are occurring too frequently (5 seconds apart) [Master] 2013-04-22 01:26:32 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:32 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:32 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:32 EDTLOCATION: LogCheckpointStart, xlog.c:7821 170000 tuples done. 180000 tuples done. [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: archived transaction log file "000000020000000000000003" [Master] 2013-04-22 01:26:32 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 190000 tuples done. 200000 tuples done. 210000 tuples done. [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=1.589 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12741 time=0.412 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12639 time=0.246 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12616 time=0.294 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/24579 time=1.173 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24579_fsm time=0.795 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=7 file=global/12763 time=0.732 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:32 EDTDEBUG: 00000: checkpoint sync: number=8 file=global/12763_vm time=1.313 msec [Master] 2013-04-22 01:26:32 EDTLOCATION: mdsync, md.c:1161 220000 tuples done. [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/24588 time=224.830 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/12613 time=0.304 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=11 file=global/12617 time=0.366 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12636 time=0.340 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12636_fsm time=0.284 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=14 file=global/12765 time=1.158 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=15 file=global/12766 time=0.946 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=16 file=base/12870/12738 time=0.456 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12740 time=0.381 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/12615 time=0.293 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/24576 time=0.885 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/12627 time=0.384 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12638 time=0.371 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12628 time=0.265 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 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.238 s, total=0.350 s; sync files=22, longest=0.224 s, average=0.010 s [Master] 2013-04-22 01:26:33 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. 320000 tuples done. [Master] 2013-04-22 01:26:33 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:33 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:33 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: archived transaction log file "000000020000000000000004" [Master] 2013-04-22 01:26:33 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:33 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:33 EDTLOCATION: LogCheckpointStart, xlog.c:7821 330000 tuples done. 340000 tuples done. 350000 tuples done. 360000 tuples done. [Master] 2013-04-22 01:26:33 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=188.152 msec [Master] 2013-04-22 01:26:33 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:33 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=0.106 s, sync=0.188 s, total=0.471 s; sync files=1, longest=0.188 s, average=0.188 s [Master] 2013-04-22 01:26:33 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:34 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:34 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:34 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:34 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:34 EDTLOCATION: LogCheckpointStart, xlog.c:7821 490000 tuples done. [Master] 2013-04-22 01:26:34 EDTDEBUG: 00000: archived transaction log file "000000020000000000000005" [Master] 2013-04-22 01:26:34 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 500000 tuples done. 510000 tuples done. 520000 tuples done. 530000 tuples done. [Master] 2013-04-22 01:26:34 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=209.635 msec [Master] 2013-04-22 01:26:34 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:34 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.111 s, sync=0.209 s, total=0.330 s; sync files=1, longest=0.209 s, average=0.209 s [Master] 2013-04-22 01:26:34 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 540000 tuples done. [Master] 2013-04-22 01:26:34 EDTDEBUG: 00000: archived transaction log file "000000010000000000000004" [Master] 2013-04-22 01:26:34 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 550000 tuples done. 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 01:26:34 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:34 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:34 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:34 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:34 EDTLOCATION: LogCheckpointStart, xlog.c:7821 640000 tuples done. [Master] 2013-04-22 01:26:34 EDTDEBUG: 00000: archived transaction log file "000000020000000000000006" [Master] 2013-04-22 01:26:34 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 650000 tuples done. 660000 tuples done. 670000 tuples done. 680000 tuples done. 690000 tuples done. [Master] 2013-04-22 01:26:35 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=232.802 msec [Master] 2013-04-22 01:26:35 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:35 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=0.109 s, sync=0.232 s, total=0.361 s; sync files=1, longest=0.232 s, average=0.232 s [Master] 2013-04-22 01:26:35 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:35 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:35 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:35 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:35 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:35 EDTLOCATION: LogCheckpointStart, xlog.c:7821 800000 tuples done. [Master] 2013-04-22 01:26:35 EDTDEBUG: 00000: archived transaction log file "000000020000000000000007" [Master] 2013-04-22 01:26:35 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 810000 tuples done. 820000 tuples done. 830000 tuples done. 840000 tuples done. [Master] 2013-04-22 01:26:35 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=192.241 msec [Master] 2013-04-22 01:26:35 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26: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.192 s, total=0.309 s; sync files=1, longest=0.192 s, average=0.192 s [Master] 2013-04-22 01:26:35 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 850000 tuples done. 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. 950000 tuples done. [Master] 2013-04-22 01:26:36 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:36 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:36 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:36 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:36 EDTLOCATION: LogCheckpointStart, xlog.c:7821 960000 tuples done. [Master] 2013-04-22 01:26:36 EDTDEBUG: 00000: archived transaction log file "000000020000000000000008" [Master] 2013-04-22 01:26:36 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 970000 tuples done. 980000 tuples done. 990000 tuples done. 1000000 tuples done. [Master] 2013-04-22 01:26:36 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=196.181 msec [Master] 2013-04-22 01:26:36 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:36 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.196 s, total=0.321 s; sync files=1, longest=0.196 s, average=0.196 s [Master] 2013-04-22 01:26:36 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. 1100000 tuples done. [Master] 2013-04-22 01:26:36 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:36 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:36 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:36 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:36 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:36 EDTDEBUG: 00000: archived transaction log file "000000020000000000000009" [Master] 2013-04-22 01:26:36 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1110000 tuples done. 1120000 tuples done. 1130000 tuples done. 1140000 tuples done. 1150000 tuples done. [Master] 2013-04-22 01:26:37 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=220.611 msec [Master] 2013-04-22 01:26:37 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:37 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.123 s, sync=0.220 s, total=0.353 s; sync files=1, longest=0.220 s, average=0.220 s [Master] 2013-04-22 01:26:37 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:37 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:37 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:37 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:37 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:37 EDTLOCATION: LogCheckpointStart, xlog.c:7821 1270000 tuples done. [Master] 2013-04-22 01:26:37 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000A" [Master] 2013-04-22 01:26:37 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1280000 tuples done. 1290000 tuples done. 1300000 tuples done. 1310000 tuples done. [Master] 2013-04-22 01:26:37 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=200.248 msec [Master] 2013-04-22 01:26:37 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:37 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.200 s, total=0.321 s; sync files=1, longest=0.200 s, average=0.200 s [Master] 2013-04-22 01:26:37 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. 1410000 tuples done. 1420000 tuples done. [Master] 2013-04-22 01:26:37 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:37 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:37 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:37 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:37 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:37 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000B" [Master] 2013-04-22 01:26:37 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1430000 tuples done. 1440000 tuples done. 1450000 tuples done. 1460000 tuples done. [Master] 2013-04-22 01:26:38 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=215.408 msec [Master] 2013-04-22 01:26:38 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:38 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.215 s, total=0.335 s; sync files=1, longest=0.215 s, average=0.215 s [Master] 2013-04-22 01:26:38 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:38 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:38 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:38 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:38 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:38 EDTLOCATION: LogCheckpointStart, xlog.c:7821 1570000 tuples done. 1580000 tuples done. [Master] 2013-04-22 01:26:38 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000C" [Master] 2013-04-22 01:26:38 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1590000 tuples done. 1600000 tuples done. 1610000 tuples done. [Master] 2013-04-22 01:26:38 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=238.936 msec [Master] 2013-04-22 01:26:38 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26: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.239 s, total=0.346 s; sync files=1, longest=0.238 s, average=0.238 s [Master] 2013-04-22 01:26:38 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 1620000 tuples done. 1630000 tuples done. 1640000 tuples done. 1650000 tuples done. 1660000 tuples done. 1670000 tuples done. 1680000 tuples done. 1690000 tuples done. 1700000 tuples done. 1710000 tuples done. 1720000 tuples done. [Master] 2013-04-22 01:26:39 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:39 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:39 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:39 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:39 EDTLOCATION: LogCheckpointStart, xlog.c:7821 1730000 tuples done. [Master] 2013-04-22 01:26:39 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000D" [Master] 2013-04-22 01:26:39 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1740000 tuples done. 1750000 tuples done. 1760000 tuples done. [Master] 2013-04-22 01:26:39 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=210.027 msec [Master] 2013-04-22 01:26:39 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:39 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.210 s, total=0.318 s; sync files=1, longest=0.210 s, average=0.210 s [Master] 2013-04-22 01:26:39 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 1770000 tuples done. 1780000 tuples done. 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 01:26:39 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:39 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:39 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:39 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:39 EDTLOCATION: LogCheckpointStart, xlog.c:7821 1890000 tuples done. [Master] 2013-04-22 01:26:39 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000E" [Master] 2013-04-22 01:26:39 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 1900000 tuples done. 1910000 tuples done. 1920000 tuples done. 1930000 tuples done. [Master] 2013-04-22 01:26:40 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=243.010 msec [Master] 2013-04-22 01:26:40 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26: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.243 s, total=0.355 s; sync files=1, longest=0.243 s, average=0.243 s [Master] 2013-04-22 01:26:40 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:40 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:40 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:40 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:40 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:40 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2040000 tuples done. [Master] 2013-04-22 01:26:40 EDTDEBUG: 00000: archived transaction log file "00000002000000000000000F" [Master] 2013-04-22 01:26:40 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2050000 tuples done. 2060000 tuples done. 2070000 tuples done. 2080000 tuples done. [Master] 2013-04-22 01:26:40 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=191.043 msec [Master] 2013-04-22 01:26:40 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:40 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.191 s, total=0.302 s; sync files=1, longest=0.191 s, average=0.191 s [Master] 2013-04-22 01:26:40 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 2090000 tuples done. 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 01:26:41 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:41 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:41 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:41 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:41 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2200000 tuples done. [Master] 2013-04-22 01:26:41 EDTDEBUG: 00000: archived transaction log file "000000020000000000000010" [Master] 2013-04-22 01:26:41 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2210000 tuples done. 2220000 tuples done. 2230000 tuples done. 2240000 tuples done. 2250000 tuples done. 2260000 tuples done. [Master] 2013-04-22 01:26:41 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=260.479 msec [Master] 2013-04-22 01:26:41 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:41 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.111 s, sync=0.260 s, total=0.389 s; sync files=1, longest=0.260 s, average=0.260 s [Master] 2013-04-22 01:26:41 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:41 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:41 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:41 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:41 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:41 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:41 EDTDEBUG: 00000: archived transaction log file "000000020000000000000011" [Master] 2013-04-22 01:26:41 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2360000 tuples done. 2370000 tuples done. 2380000 tuples done. 2390000 tuples done. [Master] 2013-04-22 01:26:42 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=269.003 msec [Master] 2013-04-22 01:26:42 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:42 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.162 s, sync=0.269 s, total=0.439 s; sync files=1, longest=0.269 s, average=0.269 s [Master] 2013-04-22 01:26:42 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 2400000 tuples done. 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 01:26:42 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:42 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:42 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:42 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:42 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2510000 tuples done. 2520000 tuples done. [Master] 2013-04-22 01:26:42 EDTDEBUG: 00000: archived transaction log file "000000020000000000000012" [Master] 2013-04-22 01:26:42 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2530000 tuples done. 2540000 tuples done. 2550000 tuples done. [Master] 2013-04-22 01:26:42 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=224.596 msec [Master] 2013-04-22 01:26:42 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:42 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.224 s, total=0.338 s; sync files=1, longest=0.224 s, average=0.224 s [Master] 2013-04-22 01:26:42 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:43 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:43 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:43 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:43 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:43 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2670000 tuples done. 2680000 tuples done. [Master] 2013-04-22 01:26:43 EDTDEBUG: 00000: archived transaction log file "000000020000000000000013" [Master] 2013-04-22 01:26:43 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2690000 tuples done. 2700000 tuples done. 2710000 tuples done. 2720000 tuples done. [Master] 2013-04-22 01:26:43 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=265.304 msec [Master] 2013-04-22 01:26:43 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:43 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.265 s, total=0.381 s; sync files=1, longest=0.265 s, average=0.265 s [Master] 2013-04-22 01:26:43 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:44 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:44 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:44 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:44 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:44 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2820000 tuples done. 2830000 tuples done. [Master] 2013-04-22 01:26:44 EDTDEBUG: 00000: archived transaction log file "000000020000000000000014" [Master] 2013-04-22 01:26:44 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2840000 tuples done. 2850000 tuples done. 2860000 tuples done. [Master] 2013-04-22 01:26:44 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=186.154 msec [Master] 2013-04-22 01:26:44 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:44 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.186 s, total=0.296 s; sync files=1, longest=0.186 s, average=0.186 s [Master] 2013-04-22 01:26:44 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 2870000 tuples done. 2880000 tuples done. 2890000 tuples done. 2900000 tuples done. 2910000 tuples done. 2920000 tuples done. 2930000 tuples done. 2940000 tuples done. 2950000 tuples done. 2960000 tuples done. 2970000 tuples done. [Master] 2013-04-22 01:26:44 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:44 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:44 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:44 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:44 EDTLOCATION: LogCheckpointStart, xlog.c:7821 2980000 tuples done. [Master] 2013-04-22 01:26:44 EDTDEBUG: 00000: archived transaction log file "000000020000000000000015" [Master] 2013-04-22 01:26:44 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 2990000 tuples done. 3000000 tuples done. 3010000 tuples done. 3020000 tuples done. [Master] 2013-04-22 01:26:44 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=223.511 msec [Master] 2013-04-22 01:26:44 EDTLOCATION: mdsync, md.c:1161 3030000 tuples done. [Master] 2013-04-22 01:26:44 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.223 s, total=0.341 s; sync files=1, longest=0.223 s, average=0.223 s [Master] 2013-04-22 01:26:44 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:45 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:45 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:45 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:45 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:45 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3140000 tuples done. 3150000 tuples done. [Master] 2013-04-22 01:26:45 EDTDEBUG: 00000: archived transaction log file "000000020000000000000016" [Master] 2013-04-22 01:26:45 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3160000 tuples done. 3170000 tuples done. 3180000 tuples done. 3190000 tuples done. [Master] 2013-04-22 01:26:45 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=249.621 msec [Master] 2013-04-22 01:26:45 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:45 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.249 s, total=0.361 s; sync files=1, longest=0.249 s, average=0.249 s [Master] 2013-04-22 01:26:45 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. 3290000 tuples done. [Master] 2013-04-22 01:26:45 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:45 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:45 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:45 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:45 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3300000 tuples done. [Master] 2013-04-22 01:26:45 EDTDEBUG: 00000: archived transaction log file "000000020000000000000017" [Master] 2013-04-22 01:26:45 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3310000 tuples done. 3320000 tuples done. 3330000 tuples done. [Master] 2013-04-22 01:26:46 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=219.124 msec [Master] 2013-04-22 01:26:46 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:46 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.219 s, total=0.334 s; sync files=1, longest=0.219 s, average=0.219 s [Master] 2013-04-22 01:26:46 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:46 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:46 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:46 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:46 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:46 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3450000 tuples done. [Master] 2013-04-22 01:26:46 EDTDEBUG: 00000: archived transaction log file "000000020000000000000018" [Master] 2013-04-22 01:26:46 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3460000 tuples done. 3470000 tuples done. 3480000 tuples done. [Master] 2013-04-22 01:26:46 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=360.401 msec [Master] 2013-04-22 01:26:46 EDTLOCATION: mdsync, md.c:1161 3490000 tuples done. [Master] 2013-04-22 01:26:46 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.360 s, total=0.468 s; sync files=1, longest=0.360 s, average=0.360 s [Master] 2013-04-22 01:26:46 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 3500000 tuples done. 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 01:26:47 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:47 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:47 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:47 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:47 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3610000 tuples done. [Master] 2013-04-22 01:26:47 EDTDEBUG: 00000: archived transaction log file "000000020000000000000019" [Master] 2013-04-22 01:26:47 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3620000 tuples done. 3630000 tuples done. 3640000 tuples done. 3650000 tuples done. [Master] 2013-04-22 01:26:47 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=213.900 msec [Master] 2013-04-22 01:26:47 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:47 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.214 s, total=0.333 s; sync files=1, longest=0.213 s, average=0.213 s [Master] 2013-04-22 01:26:47 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:47 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:47 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:47 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:47 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:47 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3760000 tuples done. [Master] 2013-04-22 01:26:47 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001A" [Master] 2013-04-22 01:26:47 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3770000 tuples done. 3780000 tuples done. 3790000 tuples done. [Master] 2013-04-22 01:26:48 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=215.017 msec [Master] 2013-04-22 01:26:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:48 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.215 s, total=0.325 s; sync files=1, longest=0.215 s, average=0.215 s [Master] 2013-04-22 01:26:48 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 3800000 tuples done. 3810000 tuples done. 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. 3910000 tuples done. [Master] 2013-04-22 01:26:48 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:48 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:48 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:48 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:48 EDTLOCATION: LogCheckpointStart, xlog.c:7821 3920000 tuples done. [Master] 2013-04-22 01:26:48 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001B" [Master] 2013-04-22 01:26:48 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 3930000 tuples done. 3940000 tuples done. 3950000 tuples done. 3960000 tuples done. [Master] 2013-04-22 01:26:48 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=228.314 msec [Master] 2013-04-22 01:26:48 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:48 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.228 s, total=0.347 s; sync files=1, longest=0.228 s, average=0.228 s [Master] 2013-04-22 01:26:48 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:49 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:49 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:49 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:49 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:49 EDTLOCATION: LogCheckpointStart, xlog.c:7821 4080000 tuples done. [Master] 2013-04-22 01:26:49 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001C" [Master] 2013-04-22 01:26:49 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4090000 tuples done. 4100000 tuples done. 4110000 tuples done. 4120000 tuples done. [Master] 2013-04-22 01:26:49 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=191.679 msec [Master] 2013-04-22 01:26:49 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:49 EDTLOG: 00000: checkpoint complete: wrote 1 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.112 s, sync=0.191 s, total=0.323 s; sync files=1, longest=0.191 s, average=0.191 s [Master] 2013-04-22 01:26:49 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:49 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:49 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:49 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:49 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:49 EDTLOCATION: LogCheckpointStart, xlog.c:7821 4230000 tuples done. 4240000 tuples done. [Master] 2013-04-22 01:26:49 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001D" [Master] 2013-04-22 01:26:49 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4250000 tuples done. 4260000 tuples done. 4270000 tuples done. [Master] 2013-04-22 01:26:50 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=198.771 msec [Master] 2013-04-22 01:26:50 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:50 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.198 s, total=0.312 s; sync files=1, longest=0.198 s, average=0.198 s [Master] 2013-04-22 01:26:50 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. 4380000 tuples done. [Master] 2013-04-22 01:26:50 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:50 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:50 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:50 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:50 EDTLOCATION: LogCheckpointStart, xlog.c:7821 4390000 tuples done. [Master] 2013-04-22 01:26:50 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001E" [Master] 2013-04-22 01:26:50 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4400000 tuples done. 4410000 tuples done. 4420000 tuples done. 4430000 tuples done. 4440000 tuples done. [Master] 2013-04-22 01:26:50 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=249.653 msec [Master] 2013-04-22 01:26:50 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:50 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.249 s, total=0.364 s; sync files=1, longest=0.249 s, average=0.249 s [Master] 2013-04-22 01:26:50 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:51 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:51 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:51 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:51 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:51 EDTLOCATION: LogCheckpointStart, xlog.c:7821 4540000 tuples done. [Master] 2013-04-22 01:26:51 EDTDEBUG: 00000: archived transaction log file "00000002000000000000001F" [Master] 2013-04-22 01:26:51 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4550000 tuples done. 4560000 tuples done. 4570000 tuples done. 4580000 tuples done. [Master] 2013-04-22 01:26:51 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=195.460 msec [Master] 2013-04-22 01:26:51 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:51 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.195 s, total=0.307 s; sync files=1, longest=0.195 s, average=0.195 s [Master] 2013-04-22 01:26:51 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 4590000 tuples done. 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. 4700000 tuples done. [Master] 2013-04-22 01:26:51 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:51 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:51 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:51 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:51 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:51 EDTDEBUG: 00000: archived transaction log file "000000020000000000000020" [Master] 2013-04-22 01:26:51 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4710000 tuples done. 4720000 tuples done. 4730000 tuples done. 4740000 tuples done. [Master] 2013-04-22 01:26:52 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=241.512 msec [Master] 2013-04-22 01:26:52 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:52 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.241 s, total=0.359 s; sync files=1, longest=0.241 s, average=0.241 s [Master] 2013-04-22 01:26:52 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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. [Master] 2013-04-22 01:26:52 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:26:52 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:52 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:52 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:52 EDTLOCATION: LogCheckpointStart, xlog.c:7821 4850000 tuples done. 4860000 tuples done. [Master] 2013-04-22 01:26:52 EDTDEBUG: 00000: archived transaction log file "000000020000000000000021" [Master] 2013-04-22 01:26:52 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 4870000 tuples done. 4880000 tuples done. 4890000 tuples done. 4900000 tuples done. [Master] 2013-04-22 01:26:52 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=201.674 msec [Master] 2013-04-22 01:26:52 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:26:52 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.201 s, total=0.311 s; sync files=1, longest=0.201 s, average=0.201 s [Master] 2013-04-22 01:26:52 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 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 01:26:52 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:26:52 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:26:52 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:26:52 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:26:52 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:26:52 EDTLOG: 00000: duration: 20442.294 ms statement: copy pgbench_accounts from stdin [Master] 2013-04-22 01:26:52 EDTLOCATION: exec_simple_query, postgres.c:1123 set primary key... [Master] 2013-04-22 01:26:52 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_branches_pkey" for table "pgbench_branches" [Master] 2013-04-22 01:26:52 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 01:26:52 EDTDEBUG: 00000: building index "pgbench_branches_pkey" on table "pgbench_branches" [Master] 2013-04-22 01:26:52 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 01:26:52 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_tellers_pkey" for table "pgbench_tellers" [Master] 2013-04-22 01:26:52 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 01:26:52 EDTDEBUG: 00000: building index "pgbench_tellers_pkey" on table "pgbench_tellers" [Master] 2013-04-22 01:26:52 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 01:26:52 EDTNOTICE: 00000: ALTER TABLE / ADD PRIMARY KEY will create implicit index "pgbench_accounts_pkey" for table "pgbench_accounts" [Master] 2013-04-22 01:26:52 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 01:26:52 EDTDEBUG: 00000: building index "pgbench_accounts_pkey" on table "pgbench_accounts" [Master] 2013-04-22 01:26:52 EDTLOCATION: index_build, index.c:1965 [Master] 2013-04-22 01:26:52 EDTDEBUG: 00000: archived transaction log file "000000020000000000000022" [Master] 2013-04-22 01:26:52 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:26:57 EDTDEBUG: 00000: archived transaction log file "000000020000000000000023" [Master] 2013-04-22 01:26:57 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:02 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=5803.404 msec [Master] 2013-04-22 01:27:02 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:02 EDTLOG: 00000: checkpoint complete: wrote 493 buffers (12.0%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=4.300 s, sync=5.803 s, total=10.106 s; sync files=1, longest=5.803 s, average=5.803 s [Master] 2013-04-22 01:27:02 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:02 EDTLOG: 00000: checkpoints are occurring too frequently (10 seconds apart) [Master] 2013-04-22 01:27:02 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:02 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:02 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:02 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: archived transaction log file "000000020000000000000024" [Master] 2013-04-22 01:27:03 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=3.313 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12647 time=0.251 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12647_vm time=0.223 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12741 time=0.364 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12639 time=0.223 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/12663 time=0.411 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12662 time=0.218 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/12655 time=0.261 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/24579 time=0.213 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24588 time=7.166 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/12636 time=0.371 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12636_fsm time=0.183 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12738 time=0.145 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/12740 time=0.444 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=15 file=base/12870/12654 time=0.211 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=16 file=base/12870/12652 time=0.310 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12660 time=0.377 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/24576 time=0.525 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/12627 time=0.351 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/12653 time=1.465 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12638 time=0.209 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12628 time=0.507 msec [Master] 2013-04-22 01:27:03 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoint complete: wrote 130 buffers (3.2%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.102 s, sync=0.018 s, total=0.223 s; sync files=22, longest=0.007 s, average=0.000 s [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:27:03 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:03 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 2 recycled; write=0.000 s, sync=0.000 s, total=0.010 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: archived transaction log file "000000020000000000000025" [Master] 2013-04-22 01:27:03 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:27:03 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:03 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:03 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.014 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: archived transaction log file "000000020000000000000026" [Master] 2013-04-22 01:27:03 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoints are occurring too frequently (0 seconds apart) [Master] 2013-04-22 01:27:03 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:03 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:03 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:03 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:03 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 01:27:03 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:03 EDTDEBUG: 00000: archived transaction log file "000000020000000000000027" [Master] 2013-04-22 01:27:03 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:04 EDTLOG: 00000: checkpoints are occurring too frequently (1 second apart) [Master] 2013-04-22 01:27:04 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:04 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:04 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:04 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:04 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.013 s; sync files=0, longest=0.000 s, average=0.000 s [Master] 2013-04-22 01:27:04 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:04 EDTDEBUG: 00000: archived transaction log file "000000020000000000000028" [Master] 2013-04-22 01:27:04 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 vacuum...[Master] 2013-04-22 01:27:06 EDTLOG: 00000: checkpoints are occurring too frequently (2 seconds apart) [Master] 2013-04-22 01:27:06 EDTHINT: Consider increasing the configuration parameter "checkpoint_segments". [Master] 2013-04-22 01:27:06 EDTLOCATION: CheckpointerMain, checkpointer.c:489 [Master] 2013-04-22 01:27:06 EDTLOG: 00000: checkpoint starting: xlog [Master] 2013-04-22 01:27:06 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:06 EDTDEBUG: 00000: archived transaction log file "000000020000000000000029" [Master] 2013-04-22 01:27:06 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:07 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Master] 2013-04-22 01:27:07 EDTCONTEXT: writing block 70715 of relation base/12870/24588 [Master] 2013-04-22 01:27:07 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Master] 2013-04-22 01:27:07 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Master] 2013-04-22 01:27:07 EDTCONTEXT: writing block 74808 of relation base/12870/24588 [Master] 2013-04-22 01:27:07 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Master] 2013-04-22 01:27:07 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Master] 2013-04-22 01:27:07 EDTCONTEXT: writing block 78901 of relation base/12870/24588 [Master] 2013-04-22 01:27:07 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 done. #### Shutdown master in immediate mode #### waiting for server to shut down....[Master] 2013-04-22 01:27:07 EDTLOG: 00000: received immediate shutdown request [Master] 2013-04-22 01:27:07 EDTLOCATION: pmdie, postmaster.c:2240 [Master] 2013-04-22 01:27:07 EDTWARNING: 57P02: terminating connection because of crash of another server process [Master] 2013-04-22 01:27:07 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 01:27:07 EDTHINT: In a moment you should be able to reconnect to the database and repeat your command. [Master] 2013-04-22 01:27:07 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 01:27:10 EDTLOG: 00000: database system was interrupted; last known up at 2013-04-22 01:27:04 EDT [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6293 [Master] 2013-04-22 01:27:10 EDTFATAL: 57P03: the database system is starting up [Master] 2013-04-22 01:27:10 EDTLOCATION: ProcessStartupPacket, postmaster.c:1764 .cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:10 EDTLOG: 00000: restored log file "00000002.history" from archive [Master] 2013-04-22 01:27:10 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Master] 2013-04-22 01:27:10 EDTLOG: 00000: entering standby mode [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6359 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: checkpoint record is at 0/29101018 [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6474 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: redo record is at 0/290FEF58; shutdown FALSE [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6509 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: next transaction ID: 0/1818; next OID: 32768 [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6513 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6516 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6519 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Master] 2013-04-22 01:27:10 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Master] 2013-04-22 01:27:10 EDTLOG: 00000: database system was not properly shut down; automatic recovery in progress [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6589 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Master] 2013-04-22 01:27:10 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: initializing for hot standby [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6685 [Master] 2013-04-22 01:27:10 EDTLOG: 00000: redo starts at 0/290FEF58 [Master] 2013-04-22 01:27:10 EDTLOCATION: StartupXLOG, xlog.c:6817 [Master] 2013-04-22 01:27:10 EDTDEBUG: 00000: recovery snapshots are now enabled [Master] 2013-04-22 01:27:10 EDTCONTEXT: xlog redo running xacts: nextXid 1818 latestCompletedXid 1816 oldestRunningXid 1817; 1 xacts: 1817 [Master] 2013-04-22 01:27:10 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Master] 2013-04-22 01:27:11 EDTFATAL: 57P03: the database system is starting up [Master] 2013-04-22 01:27:11 EDTLOCATION: ProcessStartupPacket, postmaster.c:1764 .[Master] 2013-04-22 01:27:12 EDTLOG: 00000: record with zero length at 0/2A0FC618 [Master] 2013-04-22 01:27:12 EDTLOCATION: ReadRecord, xlog.c:4073 [Master] 2013-04-22 01:27:12 EDTDEBUG: 00000: reached end of WAL in pg_xlog, entering archive recovery [Master] 2013-04-22 01:27:12 EDTLOCATION: ReadRecord, xlog.c:4286 [Master] 2013-04-22 01:27:12 EDTFATAL: 57P03: the database system is starting up [Master] 2013-04-22 01:27:12 EDTLOCATION: ProcessStartupPacket, postmaster.c:1764 .[Master] 2013-04-22 01:27:12 EDTLOG: 00000: consistent recovery state reached at 0/2A0FC618 [Master] 2013-04-22 01:27:12 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7356 [Master] 2013-04-22 01:27:12 EDTLOG: 00000: database system is ready to accept read only connections [Master] 2013-04-22 01:27:12 EDTLOCATION: sigusr1_handler, postmaster.c:4267 cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:12 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 01:27:12 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:102 done server started server promoting #### Sleep for 5 seconds #### cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:13 EDTDEBUG: 00000: record with zero length at 0/2A0FC618 [Master] 2013-04-22 01:27:13 EDTLOCATION: ReadRecord, xlog.c:4073 cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:13 EDTLOG: 00000: received promote request [Master] 2013-04-22 01:27:13 EDTLOCATION: CheckForStandbyTrigger, xlog.c:10777 [Master] 2013-04-22 01:27:13 EDTLOG: 00000: redo done at 0/2A0FC568 [Master] 2013-04-22 01:27:13 EDTLOCATION: StartupXLOG, xlog.c:6954 [Master] 2013-04-22 01:27:13 EDTLOG: 00000: last completed transaction was at log time 2013-04-22 01:27:07.615281-04 [Master] 2013-04-22 01:27:13 EDTLOCATION: StartupXLOG, xlog.c:6959 cp: cannot stat `../arc/00000002000000000000002A': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000003.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:13 EDTLOG: 00000: selected new timeline ID: 3 [Master] 2013-04-22 01:27:13 EDTLOCATION: StartupXLOG, xlog.c:7062 [Master] 2013-04-22 01:27:13 EDTLOG: 00000: restored log file "00000002.history" from archive [Master] 2013-04-22 01:27:13 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Master] 2013-04-22 01:27:13 EDTLOG: 00000: archive recovery complete [Master] 2013-04-22 01:27:13 EDTLOCATION: exitArchiveRecovery, xlog.c:5862 [Master] 2013-04-22 01:27:13 EDTLOG: 00000: checkpoint starting: end-of-recovery immediate wait [Master] 2013-04-22 01:27:13 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Master] 2013-04-22 01:27:13 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12612 time=1.344 msec [Master] 2013-04-22 01:27:13 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:13 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24579 time=0.005 msec [Master] 2013-04-22 01:27:13 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:13 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/24579_vm time=0.002 msec [Master] 2013-04-22 01:27:13 EDTLOCATION: mdsync, md.c:1161 #### Was latest .history file archived ??? #### [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/24588 time=4615.370 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/24588_vm time=0.005 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24589 time=0.003 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/12607 time=0.440 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=8 file=base/12870/12607_fsm time=0.361 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=9 file=base/12870/12607_vm time=0.003 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/12636 time=0.445 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/24591 time=0.003 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/24593 time=0.365 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/24576 time=0.004 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/24576_vm time=0.003 msec [Master] 2013-04-22 01:27:18 EDTLOCATION: mdsync, md.c:1161 [Master] 2013-04-22 01:27:18 EDTLOG: 00000: checkpoint complete: wrote 6 buffers (0.1%); 0 transaction log file(s) added, 0 removed, 1 recycled; write=0.000 s, sync=4.618 s, total=4.639 s; sync files=14, longest=4.615 s, average=0.329 s [Master] 2013-04-22 01:27:18 EDTLOCATION: LogCheckpointEnd, xlog.c:7909 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: resetting unlogged relations: cleanup 0 init 1 [Master] 2013-04-22 01:27:18 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Master] 2013-04-22 01:27:18 EDTLOG: 00000: database system is ready to accept connections [Master] 2013-04-22 01:27:18 EDTLOCATION: reaper, postmaster.c:2408 [Master] 2013-04-22 01:27:18 EDTLOG: 00000: autovacuum launcher started [Master] 2013-04-22 01:27:18 EDTLOCATION: AutoVacLauncherMain, autovacuum.c:407 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: archived transaction log file "00000002000000000000002A" [Master] 2013-04-22 01:27:18 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 [Master] 2013-04-22 01:27:18 EDTDEBUG: 00000: archived transaction log file "00000003.history" [Master] 2013-04-22 01:27:18 EDTLOCATION: pgarch_archiveXlog, pgarch.c:652 #### Starting standby #### waiting for server to start....[Standby] 2013-04-22 01:27:20 EDTLOG: 00000: database system was shut down in recovery at 2013-04-22 01:26:19 EDT [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6273 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "00000002.history" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "00000003.history" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "00000003.history" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: entering standby mode [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6359 cp: cannot stat `../arc/000000030000000000000003': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000003" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: checkpoint record is at 0/3000058 [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6474 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: redo record is at 0/3000020; shutdown FALSE [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6509 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: next transaction ID: 0/1809; next OID: 24576 [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6513 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: next MultiXactId: 1; next MultiXactOffset: 0 [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6516 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: oldest unfrozen transaction ID: 1798, in database 1 [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6519 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 01:27:20 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: resetting unlogged relations: cleanup 1 init 0 [Standby] 2013-04-22 01:27:20 EDTLOCATION: ResetUnloggedRelations, reinit.c:57 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: initializing for hot standby [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6685 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: consistent recovery state reached at 0/30000B8 [Standby] 2013-04-22 01:27:20 EDTLOCATION: CheckRecoveryConsistency, xlog.c:7356 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: redo starts at 0/3000020 [Standby] 2013-04-22 01:27:20 EDTLOCATION: StartupXLOG, xlog.c:6817 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: recovery snapshots are now enabled [Standby] 2013-04-22 01:27:20 EDTCONTEXT: xlog redo running xacts: nextXid 1809 latestCompletedXid 1808 oldestRunningXid 1809 [Standby] 2013-04-22 01:27:20 EDTLOCATION: ProcArrayApplyRecoveryInfo, procarray.c:692 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: database system is ready to accept read only connections [Standby] 2013-04-22 01:27:20 EDTLOCATION: sigusr1_handler, postmaster.c:4267 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: transaction ID wrap limit is 2147485445, limited by database with OID 1 [Standby] 2013-04-22 01:27:20 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 01:27:20 EDTLOCATION: SetTransactionIdLimit, varsup.c:334 [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 01:27:20 EDTLOCATION: LogCheckpointStart, xlog.c:7821 cp: cannot stat `../arc/000000030000000000000004': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000004" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000005': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000005" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000006': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000006" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000007': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000007" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000008': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:20 EDTLOG: 00000: restored log file "000000020000000000000008" from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:20 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:20 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/12625 time=0.470 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/12625_fsm time=0.253 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12741 time=0.418 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=4 file=base/12870/12639 time=0.230 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=5 file=base/12870/12616 time=0.336 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=6 file=base/12870/24579 time=0.862 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=7 file=base/12870/24579_fsm time=1.017 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=8 file=global/12763 time=0.217 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: checkpoint sync: number=9 file=global/12763_vm time=0.190 msec [Standby] 2013-04-22 01:27:21 EDTLOCATION: mdsync, md.c:1161 done server started [mitsu-ko@localhost postgresql-9.2.4]$ cp: cannot stat `../arc/000000030000000000000009': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:21 EDTLOG: 00000: restored log file "000000020000000000000009" from archive [Standby] 2013-04-22 01:27:21 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:21 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:21 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 01:27:21 EDTCONTEXT: xlog redo multi-insert (init): rel 1663/12870/24588; blk 16490; 61 tuples [Standby] 2013-04-22 01:27:21 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=10 file=base/12870/24588 time=1130.027 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=11 file=base/12870/24588_fsm time=2.710 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=12 file=base/12870/12613 time=0.721 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=13 file=base/12870/12636 time=1.107 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=14 file=base/12870/12636_fsm time=0.519 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=15 file=global/12765 time=0.380 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=16 file=global/12766 time=0.993 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=17 file=base/12870/12738 time=0.582 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=18 file=base/12870/12740 time=0.629 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=19 file=base/12870/12615 time=0.260 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=20 file=base/12870/24576 time=2.734 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=21 file=base/12870/12627 time=0.546 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=22 file=base/12870/12638 time=0.317 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: checkpoint sync: number=23 file=base/12870/12628 time=0.380 msec [Standby] 2013-04-22 01:27:22 EDTLOCATION: mdsync, md.c:1161 cp: cannot stat `../arc/00000003000000000000000A': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000A" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 01:27:22 EDTCONTEXT: writing block 16006 of relation base/12870/24588 xlog redo multi-insert (init): rel 1663/12870/24588; blk 19922; 61 tuples [Standby] 2013-04-22 01:27:22 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 cp: cannot stat `../arc/00000003000000000000000B': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restartpoint complete: wrote 9 buffers (0.2%); 1 transaction log file(s) added, 0 removed, 1 recycled; write=0.637 s, sync=1.147 s, total=1.976 s; sync files=23, longest=1.130 s, average=0.049 s [Standby] 2013-04-22 01:27:22 EDTLOCATION: LogCheckpointEnd, xlog.c:7893 [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: recovery restart point at 0/30000B8 [Standby] 2013-04-22 01:27:22 EDTDETAIL: last completed transaction was at log time 2013-04-22 01:26:32.439575-04 [Standby] 2013-04-22 01:27:22 EDTLOCATION: CreateRestartPoint, xlog.c:8601 [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 01:27:22 EDTLOCATION: LogCheckpointStart, xlog.c:7821 [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000B" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/00000003000000000000000C': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000C" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/00000003000000000000000D': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000D" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/00000003000000000000000E': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000E" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/00000003000000000000000F': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:22 EDTLOG: 00000: restored log file "00000002000000000000000F" from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:22 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:22 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=1197.599 msec [Standby] 2013-04-22 01:27:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=10.557 msec [Standby] 2013-04-22 01:27:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: checkpoint sync: number=3 file=base/12870/12636 time=0.443 msec [Standby] 2013-04-22 01:27:24 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: restartpoint complete: wrote 8 buffers (0.2%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.541 s, sync=1.208 s, total=1.752 s; sync files=3, longest=1.197 s, average=0.402 s [Standby] 2013-04-22 01:27:24 EDTLOCATION: LogCheckpointEnd, xlog.c:7893 [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: recovery restart point at 0/A101A68 [Standby] 2013-04-22 01:27:24 EDTDETAIL: last completed transaction was at log time 2013-04-22 01:26:32.439575-04 [Standby] 2013-04-22 01:27:24 EDTLOCATION: CreateRestartPoint, xlog.c:8601 [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 01:27:24 EDTLOCATION: LogCheckpointStart, xlog.c:7821 cp: cannot stat `../arc/000000030000000000000010': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: restored log file "000000020000000000000010" from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000011': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: restored log file "000000020000000000000011" from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000012': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:24 EDTLOG: 00000: restored log file "000000020000000000000012" from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:24 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:24 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 cp: cannot stat `../arc/000000030000000000000013': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: restored log file "000000020000000000000013" from archive [Standby] 2013-04-22 01:27:25 EDTLOCATION: RestoreArchivedFile, xlog.c:3273 [Standby] 2013-04-22 01:27:25 EDTDEBUG: 00000: got WAL segment from archive [Standby] 2013-04-22 01:27:25 EDTLOCATION: XLogFileReadAnyTLI, xlog.c:2930 [Standby] 2013-04-22 01:27:25 EDTDEBUG: 00000: compacted fsync request queue from 4096 entries to 2 entries [Standby] 2013-04-22 01:27:25 EDTCONTEXT: xlog redo multi-insert (init): rel 1663/12870/24588; blk 41575; 61 tuples [Standby] 2013-04-22 01:27:25 EDTLOCATION: CompactCheckpointerRequestQueue, checkpointer.c:1288 [Standby] 2013-04-22 01:27:25 EDTDEBUG: 00000: checkpoint sync: number=1 file=base/12870/24588 time=822.092 msec [Standby] 2013-04-22 01:27:25 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:25 EDTDEBUG: 00000: checkpoint sync: number=2 file=base/12870/24588_fsm time=0.908 msec [Standby] 2013-04-22 01:27:25 EDTLOCATION: mdsync, md.c:1161 [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: restartpoint complete: wrote 6 buffers (0.1%); 0 transaction log file(s) added, 3 removed, 4 recycled; write=0.437 s, sync=0.823 s, total=1.274 s; sync files=2, longest=0.822 s, average=0.411 s [Standby] 2013-04-22 01:27:25 EDTLOCATION: LogCheckpointEnd, xlog.c:7893 [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: recovery restart point at 0/F0FF8D0 [Standby] 2013-04-22 01:27:25 EDTDETAIL: last completed transaction was at log time 2013-04-22 01:26:32.439575-04 [Standby] 2013-04-22 01:27:25 EDTLOCATION: CreateRestartPoint, xlog.c:8601 [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: restartpoint starting: xlog [Standby] 2013-04-22 01:27:25 EDTLOCATION: LogCheckpointStart, xlog.c:7821 cp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: unexpected pageaddr 0/6000000 in log file 0, segment 20, offset 0 [Standby] 2013-04-22 01:27:25 EDTLOCATION: ValidXLOGHeader, xlog.c:4395 cp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:25 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:27:25 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:25 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/14000000 [Master] 2013-04-22 01:27:25 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:25 EDTFATAL: 58P01: requested WAL segment 000000030000000000000014 has already been removed [Master] 2013-04-22 01:27:25 EDTLOCATION: XLogRead, walsender.c:1023 [Standby] 2013-04-22 01:27:25 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 01:27:25 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 [Standby] 2013-04-22 01:27:25 EDTFATAL: XX000: could not receive data from WAL stream: FATAL: requested WAL segment 000000030000000000000014 has already been removed [Standby] 2013-04-22 01:27:25 EDTLOCATION: libpqrcv_receive, libpqwalreceiver.c:389 [mitsu-ko@localhost postgresql-9.2.4]$ bincp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:30 EDTDEBUG: 00000: unexpected pageaddr 0/6000000 in log file 0, segment 20, offset 0 [Standby] 2013-04-22 01:27:30 EDTLOCATION: ValidXLOGHeader, xlog.c:4395 cp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:30 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:27:30 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:30 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/14000000 [Master] 2013-04-22 01:27:30 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:30 EDTFATAL: 58P01: requested WAL segment 000000030000000000000014 has already been removed [Master] 2013-04-22 01:27:30 EDTLOCATION: XLogRead, walsender.c:1023 [Standby] 2013-04-22 01:27:30 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 01:27:30 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 [Standby] 2013-04-22 01:27:30 EDTFATAL: XX000: could not receive data from WAL stream: FATAL: requested WAL segment 000000030000000000000014 has already been removed [Standby] 2013-04-22 01:27:30 EDTLOCATION: libpqrcv_receive, libpqwalreceiver.c:389 /pg_ctl -D Standby cp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません [Standby] 2013-04-22 01:27:35 EDTDEBUG: 00000: unexpected pageaddr 0/6000000 in log file 0, segment 20, offset 0 [Standby] 2013-04-22 01:27:35 EDTLOCATION: ValidXLOGHeader, xlog.c:4395 cp: cannot stat `../arc/000000030000000000000014': そのようなファイルやディレクトリはありません cp: cannot stat `../arc/00000004.history': そのようなファイルやディレクトリはありません [Master] 2013-04-22 01:27:35 EDTDEBUG: 00000: received replication command: IDENTIFY_SYSTEM [Master] 2013-04-22 01:27:35 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:35 EDTDEBUG: 00000: received replication command: START_REPLICATION 0/14000000 [Master] 2013-04-22 01:27:35 EDTLOCATION: HandleReplicationCommand, walsender.c:449 [Master] 2013-04-22 01:27:35 EDTFATAL: 58P01: requested WAL segment 000000030000000000000014 has already been removed [Master] 2013-04-22 01:27:35 EDTLOCATION: XLogRead, walsender.c:1023 [Standby] 2013-04-22 01:27:35 EDTLOG: 00000: streaming replication successfully connected to primary [Standby] 2013-04-22 01:27:35 EDTLOCATION: libpqrcv_connect, libpqwalreceiver.c:171 [Standby] 2013-04-22 01:27:35 EDTFATAL: XX000: could not receive data from WAL stream: FATAL: requested WAL segment 000000030000000000000014 has already been removed [Standby] 2013-04-22 01:27:35 EDTLOCATION: libpqrcv_receive, libpqwalreceiver.c:389 ### achive WAL file is here [mitsu-ko@localhost postgresql-9.2.4]$ ls arc/ 000000010000000000000001 00000002000000000000000D 00000002000000000000001D 000000010000000000000002 00000002000000000000000E 00000002000000000000001E 000000010000000000000002.00000020.backup 00000002000000000000000F 00000002000000000000001F 000000010000000000000003 000000020000000000000010 000000020000000000000020 000000010000000000000004 000000020000000000000011 000000020000000000000021 00000002.history 000000020000000000000012 000000020000000000000022 000000020000000000000003 000000020000000000000013 000000020000000000000023 000000020000000000000004 000000020000000000000014 000000020000000000000024 000000020000000000000005 000000020000000000000015 000000020000000000000025 000000020000000000000006 000000020000000000000016 000000020000000000000026 000000020000000000000007 000000020000000000000017 000000020000000000000027 000000020000000000000008 000000020000000000000018 000000020000000000000028 000000020000000000000009 000000020000000000000019 000000020000000000000029 00000002000000000000000A 00000002000000000000001A 00000002000000000000002A 00000002000000000000000B 00000002000000000000001B 00000003.history 00000002000000000000000C 00000002000000000000001C 00000003000000000000002A