X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9D34ED9B17 for ; Wed, 28 Sep 2005 18:19:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 06226-10 for ; Wed, 28 Sep 2005 21:19:11 +0000 (GMT) Received: from rwcrmhc12.comcast.net (rwcrmhc13.comcast.net [216.148.227.118]) by svr1.postgresql.org (Postfix) with ESMTP id E86B1D9B0B for ; Wed, 28 Sep 2005 18:19:12 -0300 (ADT) Received: from [192.168.1.52] (c-65-96-235-5.hsd1.ma.comcast.net[65.96.235.5]) by comcast.net (rwcrmhc13) with ESMTP id <2005092821191301500rsitge>; Wed, 28 Sep 2005 21:19:14 +0000 Message-ID: <433B08D0.50203@comcast.net> Date: Wed, 28 Sep 2005 17:19:12 -0400 From: Jeffrey Tenny User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.11) Gecko/20050729 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Anjan Dave Cc: Sergiusz Jarczyk , pgsql-admin@postgresql.org Subject: Re: Postgresql 8.0.3, symbolic link to /var/lib/pgsql/data/base References: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098CE4@vt-pe2550-001.vantage.vantage.com> In-Reply-To: <4BAFBB6B9CC46F41B2AD7D9F4BBAF785098CE4@vt-pe2550-001.vantage.vantage.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.635 required=5 tests=[AWL=-0.233, DNS_FROM_RFC_POST=1.376, DNS_FROM_RFC_WHOIS=0.492] X-Spam-Level: * X-Archive-Number: 200509/316 X-Sequence-Number: 19053 Anjan Dave wrote: > Why don't you copy/move the entire data directory (minus pg_xlog if you are separating them) I tried that too, and then postmaster wouldn't even start. I don't remember if it was a permission error or if it was complaining it couldn't find the configuration files. I suspect whatever symlink problems are manifesting in just moving 'base' also apply to moving 'data'.