![]() ![]() These VirtualBox shared folders always appear inside the guest with root:vboxsf permissions, those permissions won't change with chmod or chown and that makes it impossible for me to create a new folder on this shared folder with postgres:postgres permissions. The problem starts when I use VirtualBox with a shared folder location between the host and the guest, let's say my shared folder location is in /home/SharedFolder and I have PostgreSQL installed in my virtual machine. This solution works perfectly fine, the only condition is that the copied folder needs to have postgres:postgres permissions recursively. Something like: sudo rsync -av /var/lib/postgresql /mnt/volumeĪnd then inside the file /etc/postgresql/9.5/main/nf I change the line data_directory = '/mnt/volume/postgresql/12/main'. Basically, I just need to copy the files inside /var/lib/postgresql to a different location. I'm following this tutorial that explains how to move a PostgreSQL data folder location. ![]()
0 Comments
Leave a Reply. |