what is the solution like oracle DB's datafile

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 HDD 2 (without RAID system)? is there any other

Regarding PGperffarm_server Setup

Hello, I am trying to setup this repository https://github.com/PGPerfFarm/pgperffarm_server in my local system. I tried to do that but, while running the migration, the models which are defined in the rest_api are not migrating, so the table is not created in the database. Please help me with the s

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

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

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

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

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

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

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

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

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