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