hello, thanks for all the solutions. I don't think there is a solution like Oracle DB's datafile in postgresql. LVM is probably the best way if using Linux OS.
Thank You Yours faithfully yudianto <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> Virus-free. www.avg.com <http://www.avg.com/email-signature?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail> <#DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2> On Mon, Jan 31, 2022 at 12:19 AM Josef Šimánek <josef.sima...@gmail.com> wrote: > ne 30. 1. 2022 v 18:13 odesílatel Yudianto Prasetyo > <mr.yudia...@gmail.com> napsal: > > > > Hello, > > > > dafafile this oracle like this example. can be added to another hdd. > > > > ALTER TABLESPACE lmtbsb > > ADD DATAFILE '/u02/oracle/data/lmtbsb02.dbf' SIZE 1M; > > > > ALTER TABLESPACE lmtbsb > > ADD DATAFILE '/u03/oracle/data/lmtbsb02.dbf' SIZE 1M; > > > > ALTER TABLESPACE lmtbsb > > ADD DATAFILE 'e:\data\lmtbsb02.dbf' SIZE 1M; > > > > ALTER TABLESPACE lmtbsb > > ADD DATAFILE 'f:\data2\lmtbsb02.dbf' SIZE 1M; > > > > i understand about that LVM solution. it is true that using this method > can be done. I'm just asking for a solution at the database level. > > Per my understanding, there is no exactly the same feature in > PostgreSQL itself. As mentioned before, it is most likely by design. > > > thank you > > Yours faithfully > > > > yudianto > > > > On Sun, Jan 30, 2022 at 9:17 PM Julien Rouhaud <rjuju...@gmail.com> > wrote: > >> > >> On Sun, Jan 30, 2022 at 08:51:02PM +0700, Yudianto Prasetyo wrote: > >> > > >> > 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? > >> > >> As I said I don't know how datafiles in oracle are working. All you > have on > >> postgres is tablespaces, default tablespaces and moving relations from > one > >> tablespaces to another. > >> > >> In general, postgres doesn't try to reimplement solution to problems > that are > >> nicely solved at the operating system level, so if those datafile are > >> reimplementing something similar to LVM, then no postgres doesn't have > >> something like that and probably doesn't want it. >
