From: | Francisco Olarte <folarte(at)peoplecall(dot)com> |
---|---|
To: | Sébastien Bihorel <pomchip(at)free(dot)fr> |
Cc: | Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: |
Date: | 2019-11-21 16:08:12 |
Message-ID: | CA+bJJbz4fvF_+cBm1fVZZvZMn+N_OBepfcRW=FTrr8dqtC_snw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Sébastien:
On Thu, Nov 21, 2019 at 3:42 PM Sébastien Bihorel <pomchip(at)free(dot)fr> wrote:
.....
> /home/sebastien/data $ ls -l
> drwxr-xr-x 2 sebastien postgres 4096 Nov 19 09:14 pgdata96_sebastien
> Starting psql as sebastien, I tried the following requests and got the following errors:
...
> The manual states "The location must be an existing, empty directory that is owned by the PostgreSQL operating system user." So, I am not sure what I am doing wrong. Web searches ran on these error messages did not enlighten me more...
Your directory is owned by OS USER sebastien GROUP postgres, try
"chown -v postgres /home/sebastien/data " to fix it.
The server ( postgres ) does not have permissions ( rwx >>r-x<< r-x,
only read and chdir ) to create anything in there.
The fact you start psql as sebastien does not matter, it must be owned
by the SERVER user ( as psql is separated, it communicates by a
socket, can be in another machine ).
Francisco Olarte.
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-11-21 16:10:51 | Re: Remote Connection Help |
Previous Message | Marc Millas | 2019-11-21 16:07:59 | Re: Extract transactions from wals ?? |