Search Postgresql Archives

Re: what is the solution like oracle DB's datafile

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

 



hello,

thanks for other solutions in the operating system section. LVM, RAID is indeed one solution to this problem.

Maybe there is another solution in the postgresql database like the datafile in oracle DB?

thank you,
Yours faithfully


yudianto

On Sun, Jan 30, 2022 at 8:44 PM Julien Rouhaud <rjuju123@xxxxxxxxx> wrote:
I already asked you once to keep the list in copy.  Don't expect me to reply if
your next email is still addressed to me only.

On Sun, Jan 30, 2022 at 08:36:50PM +0700, Yudianto Prasetyo wrote:
>
> yes of course it can be done. but it is very inconvenient when the database
> is still running and most importantly it is not practical when having to
> move some objects to another tablespace. And this will also happen again
> when HDD 1 will be full again with data entry by other objects on HDD 1.

Then fix the problem at the operating system level.  On GNU/Linux you can use
for instance LVM to get more flexibility.  With it you can easily increase your
logical volume space without any interruption, and the database will only see a
regular disk that magically became bigger.  There is probably something similar
on the operating system you're using.  Of course, if you don't already use
something like that, you will need some maintenance window to move all data on
logical volumes.

[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 Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux