Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 75F1617E0CFB for ; Sun, 18 Dec 2011 11:58:06 -0400 (AST) Received: from kerneljack.com ([89.16.173.229]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RcJ7k-0001EP-F1 for pgsql-admin@postgresql.org; Sun, 18 Dec 2011 15:58:05 +0000 Received: from host109-154-31-197.range109-154.btcentralplus.com ([109.154.31.197] helo=[192.168.1.110]) by kerneljack.com with esmtpsa (TLSv1:AES256-SHA:256) (Exim 4.63) (envelope-from ) id 1RcJ7V-0003oT-Lg for pgsql-admin@postgresql.org; Sun, 18 Dec 2011 15:57:49 +0000 Message-ID: <4EEE0D82.5070303@kerneljack.com> Date: Sun, 18 Dec 2011 15:57:54 +0000 From: Khusro Jaleel User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Issues with log-shipping replication References: <4EEA361B.2010306@kerneljack.com> <4EEA9705.6090806@gmail.com> In-Reply-To: <4EEA9705.6090806@gmail.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Pg-Spam-Score: -4.4 (----) X-Archive-Number: 201112/86 X-Sequence-Number: 38844 On 16/12/2011 00:55, Rural Hunter wrote: > well, is pgsql capable to parse shell variables in postgresql.conf? > anway you should check your master log. If it can not archive the wal, > there will be errors reported in it. Hi there, I have removed the various shell variables from the postgresql.conf file, cleaned out the data dir and started again. I can not see any errors in the postgresql log files in "data/pg_log". They simply report that Postgres was started up successfully, that's all. There are a few files created in "data/pg_xlog", some of which are copied over to the slave, but it seems some of them are not for some strange reason, perhaps an oddity with using "scp" for this procedure? You are referring to the "master" log file, is this the same log file I am referring to, or is that is some different location?