{"id":5,"date":"2012-01-18T09:36:41","date_gmt":"2012-01-18T09:36:41","guid":{"rendered":"http:\/\/www.andreagirardi.it\/blog\/?p=5"},"modified":"2012-01-20T10:01:51","modified_gmt":"2012-01-20T10:01:51","slug":"tes","status":"publish","type":"post","link":"https:\/\/www.andreagirardi.it\/blog\/tes\/","title":{"rendered":"Run Postgres 9.1 on MacOS Lion as Daemon"},"content":{"rendered":"

To start a new Postgres version as Daemon you need to follow these commands. For first, unload current version (if available):<\/p>\n

sudo launchctl unload \/Library\/LaunchDaemons\/org.postgresql.dbms.plist<\/pre>\nEdit the\u00a0org.postgresql.dbms.plist (if not available, create a new one):<\/p>\n
\r\n\r\n\r\n\r\n        Label<\/key>\r\n        org.postgresql.postgres<\/string>\r\n        ProgramArguments<\/key>\r\n        \r\n                \/Library\/PostgreSQL\/9.1\/bin\/postmaster<\/string>\r\n                -D<\/string>\r\n                \/Library\/PostgreSQL\/9.1\/data<\/string>\r\n        <\/array>\r\n        RunAtLoad<\/key>\r\n        \r\n        UserName<\/key>\r\n        _postgres<\/string>\r\n<\/dict>\r\n<\/plist>\r\n<\/pre>\nLoad new configuration:<\/p>\n
sudo launchctl load \/Library\/LaunchDaemons\/org.postgresql.dbms.plist<\/pre>\nBefore reboot your Mac you need to check if the folder data has the right permission:<\/p>\n
sudo su - postgres\r\nchmod 700 \/Library\/PostgreSQL\/9.1\/data<\/pre>\nReboot your Mac. <\/p>\n
To manually start (and stop Postgres on MacOS), login as postgres and:<\/p>\n
pg_ctl -D \/Library\/PostgreSQL\/9.1\/data -l logfile start\r\npg_ctl -D \/Library\/PostgreSQL\/9.1\/data -l logfile stop<\/pre>\nShare this:<\/h3>LinkedIn<\/span><\/a><\/li>
Reddit<\/span><\/a><\/li>
Twitter<\/span><\/a><\/li>
Facebook<\/span><\/a><\/li>
Skype<\/span><\/a><\/li>
Pocket<\/span><\/a><\/li>
<\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"To start a new Postgres version as Daemon you need to follow these commands. For first, unload current version (if available): sudo launchctl unload \/Library\/LaunchDaemons\/org.postgresql.dbms.plist Edit the\u00a0org.postgresql.dbms.plist (if not available, create a new one): Label org.postgresql.postgres ProgramArguments \/Library\/PostgreSQL\/9.1\/bin\/postmaster -D \/Library\/PostgreSQL\/9.1\/data RunAtLoad UserName _postgres Load new configuration: sudo launchctl load \/Library\/LaunchDaemons\/org.postgresql.dbms.plist Before reboot your Mac you […]<\/p>\nShare this:<\/h3>LinkedIn<\/span><\/a><\/li>
Reddit<\/span><\/a><\/li>
Twitter<\/span><\/a><\/li>
Facebook<\/span><\/a><\/li>
Skype<\/span><\/a><\/li>
Pocket<\/span><\/a><\/li>
<\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"footnotes":""},"categories":[14],"tags":[9,3],"_links":{"self":[{"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/posts\/5"}],"collection":[{"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/comments?post=5"}],"version-history":[{"count":53,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/posts\/5\/revisions"}],"predecessor-version":[{"id":90,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/posts\/5\/revisions\/90"}],"wp:attachment":[{"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/media?parent=5"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/categories?post=5"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.andreagirardi.it\/blog\/wp-json\/wp\/v2\/tags?post=5"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}