| 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: | Whole Thread | Raw Message | 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 |