pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedMy 1st TABLESPACE
4+ messages / 3 participants
[nested] [flat]
* My 1st TABLESPACE
@ 2023-08-07 05:43 Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-07 05:48 ` Re: My 1st TABLESPACE negora <public@negora.com>
0 siblings, 1 reply; 4+ messages in thread
From: Amn Ojee Uw @ 2023-08-07 05:43 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
I'd like to create a TABLESPACE, so, following this web page
<https://www.postgresql.org/docs/current/sql-createtablespace.html>, I
have done the following :
*mkdir
/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
*sudo chown postgres:postgres
/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
*sudo -u postgres psql*
*\du**
** arbolone | Cannot login | {}**
** chispa | |
{prosafe}**
** workerbee | Superuser, Create DB | {arbolone}**
** jme | |
{arbolone}**
** postgres | Superuser, Create role, Create DB, Replication, Bypass
RLS | {}**
** prosafe | Cannot login | {}**
****
**CREATE TABLESPACE jmetablespace OWNER jme LOCATION
'/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data';*
The *CREATE **TABLESPACE* schema throws this error message :
/*ERROR: could not set permissions on directory
"/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data":
Permission denied*/
I have followed the web page to the best of my abilities, and AFAIK, the
postgres user owns the folder '*data*'.
I know that something is missing, where did I go wrong and how can I
resolve this issue?
Thanks in advance.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: My 1st TABLESPACE
2023-08-07 05:43 My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-07 05:48 ` negora <public@negora.com>
2023-08-07 12:16 ` Re: My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: negora @ 2023-08-07 05:48 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Hi:
Although the "postgres" user owns the "data" directory, Has he access to
the whole branch of directories? Maybe the problem is that he can't
reach the "data" directory.
Regards.
On 07/08/2023 07:43, Amn Ojee Uw wrote:
>
> I'd like to create a TABLESPACE, so, following this web page
> <https://www.postgresql.org/docs/current/sql-createtablespace.html>,
> I have done the following :
>
> *mkdir
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo chown postgres:postgres
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo -u postgres psql*
>
> *\du**
> ** arbolone | Cannot login | {}**
> ** chispa |
> | {prosafe}**
> ** workerbee | Superuser, Create DB | {arbolone}**
> ** jme | |
> {arbolone}**
> ** postgres | Superuser, Create role, Create DB, Replication,
> Bypass RLS | {}**
> ** prosafe | Cannot login | {}**
> ****
> **CREATE TABLESPACE jmetablespace OWNER jme LOCATION
> '/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data';*
>
> The *CREATE **TABLESPACE* schema throws this error message :
>
> /*ERROR: could not set permissions on directory
> "/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data":
> Permission denied*/
>
> I have followed the web page to the best of my abilities, and AFAIK,
> the postgres user owns the folder '*data*'.
>
> I know that something is missing, where did I go wrong and how can I
> resolve this issue?
>
>
> Thanks in advance.
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: My 1st TABLESPACE
2023-08-07 05:43 My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-07 05:48 ` Re: My 1st TABLESPACE negora <public@negora.com>
@ 2023-08-07 12:16 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-08 09:33 ` Re: My 1st TABLESPACE KK CHN <kkchn.in@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Amn Ojee Uw @ 2023-08-07 12:16 UTC (permalink / raw)
To: pgsql-general@lists.postgresql.org
Thanks Negora.
Makes sense, I will check it out.
On 8/7/23 1:48 a.m., negora wrote:
>
> Hi:
>
> Although the "postgres" user owns the "data" directory, Has he access
> to the whole branch of directories? Maybe the problem is that he can't
> reach the "data" directory.
>
> Regards.
>
>
> On 07/08/2023 07:43, Amn Ojee Uw wrote:
>>
>> I'd like to create a TABLESPACE, so, following this web page
>> <https://www.postgresql.org/docs/current/sql-createtablespace.html>,
>> I have done the following :
>>
>> *mkdir
>> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>>
>> *sudo chown postgres:postgres
>> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>>
>> *sudo -u postgres psql*
>>
>> *\du**
>> ** arbolone | Cannot login | {}**
>> ** chispa | | {prosafe}**
>> ** workerbee | Superuser, Create DB | {arbolone}**
>> ** jme | | {arbolone}**
>> ** postgres | Superuser, Create role, Create DB, Replication,
>> Bypass RLS | {}**
>> ** prosafe | Cannot login |
>> {}**
>> ****
>> **CREATE TABLESPACE jmetablespace OWNER jme LOCATION
>> '/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data';*
>>
>> The *CREATE **TABLESPACE* schema throws this error message :
>>
>> /*ERROR: could not set permissions on directory
>> "/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data":
>> Permission denied*/
>>
>> I have followed the web page to the best of my abilities, and AFAIK,
>> the postgres user owns the folder '*data*'.
>>
>> I know that something is missing, where did I go wrong and how can I
>> resolve this issue?
>>
>>
>> Thanks in advance.
>>
>>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: My 1st TABLESPACE
2023-08-07 05:43 My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-07 05:48 ` Re: My 1st TABLESPACE negora <public@negora.com>
2023-08-07 12:16 ` Re: My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
@ 2023-08-08 09:33 ` KK CHN <kkchn.in@gmail.com>
0 siblings, 0 replies; 4+ messages in thread
From: KK CHN @ 2023-08-08 09:33 UTC (permalink / raw)
To: Amn Ojee Uw <amnojeeuw@gmail.com>; +Cc: pgsql-general@lists.postgresql.org
On Mon, Aug 7, 2023 at 5:47 PM Amn Ojee Uw <amnojeeuw@gmail.com> wrote:
> Thanks Negora.
>
> Makes sense, I will check it out.
>
> On 8/7/23 1:48 a.m., negora wrote:
>
> Hi:
>
> Although the "postgres" user owns the "data" directory, Has he access to
> the whole branch of directories? Maybe the problem is that he can't reach
> the "data" directory.
>
> Regards.
>
>
> On 07/08/2023 07:43, Amn Ojee Uw wrote:
>
> I'd like to create a TABLESPACE, so, following this web page
> <https://www.postgresql.org/docs/current/sql-createtablespace.html;, I
> have done the following :
>
> *mkdir
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo chown postgres:postgres
> /home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data*
>
> *sudo -u postgres psql*
>
> *\du*
> * arbolone | Cannot login | {}*
> * chispa
> | | {prosafe}*
> * workerbee | Superuser, Create DB | {arbolone}*
> * jme
> | | {arbolone}*
> * postgres | Superuser, Create role, Create DB, Replication, Bypass RLS
> | {}*
> * prosafe | Cannot login | {}*
>
> *CREATE TABLESPACE jmetablespace OWNER jme LOCATION
> '/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data';*
>
>
Here owner is jme and the data dir you created must have owner jme..
> The *CREATE **TABLESPACE* schema throws this error message :
>
> *ERROR: could not set permissions on directory
> "/home/my_debian_account/Documents/NetbeansWorkSpace/JavaSE/Jme/database/postgresql/data":
> Permission denied*
>
> I have followed the web page to the best of my abilities, and AFAIK, the
> postgres user owns the folder '*data*'.
>
> I know that something is missing, where did I go wrong and how can I
> resolve this issue?
>
>
> Thanks in advance.
>
>
>
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-08-08 09:33 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-08-07 05:43 My 1st TABLESPACE Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-07 05:48 ` negora <public@negora.com>
2023-08-07 12:16 ` Amn Ojee Uw <amnojeeuw@gmail.com>
2023-08-08 09:33 ` KK CHN <kkchn.in@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox