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

2022-01-30 Thread Laurenz Albe
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

2022-01-30 Thread Josef Šimánek
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

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

2022-01-30 Thread Yudianto Prasetyo
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

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

2022-01-30 Thread Yudianto Prasetyo
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

2022-01-30 Thread Mladen Gogala
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

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

2022-01-30 Thread Julien Rouhaud
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

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

2022-01-30 Thread Julien Rouhaud
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

2022-01-30 Thread Julien Rouhaud
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

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

2022-01-30 Thread Julien Rouhaud
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

Regarding PGperffarm_server Setup

2022-01-30 Thread Sourav Prasad Das
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