> > Group quotas should be sufficient. Create directory readable/writable to > > only the pgsql user, but have the group ownership be representative of > > the user in question. > > Rather ugly, and you'll run out of groups if you have alot of users (the > postgres user can only be in so many groups). It's a cute idea but I > really don't see it as being viable.
The postgres user doesn't need to be in any of the groups, the group simply exists simply to give the directory representation for a quota. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings