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
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
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
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
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
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
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
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
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
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
10 matches
Mail list logo