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
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.
