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

Le mar. 27 déc. 2022 à 11:37, Eagna a écrit : > > > wrote: > > > - Oracle was developed earlier, and one can argue that in those days > file systems > > were not so great, so there was more need to write your own > > > Correct me if I'm wrong, but didn't Postgres (or Ingres upon which it's > bas

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

wrote: > - Oracle was developed earlier, and one can argue that in those days file > systems > were not so great, so there was more need to write your own Correct me if I'm wrong, but didn't Postgres (or Ingres upon which it's based) development start in the early-to-mid 70's and Oracle's

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

hello, thanks for the logical answer. it is true that there is a very big difference between open source and commercial DB. but I'm grateful to be able to use postgresql which is quite reliable. thank you Yours faithfully yudianto

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

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

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

On Sun, 2022-01-30 at 05:15 +0700, Yudianto Prasetyo wrote: > I want to ask why postgresql doesn't create a datafile like it has oracle? > > I'm confused when I have 2 HDD. HDD 1 is used to install the OS and > postgresql database. > when HDD 1 is full. how to increase the capacity of postgresql

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

ne 30. 1. 2022 v 18:13 odesílatel Yudianto Prasetyo 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/l

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

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\lmtbs

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

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

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

On 1/29/22 17:15, Yudianto Prasetyo wrote: Hello, I want to ask why postgresql doesn't create a datafile like it has oracle? I'm confused when I have 2 HDD. HDD 1 is used to install the OS and postgresql database. when HDD 1 is full. how to increase the capacity of postgresql database with HD

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

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'

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

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

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

Hi, Please keep the list in copy and don't top post here: https://wiki.postgresql.org/wiki/Mailing_Lists#Email_etiquette_mechanics On Sun, Jan 30, 2022 at 08:18:15PM +0700, Yudianto Prasetyo wrote: > > what is the function of adding a new tablespace if we will only fill data > in table color and

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

Hi, On Sun, Jan 30, 2022 at 05:15:33AM +0700, Yudianto Prasetyo wrote: > > I'm confused when I have 2 HDD. HDD 1 is used to install the OS and > postgresql database. when HDD 1 is full. how to increase the capacity of > postgresql database with HDD 2 (without RAID system)? > > is there any other