I just want to pg_dumpall my postgresql db in /home/ftpuser/backups/ folder i just created.
So I created a group (backuppers) with ftpuser and postgres as members. then i chgrp backuppers to /home/ftpuser/backups/, also chown postgres:backuppers just to be sure. In fact ls -l output tells me that /home/ftpuser/backups/ belongs to postgres.
The problem is that ftpuser can read and write to that folder, but postgres user can't. Even ls outputs access denied. Postgres simply cant read or write to that folder, even if it's owned by postgres himself. Any hint?
I also tried to create a folder like /backups owned by postgres and by the backuppers group, in fact postgres and ftpuser can read and write from that folder. Then the problem is that when i log in from ftp (lftp -u ftpuser ipaddress), ftpuser is unable to write, read and even cd /backups.