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
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 |