Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJVB8-00073n-Qt for pgsql-admin@postgresql.org; Wed, 03 Oct 2012 20:04:22 +0000 Received: from smtp.01.com ([199.36.142.181]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TJVB7-0002yj-NL for pgsql-admin@postgresql.org; Wed, 03 Oct 2012 20:04:22 +0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id E46512AD33D for ; Wed, 3 Oct 2012 15:04:18 -0500 (CDT) X-Virus-Scanned: amavisd-new at smtp-out-1.01.com Received: from smtp.01.com ([127.0.0.1]) by localhost (smtp-out-1.01.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id EvDrOrSxOGHU for ; Wed, 3 Oct 2012 15:04:18 -0500 (CDT) Received: from smtp.01.com (localhost.localdomain [127.0.0.1]) by smtp-out-1.01.com (Postfix) with ESMTP id BBC2E2AD112 for ; Wed, 3 Oct 2012 15:04:18 -0500 (CDT) Received: from [192.168.1.100] (74-93-229-125-Colorado.hfc.comcastbusiness.net [74.93.229.125]) by smtp-out-1.01.com (Postfix) with ESMTPSA id 9B4DF2AD33C for ; Wed, 3 Oct 2012 15:04:18 -0500 (CDT) Message-ID: <506C99A6.2030708@consistentstate.com> Date: Wed, 03 Oct 2012 14:01:42 -0600 From: Brian Fehrle User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.3) Gecko/20120314 Thunderbird/10.0.3 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Should data directories match between master and hot standby? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201210/14 X-Sequence-Number: 40130 Hi all, I have a hot standby (via streaming replication) set up on a postgresql 9.0.4 system. (I'm looking at base to eliminate differences in xlog and pg_log, etc) The size of my base directory on the master is 775G, the size of the base directory on the hot standby is 804G. Is this normal? Collecting the info from the master and the slave using the following shows I'm in sync: [on the master] select pg_current_xlog_location() -> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688) [on the slave] select pg_last_xlog_receive_location() -> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7282688) [on the slave] select pg_last_xlog_replay_location() -> pg_xlogfile_name_offset -> (0000000100007AB0000000E7,7281296) So I'm in sync, not like the slave is waiting on a huge delete or anything. Any thoughts or ideas what this could be? Thanks in advance, - Brian F