On Tue, Jul 16, 2013 at 5:42 AM, prakhar jauhari <prak840@xxxxxxxxx> wrote: > Hi all, > I am currently using postgresql 9.2 installation. > While taking base backups using pg_basebackup utility, I noticed that > permissions of the directory which i specify for base backup are set to 777. > Does postgesql need such lenient permissions to work, coz 777 on Db > directory seems a security concern to me. PostgreSQL does not care about the permissions on the backup directory used, and does not set them to 777. In fact, it sets them to to be accessible only by the owner, so clearly something else is setting those permissions for you. It will copy any permissions *inside* the data directory for you, so if you see 777 there, it means that you have those permissions somewhere in your production data directory as well. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
