Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 3945C2E003B for ; Mon, 7 Apr 2008 18:15:10 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 16326-01 for ; Mon, 7 Apr 2008 18:15:07 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from web30402.mail.mud.yahoo.com (web30402.mail.mud.yahoo.com [68.142.200.105]) by developer.postgresql.org (Postfix) with SMTP id 1CB9F2E0038 for ; Mon, 7 Apr 2008 18:15:07 -0300 (ADT) Received: (qmail 80013 invoked by uid 60001); 7 Apr 2008 21:15:02 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=jJ6m2+gUVAOhVss2p07YmC4/cnUvSliwv5uG6bqouvw5ELHK5fBOlF3VURpvkyNApB3n6Ruxs2SE5eR2eQ566oqp34E+zu5SexVfRLTrBOeqxIBZhne2pUwDsXZbIpZdj7CAT3jzxpuoV7hBZTz0Qw23W/MAQ4f3m7/1gLZ4FHc=; X-YMail-OSG: td5oBE8VM1kliE9FBtqO6c1Mizqj4n3rbGKqLWY9 Received: from [129.128.11.174] by web30402.mail.mud.yahoo.com via HTTP; Mon, 07 Apr 2008 14:15:02 PDT Date: Mon, 7 Apr 2008 14:15:02 -0700 (PDT) From: Grzegorz Dostatni Subject: moving tablespaces To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <295750.79484.qm@web30402.mail.mud.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200804/58 X-Sequence-Number: 28822 Hello. I'm running postgresql 8.3.1 on Solaris 10. I made a mistake when originally setting up the database directory (which includes tablespaces). I have moved it to a new location, and I have setup a symbolic link that allows the db to find the tablespaces. What I'm wondering about is how do I make the change pernament in the database (ie. without using symbolic links)? What's the safe way to do that? Is moving the symbolic links from pg_tblspc area sufficient? DB needs to be shutdown for that. Will that update the pg_tablespace table within the database automatically? Thanks, Greg ____________________________________________________________________________________ You rock. That's why Blockbuster's offering you one month of Blockbuster Total Access, No Cost. http://tc.deals.yahoo.com/tc/blockbuster/text5.com