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 6B1F5D928F for ; Wed, 28 Sep 2005 22:42:31 -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 18215-03 for ; Thu, 29 Sep 2005 01:42:27 +0000 (GMT) Received: from mail.travelamericas.com (unknown [206.130.134.147]) by svr1.postgresql.org (Postfix) with SMTP id 2147BD921C for ; Wed, 28 Sep 2005 22:42:27 -0300 (ADT) Received: (qmail 10127 invoked from network); 29 Sep 2005 01:42:31 -0000 Received: from unknown (HELO ?10.0.0.253?) (10.0.0.253) by verkiel.travelamericas.com with SMTP; 29 Sep 2005 01:42:31 -0000 Message-ID: <433B467E.8010204@travelamericas.com> Date: Wed, 28 Sep 2005 18:42:22 -0700 From: Chris Travers User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jeffrey Tenny , 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> <433B08D0.50203@comcast.net> In-Reply-To: <433B08D0.50203@comcast.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 required=5 tests=[AWL=-0.000, FORGED_RCVD_HELO=0.05] X-Spam-Level: X-Archive-Number: 200509/324 X-Sequence-Number: 19061 Jeffrey Tenny wrote: > 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'. Check the file ownerships. Maybe a chown -R postgres /home/postgres might be in order... Also, if you are using SE-Linux, this can make things interesting... Best Wishes, Chris Travers Metatron Technology Consulting > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >