Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql Admin > moving tablespa...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 4888 of 5156
Post > Topic >>

moving tablespaces

by dostatnig@[EMAIL PROTECTED] (Grzegorz Dostatni) Apr 7, 2008 at 02:15 PM

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

-- 
Sent via pgsql-admin mailing list (pgsql-admin@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
 




 2 Posts in Topic:
moving tablespaces
dostatnig@[EMAIL PROTECTE  2008-04-07 14:15:02 
Re: moving tablespaces
jd@[EMAIL PROTECTED] (&q  2008-04-07 14:48:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan13V112 Thu Jul 24 1:20:04 CDT 2008.