"sandhya" <sandhyar(at)amiindia(dot)co(dot)in> writes:
> ERROR: could not create server file "/tmp/sss.txt": Permission denied
If /tmp is already mode 777, then the only reason I can think of for
this is that you've got SELinux turned on and it's configured to forbid
the postmaster from writing in /tmp. Possibly updating your selinux-policy
package would help.
regards, tom lane