Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1bakyU-0000E1-KS for pgsql-admin@arkaria.postgresql.org; Fri, 19 Aug 2016 14:40:46 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1bakyT-0006gc-VX for pgsql-admin@arkaria.postgresql.org; Fri, 19 Aug 2016 14:40:46 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1bakwl-0004kX-VW for pgsql-admin@postgresql.org; Fri, 19 Aug 2016 14:39:00 +0000 Received: from tblr50.logix.in ([121.240.11.50]) by makus.postgresql.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1bakwg-0005PO-Ab for pgsql-admin@postgresql.org; Fri, 19 Aug 2016 14:38:57 +0000 Received: from vdvm23-out.logix.local (127.0.0.1) by tblr50.logix.in (PowerMTA(TM) v3.5r11) id hmscvs1oo38u for ; Fri, 19 Aug 2016 20:08:43 +0530 (envelope-from ) Received: (qmail 25875 invoked by uid 512); 19 Aug 2016 14:38:42 -0000 X-Qmail-Scanner-Diagnostics: from 192.168.8.11 by vdvm23.logix.local (envelope-from , uid 504) with qmail-scanner-2.11 ( Clear:RC:1(192.168.8.11):SA:0(IronPort):. Processed in 0.065525 secs); 19 Aug 2016 14:38:42 -0000 Received: from unknown (HELO neo.logix.local) ([192.168.8.11]) (envelope-sender ) by vdvm23-out.logix.local (qmail-ldap-1.03) with SMTP for ; 19 Aug 2016 14:38:42 -0000 X-ORIGINAL-IP: 192.168.8.144 X-ORIGINAL-TIME: 19 Aug 2016 20:08:41 +0530 IronPort-PHdr: =?us-ascii?q?9a23=3AKQzxHRQk4/ln+yJxmre8mKwbTtpsv+yvbD5Q0YIu?= =?us-ascii?q?jvd0So/mwa64YhWN2/xhgRfzUJnB7Loc0qyN4/CmAzBLusvJmUtBWaIPfidNsd?= =?us-ascii?q?8RkQ0kDZzNImzAB9muURYHGt9fXkRu5XCxPBsdMs//Y1rPvi/6tmZKSV3BPAZ4?= =?us-ascii?q?bt74BpTVx5zukbviq9uJP04T2XKUWvBbElaflU3prM4YgI9veO4a6yDihT92Qd?= =?us-ascii?q?lQ3n5iPlmJnhzxtY+a9Z9n9DlM6bp6r5YTGfayQ6NtVbNDFTBjOmww5cvDrR7Y?= =?us-ascii?q?UQSV62AFViMRiBUbLRLC6UTRXp73vjHzletn0S/SGczwQrkuVDiu/u8/Qxvpji?= =?us-ascii?q?gOLTM1/HD/lNd3gr5Qpwi54Rd4xtiHM8muKPNic/aFLpshTm1bU5MJWg=3D=3D?= X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: =?us-ascii?q?A2HoFAD8GPlW/5AIqMBbgmKBH30GunmBL?= =?us-ascii?q?hwmFwEJhFwBgQ+BWxIBAQEBAQEBAQKBCEEBAQMJBIFaCQEhCwwGBgQrAQEBAQE?= =?us-ascii?q?BAQEBAQEfAggQHwoPIiNPBxIBGhcZAksQD4g9r2SQGyqBD4UPgXuGbUWCGwstE?= =?us-ascii?q?4JDBYdWhlk/iHOBK4RGiXtNg3+IWY8JAicJgjUZgVFkAYEKgx+DLn4BAQE?= X-IPAS-Result: =?us-ascii?q?A2HoFAD8GPlW/5AIqMBbgmKBH30GunmBLhwmFwEJhFwBgQ+?= =?us-ascii?q?BWxIBAQEBAQEBAQKBCEEBAQMJBIFaCQEhCwwGBgQrAQEBAQEBAQEBAQEfAggQH?= =?us-ascii?q?woPIiNPBxIBGhcZAksQD4g9r2SQGyqBD4UPgXuGbUWCGwstE4JDBYdWhlk/iHO?= =?us-ascii?q?BK4RGiXtNg3+IWY8JAicJgjUZgVFkAYEKgx+DLn4BAQE?= Received: from cldzimmta3.logix.local ([192.168.8.144]) by neo.logix.local with ESMTP; 19 Aug 2016 20:08:41 +0530 Received: from localhost (localhost [127.0.0.1]) by cldzimmta3.logix.local (Postfix) with ESMTP id 6F9E1C688287; Fri, 19 Aug 2016 20:08:41 +0530 (IST) Received: from cldzimmta3.logix.local ([127.0.0.1]) by localhost (cldzimmta3.logix.local [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id Vts4Hd3awAXx; Fri, 19 Aug 2016 20:08:41 +0530 (IST) Received: from cldzimmta1.logix.local (cldzimmta1.logix.local [192.168.8.142]) by cldzimmta3.logix.local (Postfix) with ESMTPS id 3FE12C6864A5; Fri, 19 Aug 2016 20:08:41 +0530 (IST) Received: from localhost (localhost [127.0.0.1]) by cldzimmta1.logix.local (Postfix) with ESMTP id 3B0B085419EB; Fri, 19 Aug 2016 20:08:41 +0530 (IST) X-Virus-Scanned: amavisd-new at Received: from cldzimmta1.logix.local ([127.0.0.1]) by localhost (cldzimmta1.logix.local [127.0.0.1]) (amavisd-new, port 10026) with ESMTP id 40DQo08LZYH7; Fri, 19 Aug 2016 20:08:41 +0530 (IST) Received: from cldzimmbx1.logix.local (cldzimmbx1.logix.local [192.168.8.146]) by cldzimmta1.logix.local (Postfix) with ESMTP id 1DCBF85419EC; Fri, 19 Aug 2016 20:08:41 +0530 (IST) Date: Fri, 19 Aug 2016 20:08:41 +0530 (IST) From: ChandraKiran Lingareddy To: pgsql-admin@postgresql.org Cc: ChandraKiran Lingareddy Message-ID: <1190313260.4338281.1471617521076.JavaMail.zimbra@vsoftcorp.com> Subject: While setting up new DR for 9.2 server I am facing some errors MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4338280_880289059.1471617521074" X-Originating-IP: [192.168.8.142] X-Mailer: Zimbra 8.6.0_GA_1191 (ZimbraWebClient - GC52 (Win)/8.6.0_GA_1191) Thread-Topic: While setting up new DR for 9.2 server I am facing some errors Thread-Index: 8iRAN0eWFKQJe5ycgYC5PMBoQN+BZw== X-Pg-Spam-Score: -0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_4338280_880289059.1471617521074 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Hi, While setting up new DR for 9.2 server i an getting below error. Please assist. 2016-08-19 19:19:15 IST LOG: database system was interrupted while in recovery at log time 2016-08-18 19:31:57 IST 2016-08-19 19:19:15 IST HINT: If this has occurred more than once some data might be corrupted and you might need to choose an earlier recovery target. 2016-08-19 19:19:15 IST LOG: entering standby mode 2016-08-19 19:19:15 IST LOG: consistent recovery state reached at 362/5175FFF8 2016-08-19 19:19:15 IST LOG: redo starts at 362/51000020 2016-08-19 19:19:16 IST LOG: ** EnterpriseDB Dynamic Tuning Agent ******************************************** * System Utilization: 66 % * * Database Version: 9.2.1.3 * * Operating System Version: * * Number of Processors: 0 * * Processor Type: * * Processor Architecture: * * Database Size: 77.6 GB * * RAM: 11.8 GB * * Shared Memory: 12042 MB * * Max DB Connections: 104 * * Autovacuum: on * * Autovacuum Naptime: 60 Seconds * * InfiniteCache: off * * InfiniteCache Servers: 0 * * InfiniteCache Size: 0.000 GB * ********************************************************************************* 2016-08-19 19:19:16 IST WARNING: page 0 of relation base/16654/78525236 is uninitialized 2016-08-19 19:19:16 IST CONTEXT: xlog redo visible: rel 1663/16654/78525236; blk 0 2016-08-19 19:19:16 IST PANIC: WAL contains references to invalid pages 2016-08-19 19:19:16 IST CONTEXT: xlog redo visible: rel 1663/16654/78525236; blk 0 2016-08-19 19:19:16 IST FATAL: the database system is starting up 2016-08-19 19:19:17 IST FATAL: the database system is starting up 2016-08-19 19:19:18 IST FATAL: the database system is starting up 2016-08-19 19:19:19 IST FATAL: the database system is starting up 2016-08-19 19:19:20 IST FATAL: the database system is starting up 2016-08-19 19:19:21 IST LOG: startup process (PID 7603) was terminated by signal 6: Aborted 2016-08-19 19:19:21 IST LOG: terminating any other active server processes Thanks, Chandra Kiran L DBA Direct: 04 0 6640 6814 | VSoft.co.in ------=_Part_4338280_880289059.1471617521074 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable
Hi,

While setting up new DR for 9.2 server i an getting below error. Ple= ase assist.

2016-08-19 19:19:= 15 IST LOG: database system was interrupted while in recovery at log time 2= 016-08-18 19:31:57 IST
2016-08-19 19:19:15 IST HINT: If this has occurre= d more than once some data might be corrupted and you might need to choose = an earlier recovery target.
2016-08-19 19:19:15 IST LOG: entering standb= y mode
2016-08-19 19:19:15 IST LOG: consistent recovery state reached at= 362/5175FFF8
2016-08-19 19:19:15 IST LOG: redo starts at 362/510000202016-08-19 19:19:16 IST LOG:

** EnterpriseDB Dynamic Tuning Age= nt ********************************************
* System Utilization: 6= 6 % *
* Database Version: 9.2.1.3 *
* Operating System Version: * * Number of Processors: 0 *
* Processor Type: *
* Processor Arch= itecture: *
* Database Size: 77.6 GB *
* RAM: 11.8 GB *
* Share= d Memory: 12042 MB *
* Max DB Connections: 104 *
* Autovacuum: on *=
* Autovacuum Naptime: 60 Seconds *
* InfiniteCache: off *
* In= finiteCache Servers: 0 *
* InfiniteCache Size: 0.000 GB *
*********= ************************************************************************
2016-08-19 19:19:16 IST WARNING: page 0 of relation base/16654/785252= 36 is uninitialized
2016-08-19 19:19:16 IST CONTEXT: xlog redo visible: = rel 1663/16654/78525236; blk 0
2016-08-19 19:19:16 IST PANIC: WAL contai= ns references to invalid pages
2016-08-19 19:19:16 IST CONTEXT: xlog red= o visible: rel 1663/16654/78525236; blk 0
2016-08-19 19:19:16 IST FATAL:= the database system is starting up
2016-08-19 19:19:17 IST FATAL: the d= atabase system is starting up
2016-08-19 19:19:18 IST FATAL: the databas= e system is starting up
2016-08-19 19:19:19 IST FATAL: the database syst= em is starting up
2016-08-19 19:19:20 IST FATAL: the database system is = starting up
2016-08-19 19:19:21 IST LOG: startup process (PID 7603) was = terminated by signal 6: Aborted
2016-08-19 19:19:21 IST LOG: terminating= any other active server processes


Thanks,
Chandra Kiran L
DBA 
=
 Direct:  040 6640 6814 | VSoft.co.in=
 
3D"VSoftCorp"
3D"Facebook"
3D"Twitter"
3D"LinkedIn"
3D""
3D""
------=_Part_4338280_880289059.1471617521074--