Re: Creating a TABLESPACE

2023-08-16 Thread Ray O'Donnell
On 16/08/2023 21:24, Ron wrote: Speakers of English as a second language are to be tolerated and assisted, not mocked and insulted. +1 I actually found it rather amusing. :-) Ray. On 8/16/23 12:27, Amn Ojee Uw wrote: Sorry, did not mean it that way. Thanks for the advice. On 8/16/23 11

Re: Creating a TABLESPACE

2023-08-16 Thread Ron
Speakers of English as a second language are to be tolerated and assisted, not mocked and insulted. On 8/16/23 12:27, Amn Ojee Uw wrote: Sorry, did not mean it that way. Thanks for the advice. On 8/16/23 11:37 a.m., Ron wrote: Friendly tip: whatever else you do, don't write "Hello children!"

Re: Creating a TABLESPACE

2023-08-16 Thread Amn Ojee Uw
Sorry, did not mean it that way. Thanks for the advice. On 8/16/23 11:37 a.m., Ron wrote: Friendly tip: whatever else you do, don't write "Hello children!" in English to adults.  It's *highly insulting*. On 8/16/23 05:10, Amn Ojee Uw wrote: Hello children! -- Born in Arizona, moved to Bab

Re: Creating a TABLESPACE

2023-08-16 Thread Amn Ojee Uw
Yes! Thank you Mateusz. On 8/16/23 6:43 a.m., Mateusz Henicz wrote: Hey, You are using "WITH tablespace_option" wrong. Try it like this: postgres=# CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION '/database' WITH (seq_page_cost=1.0,random_page_cost=4.0,effective_io_concurrency=1); CR

Re: Creating a TABLESPACE

2023-08-16 Thread Ron
Friendly tip: whatever else you do, don't write "Hello children!" in English to adults.  It's *highly insulting*. On 8/16/23 05:10, Amn Ojee Uw wrote: Hello children! -- Born in Arizona, moved to Babylonia.

Re: Creating a TABLESPACE

2023-08-16 Thread Mateusz Henicz
Hey, You are using "WITH tablespace_option" wrong. Try it like this: postgres=# CREATE TABLESPACE jme_tablespace OWNER jamiil LOCATION '/database' WITH (seq_page_cost=1.0,random_page_cost=4.0,effective_io_concurrency=1); CREATE TABLESPACE Cheers, Mateusz śr., 16 sie 2023 o 12:10 Amn Ojee Uw na

Creating a TABLESPACE

2023-08-16 Thread Amn Ojee Uw
Hello children! I am learning how to create a tablespace, and AFAIK this are the steps to follow. First step is to create the directory where the database files will be created, for that I am using the root directory '/database'. This directory is be owned by the postgres group. Example :