August 2018

newsyslog: chmod(/var/log/auth.log.6.bz2) in change_attrs: No such file or directory

This problem was difficult to figure out. The cause was simple, but not obvious. Messages such as this were appearing in emails From July: In August: I had no idea why. My initial suspicion was the /etc/newsyslog.conf configuration for that file: [dan@knew:~] $ grep auth /etc/newsyslog.conf /var/log/auth.log root:logcheck 640 7 * @T00 JC [dan@knew:~] $ That count is 7, so why is it complaining about 6? The files look ok: [dan@knew:~] $ ls […]

newsyslog: chmod(/var/log/auth.log.6.bz2) in change_attrs: No such file or directory Read More »

PostgreSQL – convert a user to a role

Users and Roles in PostgreSQL are very similar. When I set up the FreshPorts database back in mid-2000, I was using PostgreSQL 7.0.3 (that’s my best guess based on my blog entry). I suspect roles were not available then and were introduced with PostgreSQL 8. I am positive someone will correct me if that’s wrong. I now have a need to convert a user into a role, then add users to that role.

PostgreSQL – convert a user to a role Read More »

Scroll to Top