{"id":844,"date":"2021-05-02T09:04:03","date_gmt":"2021-05-02T03:34:03","guid":{"rendered":"https:\/\/cenacle.io\/?p=644"},"modified":"2024-06-20T02:22:24","modified_gmt":"2024-06-20T02:22:24","slug":"launching-multiple-instances-of-postgraphile-with-pm2","status":"publish","type":"post","link":"https:\/\/gk.palem.in\/articles\/launching-multiple-instances-of-postgraphile-with-pm2\/","title":{"rendered":"Launching multiple instances of PostGraphile with PM2"},"content":{"rendered":"\n

PM2 allows you to restart your application instances if they stop for any internal reason. A typical way to launch the PostGraphile with PM2 <\/span>is as below:<\/p>\n\n\n\n

<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
pm2<\/span> <\/span>start<\/span> <\/span>--name<\/span> <\/span>"<\/span>postgraphile<\/span>"<\/span> <\/span>postgraphile<\/span> <\/span>--<\/span> <\/span>--append-plugins<\/span> <\/span>postgraphile-plugin-connection-filter<\/span> <\/span>-c<\/span> <\/span>postgres:\/\/user:password@localhost:15432\/db<\/span> <\/span>-s<\/span> <\/span>public<\/span> <\/span>-a<\/span> <\/span>-j<\/span> <\/span>-n<\/span> <\/span>0.0<\/span>.0.0<\/span> <\/span>-p<\/span> <\/span>15433<\/span> <\/span>--enhance-graphiql<\/span> <\/span>--disable-query-log<\/span> <\/span>--no-ignore-indexes<\/span> <\/span>--simple-collections<\/span> <\/span>both<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
The postgraphile-plugin-connection-filter<\/span> plugin can be installed with command as below:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
npm<\/span> <\/span>install<\/span> <\/span>-g<\/span> <\/span>tslib<\/span> <\/span>postgraphile-plugin-connection-filter<\/span> <\/span>postgraphile<\/span><\/span><\/code><\/pre><\/div>\n\n\n
\n
\"\"<\/figure>\n<\/div>\n\n\n
However, if you have multiple databases that need PostGraphile<\/span>, then you would have to start multiple instances of it and the way to achieve with PM2 is to have a configuration file as below:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
\/\/ content of pm2.config.js file<\/span><\/span>\nmodule.exports<\/span> <\/span>=<\/span> <\/span>{<\/span><\/span>\n   <\/span>"<\/span>apps<\/span>"<\/span>:<\/span> [<\/span><\/span>\n     <\/span>{<\/span><\/span>\n       <\/span>"<\/span>name<\/span>"<\/span>:<\/span> <\/span>"<\/span>postgraphile-mimic<\/span>"<\/span>,<\/span><\/span>\n       <\/span>"<\/span>script<\/span>"<\/span>:<\/span> <\/span>"<\/span>postgraphile --append-plugins postgraphile-plugin-connection-filter -c postgres:\/\/localhost\/mimic -s mimiciii -a -j -n 0.0.0.0 -p 15433 --enhance-graphiql --disable-query-log --no-ignore-indexes --simple-collections both<\/span>"<\/span>,<\/span><\/span>\n       <\/span>"<\/span>env<\/span>"<\/span>:<\/span> <\/span>{<\/span><\/span>\n         <\/span>"<\/span>PGUSER<\/span>"<\/span>:<\/span> <\/span>"<\/span>user<\/span>"<\/span>,<\/span><\/span>\n         <\/span>"<\/span>PGPASSWORD<\/span>"<\/span>:<\/span> <\/span>"<\/span>password<\/span>"<\/span>,<\/span><\/span>\n         <\/span>"<\/span>PGPORT<\/span>"<\/span>:<\/span> <\/span>15432<\/span>,<\/span><\/span>\n       <\/span>}<\/span><\/span>\n     <\/span>},<\/span><\/span>\n     <\/span>{<\/span><\/span>\n       <\/span>"<\/span>name<\/span>"<\/span>:<\/span> <\/span>"<\/span>postgraphile-fup<\/span>"<\/span>,<\/span><\/span>\n       <\/span>"<\/span>script<\/span>"<\/span>:<\/span> <\/span>"<\/span>postgraphile --append-plugins postgraphile-plugin-connection-filter -c postgres:\/\/localhost\/fup -s public -a -j -n 0.0.0.0 -p 15434 --enhance-graphiql --disable-query-log --no-ignore-indexes --simple-collections both<\/span>"<\/span>,<\/span><\/span>\n       <\/span>"<\/span>env<\/span>"<\/span>:<\/span> <\/span>{<\/span><\/span>\n         <\/span>"<\/span>PGUSER<\/span>"<\/span>:<\/span> <\/span>"<\/span>user<\/span>"<\/span>,<\/span><\/span>\n         <\/span>"<\/span>PGPASSWORD<\/span>"<\/span>:<\/span> <\/span>"<\/span>password<\/span>"<\/span>,<\/span><\/span>\n         <\/span>"<\/span>PGPORT<\/span>"<\/span>:<\/span> <\/span>15432<\/span>,<\/span><\/span>\n       <\/span>}<\/span><\/span>\n     <\/span>}<\/span><\/span>\n   ]<\/span><\/span>\n <\/span>}<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Launch the apps as below:<\/p>\n\n\n\n
<\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
pm2<\/span> <\/span>start<\/span> <\/span>pm2.config.js<\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
Now use the command pm2 list<\/span><\/code> to observe the status of the launched applications.<\/p>\n\n\n\n
If you are interested in gaining experience in working on cutting edge technologies Apply <\/strong><\/a>here.<\/p>\n","protected":false},"excerpt":{"rendered":"
Launching PostGraphile with PM2 allows multiple PostGres databases to be exposed through GraphQL.<\/p>\n
PostGraphile allows additional plugins to support advanced filtering and queries capabilities.<\/p>\n
However, PM2 requires special configuration to allows multiple processes with same script name to be started.<\/p>\n
In this post, we review the configuration required to achieve this.<\/p>\n","protected":false},"author":1,"featured_media":914,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_post_was_ever_published":false,"_cloudinary_featured_overwrite":false,"fifu_image_url":"https:\/\/res.cloudinary.com\/cenacle-cdn\/image\/upload\/v1619924497\/CenacleResearch\/blog\/images\/pm2.jpg","fifu_image_alt":"Launching multiple instances of PostGraphile with PM2","footnotes":""},"categories":[69],"tags":[70,83],"class_list":["post-844","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","tag-javascript","tag-node-js"],"jetpack_featured_media_url":"https:\/\/res.cloudinary.com\/cenacle-cdn\/image\/upload\/v1619924497\/CenacleResearch\/blog\/images\/pm2.jpg","jetpack-related-posts":[],"jetpack_shortlink":"https:\/\/wp.me\/pfLaRd-dC","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/posts\/844","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/comments?post=844"}],"version-history":[{"count":1,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/posts\/844\/revisions"}],"predecessor-version":[{"id":913,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/posts\/844\/revisions\/913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/media\/914"}],"wp:attachment":[{"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/media?parent=844"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/categories?post=844"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gk.palem.in\/articles\/wp-json\/wp\/v2\/tags?post=844"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}