Search Postgresql Archives

Re: Symlinking (specific) tables to different Drives

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On 9/4/07, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> wrote:
On Tue, 2007-09-04 at 07:09 +0300, Mikko Partio wrote:
>
>
> On 9/4/07, Ow Mun Heng <Ow.Mun.Heng@xxxxxxx> wrote:
>         Hi,
>
>         I'm running out of space on one of my partitions and I still
>         have not
>         gotten all the data loaded yet. I've read that one could
>         symlink the
>         pg_pg_xlog directory to another drive. I'm wondering if I can
>         do the
>         same for specific tables as well.
>
>
> Create another tablespace to the new location and the ALTER TABLE ...
> TABLESPACE newtablespace.
>

OOooohhh... I didn't know one could use tablespaces like that. (I mean,
I did read the docs, but it just didn't register that it _can_ do
something like that)

additional question.. do I need to change the search_path?

No (changing tablespaces does not change your logical schema).
 
Regards

MP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux