Filipe Brandenburger wrote:
Did you just add yourself to that group? The processes you run will not know you are a member of that group until you logout and login again (open new SSH session, etc.).
When you issue the "id" command (with no parameters), does it include the "postgres" group?
ah, yes, I had just added that in another root shell. you're right, I logged out and back and and yes, it -does- work...
[pierce@xxxx test]$ id uid=503(pierce) gid=503(pierce) groups=26(postgres),503(pierce) [pierce@xxxx test]$ ls -la total 8 drwxrwxr-x 2 pierce pierce 4096 May 13 07:58 . drwxr-xr-x 37 pierce root 4096 May 13 07:57 .. -rw-rw-r-- 1 pierce pierce 0 May 13 07:58 x [pierce@xxxx test]$ chgrp postgres x [pierce@xxxx test]$ ls -la total 8 drwxrwxr-x 2 pierce pierce 4096 May 13 07:58 . drwxr-xr-x 37 pierce root 4096 May 13 07:57 .. -rw-rw-r-- 1 pierce postgres 0 May 13 07:58 x