moving tablespaces

From: Grzegorz Dostatni <dostatnig(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: moving tablespaces
Date: 2008-04-07 21:15:02
Message-ID: 295750.79484.qm@web30402.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2008-04-07 21:48:22 Re: moving tablespaces
Previous Message Mario Ferloni 2008-04-07 20:53:08 Re: Windows max concurrent connections