pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmoving tablespaces
2+ messages / 2 participants
[nested] [flat]
* moving tablespaces
@ 2008-04-07 21:15 Grzegorz Dostatni <dostatnig@yahoo.com>
0 siblings, 1 reply; 2+ messages in thread
From: Grzegorz Dostatni @ 2008-04-07 21:15 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: moving tablespaces
@ 2008-04-07 21:48 Joshua D. Drake <jd@commandprompt.com>
parent: Grzegorz Dostatni <dostatnig@yahoo.com>
0 siblings, 0 replies; 2+ messages in thread
From: Joshua D. Drake @ 2008-04-07 21:48 UTC (permalink / raw)
To: Grzegorz Dostatni <dostatnig@yahoo.com>; +Cc: pgsql-admin
On Mon, 7 Apr 2008 14:15:02 -0700 (PDT)
Grzegorz Dostatni <dostatnig@yahoo.com> wrote:
> 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?
Create a new tablespace and move the objects to it (alter table <foo>
tablespace ....). However this will be an exclusive lock for each object
as the task is performed.
Sincerely,
Joshua D. Drake
>
> 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
>
--
The PostgreSQL Company since 1997: http://www.commandprompt.com/
PostgreSQL Community Conference: http://www.postgresqlconference.org/
United States PostgreSQL Association: http://www.postgresql.us/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-04-07 21:48 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-07 21:15 moving tablespaces Grzegorz Dostatni <dostatnig@yahoo.com>
2008-04-07 21:48 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox