Sébastien:
On Thu, Nov 21, 2019 at 3:42 PM Sébastien Bihorel <pomchip@free.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.
