The PostgreSQL ebuilds and initscript are now capable of using either \/run<\/tt> or \/var\/run<\/tt> for the default socket directory.<\/p>\n
The ebuilds will determine which to use at build time. The logic simply being, “Does \/run exist?” If it does, everything is adjusted accordingly. If not, everything is adjusted accordingly. The old initscript is incapable of using \/run<\/tt> or any other socket directory. So, if you upgrade to the latest version of the ebuilds and fail to upgrade the initscript, you’re going to have issues if you have a \/run<\/tt> directory.<\/p>\n
Also, this may cause a hiccup when an application is expecting the default location to be in \/var\/run\/postgresql<\/tt> rather than \/run\/postgresql<\/tt>. The proper solution is not to rebuild everything — you can if you want, but that’s time consuming — but to specify the directory to look in for the socket. Anywhere you’d specify the host you can actually specify the socket directory. Or, you should be able to if the application did it right.<\/p>\n
Something that is more important for those who have \/run<\/tt> or \/var\/run<\/tt> on tmpfs, the initscript now takes care of creating the directory if it’s missing. With proper permissions of course.<\/p>\n
The next neat thing is that the initscript respects two settings it previously ignored. Well, it ignored one setting outright, and allowed you to set another in \/etc\/conf.d\/postgresql-${SLOT}<\/tt> only. If you set port<\/tt> or socket_directory<\/tt> in the postgresql.conf<\/tt>, the initscript will now pick it up and use those settings over what’s set in \/etc\/conf.d\/postgresql-${SLOT}<\/tt>.<\/p>\n
The growing pains aren’t over just yet. Out of three machines, one machine didn’t like the new initscript. It couldn’t shutdown an existing, running server. The other two did it just fine. Same setups. Nothing fancy. Just inexplicable. It’s easy enough to shutdown the server manually, and cleanly. Issue the following substituting the path for wherever your server’s data directory actually resides.<\/p>\n
# kill -SIGTERM $(head -n1 \/var\/lib\/postgresql\/9.1\/data\/postmaster.pid)<\/pre>\nIf that doesn’t do the trick, you can substitute -SIGTERM<\/tt> with -SIGINT<\/tt> as that will close client connections and rollback the transactions those clients may have been in, as that is the most common cause as to why -SIGTERM<\/tt> wouldn’t work.<\/p>\n
Merry Christmas!<\/p>\n","protected":false},"excerpt":{"rendered":"
The PostgreSQL ebuilds and initscript are now capable of using either \/run or \/var\/run for the default socket directory. The ebuilds will determine which to use at build time. The logic simply being, “Does \/run exist?” If it does, everything is adjusted accordingly. If not, everything is adjusted accordingly. The old initscript is incapable of … Continue reading \/run? \/var\/run? Other? Or Why You Need to Update to the Latest PostgreSQL Initscript<\/span><\/a><\/p>\n","protected":false},"author":136,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"spay_email":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true},"categories":[3,5],"tags":[],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p1tO5a-2h","_links":{"self":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/141"}],"collection":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/users\/136"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/comments?post=141"}],"version-history":[{"count":3,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/141\/revisions"}],"predecessor-version":[{"id":143,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/posts\/141\/revisions\/143"}],"wp:attachment":[{"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/media?parent=141"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/categories?post=141"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.gentoo.org\/titanofold\/wp-json\/wp\/v2\/tags?post=141"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}