{"id":11330,"date":"2018-01-08T13:48:08","date_gmt":"2018-01-08T13:48:08","guid":{"rendered":"https:\/\/mobisoftinfotech.com\/resources\/?p=11330"},"modified":"2025-10-06T14:41:40","modified_gmt":"2025-10-06T09:11:40","slug":"how-to-setup-postgresql-server-development-deployment","status":"publish","type":"post","link":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment","title":{"rendered":"How to Setup a PostgreSQL Server for Development Deployment?"},"content":{"rendered":"<p>In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.<\/p>\n<p>So, first you have to <strong>Create a Regular EC2 server<\/strong> and <strong>Launch an Instance<\/strong> to start your server.<\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11331\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance.png\" alt width=\"1063\" height=\"599\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance.png 1063w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-1024x577.png 1024w\" sizes=\"(max-width: 1063px) 100vw, 1063px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11331 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201063%20599%22%3E%3C%2Fsvg%3E\" alt width=\"1063\" height=\"599\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201063%20599%22%3E%3C%2Fsvg%3E 1063w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance.png 1063w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance-1024x577.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Regular-EC2-server-and-Launch-an-Instance.png\"><\/p>\n<p>For further process, follow the steps below:<\/p>\n<p><strong>Step 1: Choosing The Amazon Machine Image<\/strong><\/p>\n<ul>\n<li>Select <strong>\u201cUbuntu Server 16.04 LTS(HVM), SSD Volume Type\u201d<\/strong> as the Amazon Machine Image<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11332\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image.png\" alt width=\"1060\" height=\"596\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image.png 1060w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-768x432.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-1024x576.png 1024w\" sizes=\"(max-width: 1060px) 100vw, 1060px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11332 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201060%20596%22%3E%3C%2Fsvg%3E\" alt width=\"1060\" height=\"596\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201060%20596%22%3E%3C%2Fsvg%3E 1060w\" sizes=\"(max-width: 1060px) 100vw, 1060px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image.png 1060w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-768x432.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image-1024x576.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-1_-Choosing-The-Amazon-Machine-Image.png\"><\/p>\n<p><strong>Step 2: Choosing The Instance Type<\/strong><\/p>\n<ul>\n<li>Select <strong>\u201ct2.micro server\u201d<\/strong> as the Instance Type, since it is just going to run the database.<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11357\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type.png\" alt width=\"1063\" height=\"595\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type.png 1063w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-300x168.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-768x430.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-1024x573.png 1024w\" sizes=\"(max-width: 1063px) 100vw, 1063px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11357 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201063%20595%22%3E%3C%2Fsvg%3E\" alt width=\"1063\" height=\"595\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201063%20595%22%3E%3C%2Fsvg%3E 1063w\" sizes=\"(max-width: 1063px) 100vw, 1063px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type.png 1063w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-300x168.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-768x430.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-1024x573.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type.png\"><\/p>\n<ul>\n<li>If you are installing both Java as well as PostgreSQL, then choose <strong>\u201ct2.small\u201d<\/strong> which comes with 2GB of memory as opposed to <strong>\u201ct2. micro\u201d<\/strong> server with 1GB of memory.<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11358\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2.png\" alt width=\"1068\" height=\"600\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2.png 1068w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-1024x575.png 1024w\" sizes=\"(max-width: 1068px) 100vw, 1068px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11358 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201068%20600%22%3E%3C%2Fsvg%3E\" alt width=\"1068\" height=\"600\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201068%20600%22%3E%3C%2Fsvg%3E 1068w\" sizes=\"(max-width: 1068px) 100vw, 1068px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2.png 1068w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2-1024x575.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-2_-Choosing-The-Instance-Type-_2.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on \u201c<\/span><b>Next: Configure Instance Details\u201d<\/b><\/li>\n<\/ul>\n<p><strong>Step 3: Configuring Instance Details<\/strong><\/p>\n<ul>\n<li>Always select <strong>\u201cShutdown behaviour\u201d<\/strong> as <strong>\u201cStop\u201d<\/strong><\/li>\n<li><strong>\u201cEnable Termination Protection\u201d<\/strong> by selecting the Checkbox, which will protect you against accidental termination<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11333\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details.png\" alt width=\"1050\" height=\"596\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details.png 1050w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-1024x581.png 1024w\" sizes=\"(max-width: 1050px) 100vw, 1050px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11333 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201050%20596%22%3E%3C%2Fsvg%3E\" alt width=\"1050\" height=\"596\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201050%20596%22%3E%3C%2Fsvg%3E 1050w\" sizes=\"(max-width: 1050px) 100vw, 1050px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details.png 1050w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details-1024x581.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-3_-Configuring-Instance-Details.png\"><\/p>\n<ul>\n<li>Click on <strong>\u201cNext: Add Storage\u201d<\/strong><\/li>\n<\/ul>\n<p><strong>Step 4: Adding Storage<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Enter \u201c<\/span><b>Size<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>25GB<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select <\/span><b>Volume Type<\/b><span style=\"font-weight: 400;\"> as \u201c<\/span><b>General Purpose SSD(GP2)\u201d<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the Checkbox for \u201c<\/span><b>Delete On Termination<\/b><span style=\"font-weight: 400;\">\u201d, this means when the server is deleted, the Volume will also be deleted.<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11360\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage.png\" alt width=\"1061\" height=\"596\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage.png 1061w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-1024x575.png 1024w\" sizes=\"(max-width: 1061px) 100vw, 1061px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11360 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201061%20596%22%3E%3C%2Fsvg%3E\" alt width=\"1061\" height=\"596\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201061%20596%22%3E%3C%2Fsvg%3E 1061w\" sizes=\"(max-width: 1061px) 100vw, 1061px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage.png 1061w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage-1024x575.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-4_-Adding-Storage.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on <\/span><b>\u201cNext: Tag Instance\u201d<\/b><\/li>\n<\/ul>\n<p><b>Step 5: Tagging Instance<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Give a meaningful tag to the server, so that you can understand its use just from the name.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on \u201c<\/span><b>Next: Configure Security Group<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<\/ul>\n<p><b>Step 6: Configuring Security Group<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Since you need to run the database, then you have to Create the \u201c<\/span><b>Security Group Name<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>DevDb<\/b><span style=\"font-weight: 400;\">\u201d and \u201c<\/span><b>Description<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>Development db security group<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the \u201c<\/span><b>Type<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>SSH<\/b><span style=\"font-weight: 400;\">\u201d and \u201c<\/span><b>Port Range<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>22<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Add one more rule and Select \u201c<\/span><b>PostgreSQL<\/b><span style=\"font-weight: 400;\">\u201d from the Drop down list and Select \u201c<\/span><b>Port Range<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>5432<\/b><span style=\"font-weight: 400;\">\u201d and \u201c<\/span><b>source<\/b><span style=\"font-weight: 400;\">\u201d as \u201c<\/span><b>Anywhere<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11334\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group.png\" alt width=\"1200\" height=\"690\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group.png 1200w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-300x173.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-768x442.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-1024x589.png 1024w\" sizes=\"(max-width: 1200px) 100vw, 1200px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11334 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201200%20690%22%3E%3C%2Fsvg%3E\" alt width=\"1200\" height=\"690\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201200%20690%22%3E%3C%2Fsvg%3E 1200w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group.png 1200w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-300x173.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-768x442.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group-1024x589.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-6_-Configuring-Security-Group.png\"><\/p>\n<p><span style=\"font-weight: 400;\">Since this is a development database, you don\u2019t need to restrict the access from your office or Master server.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click \u201c<\/span><b>Review<\/b> <b>and<\/b> <b>Launch<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/li>\n<\/ul>\n<p><b>Step 7: Review Instance Launch<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">After reviewing all the details, Click on \u201c<\/span><b>Launch<\/b><span style=\"font-weight: 400;\">\u201d and a Dialog box will popup<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the Dialog box, \u201c<\/span><b>Select a Key Pair<\/b><span style=\"font-weight: 400;\">\u201d (for e.g. pritamec2demo) from the Drop Down list.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Select the \u201c<\/span><b>Checkbox<\/b><span style=\"font-weight: 400;\">\u201d for the acknowledgement of the access.<\/span><\/li>\n<li>Click \u201c<b>Launch Instances<\/b>\u201d<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11361\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch.png\" alt width=\"1202\" height=\"683\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch.png 1202w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-1024x582.png 1024w\" sizes=\"(max-width: 1202px) 100vw, 1202px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11361 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201202%20683%22%3E%3C%2Fsvg%3E\" alt width=\"1202\" height=\"683\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201202%20683%22%3E%3C%2Fsvg%3E 1202w\" sizes=\"(max-width: 1202px) 100vw, 1202px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch.png 1202w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch-1024x582.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The Instance will be launching and you can check the Instance status in \u201c<\/span><b>Instance State<\/b><span style=\"font-weight: 400;\">\u201d Tab.<\/span><\/li>\n<li>Typically, you have to use \u201c<b>Elastic IP<\/b>\u201d for your server, but since it is just for the development server we will just use \u201c<b>Public IP\u201d <\/b>(e.g. 54.210.213.181)<\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11335\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2.png\" alt width=\"1207\" height=\"685\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2.png 1207w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-1024x581.png 1024w\" sizes=\"(max-width: 1207px) 100vw, 1207px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11335 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201207%20685%22%3E%3C%2Fsvg%3E\" alt width=\"1207\" height=\"685\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201207%20685%22%3E%3C%2Fsvg%3E 1207w\" sizes=\"(max-width: 1207px) 100vw, 1207px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2.png 1207w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2-1024x581.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Step-7_-Review-Instance-Launch_2.png\"><\/p>\n<p><b>Connecting To The Server<\/b><\/p>\n<p><span style=\"font-weight: 400;\">In the directory where your pem file, (for e.g. pritamec2demo.pem) is present, use the login command <code>\u201cssh -i pritamec2demo.pem ubuntu@54.210.213.181\u201d<\/code> <span style=\"font-weight: 400;\"> and connect to the server. As it is a new server, you will need to do the \u201c<\/span><b>Basic Server Setup<\/b><span style=\"font-weight: 400;\">\u201d.<\/span><\/span><\/p>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">Make sure that port <\/span><b>5432<\/b><span style=\"font-weight: 400;\"> is open in the security group. If you are creating a development instance, then most likely you will use the same server for application server (PHP \/ Java) and your database. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you have already set up development app server then just use the same one, just modify the security group, and open the port 5432 from anywhere in the security group.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Instead of doing the Basic Server Setup manually, you can do it using the script. It is better to create a script in advance. Save the script folder and name it (e.g \u201c<\/span><b>basicsetup.sh<\/b><span style=\"font-weight: 400;\">\u201d)<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Use the following command for Basic Server Setup using the script \u201c<\/span><b>basicsetup.sh<\/b><span style=\"font-weight: 400;\">\u201d<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">For this you have to run the command,&nbsp;<\/span><code>\u201cvi basicsetup.sh\u201d<\/code><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Copy the script and paste it in the command window with the insert mode<\/span><\/li>\n<li style=\"font-weight: 400;\">Run <code>\u201cchmod +x basicsetup.sh\u201d<\/code>.<span style=\"font-weight: 400;\">This will make the file executable.<\/span><\/li>\n<li style=\"font-weight: 400;\">Run the file using the command with a format <code>\u201c<span style=\"font-weight: 400;\">.\/basicsetup.sh hostname FQDN public_ip<\/span><span style=\"font-weight: 400;\">\u201d<\/span><\/code><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">As the host name is \u2018<\/span><b>pgdemo<\/b><span style=\"font-weight: 400;\">\u2019, FQDN is \u2018<\/span><b>pgdemo.mi2.in<\/b><span style=\"font-weight: 400;\">\u2019, and public_ip is \u2019<\/span><b>54.210.213.181<\/b><span style=\"font-weight: 400;\">\u2019 then the command used to run the file will be:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>\u201c.\/basicsetup.sh pgdemo pgdemo.mi2.in 54.210.213.181\u201d<\/code><\/span><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Enter <\/span><b>\u2018y\u2019 <\/b><span style=\"font-weight: 400;\">if the details are correct<\/span><\/li>\n<\/ul>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">Since you are setting up a database, having the correct local set to <\/span><code><span style=\"font-weight: 400;\">'en_US.UTF-8'<\/span><\/code>&nbsp;<span style=\"font-weight: 400;\">is important. And if the script is ready, it almost takes care of all the basic things that you need to do on the server. <\/span><\/p>\n<ul>\n<li><b><b>Restart the server by running the command&nbsp;<\/b><\/b><code>\u201csudo init 6\u201d<\/code><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Once you have started the server, just proceed with the setup:<\/span><\/p>\n<ul>\n<li><b>Install PostgreSQL from the Ubuntu package repository<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For this you can use the command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo apt-get install -y postgresql postgresql-contrib<\/code><\/span><\/pre>\n<p><b>Note:<\/b><span style=\"font-weight: 400;\"> Here \u2018-y\u2019 means that you are sure that you want to install, so the installation will not prompt you once again.<\/span><\/p>\n<ul>\n<li><b>Back up the conf. file before running commands to modify it<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For this you can run the following command<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo cp \/etc\/postgresql\/9.5\/main\/postgresql.conf \/etc\/postgresql\/9.5\/main\/postgresql.conf.backup<\/code><\/span><\/pre>\n<ul>\n<li><b>Replace the listen address from localhost to \u2018*\u2019<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For this you can run the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo sed -i -e \"s\/#listen_addresses = 'localhost'\/listen_addresses = '*'\/g\" \/etc\/postgresql\/9.5\/main\/postgresql.conf<\/code><\/span><\/pre>\n<p><span style=\"font-weight: 400;\">This means, you can connect to the server from anywhere.<\/span><\/p>\n<ul>\n<li><b>Allow the server to be accessed\/logged in from anywhere<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For that you need to modify<\/span> <b>\u2018pg_hba.conf\u2019 <\/b><span style=\"font-weight: 400;\">file by running the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>echo 'host all all 0.0.0.0\/0 md5' | sudo tee -a \/etc\/postgresql\/9.5\/main\/pg_hba.conf<\/code><\/span><\/pre>\n<ul>\n<li><b>Open the \u2018pg_hba.conf\u2019 file<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">For this you can run the following command<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo vi \/etc\/postgresql\/9.5\/main\/pg_hba.conf<\/code><\/span><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Enter Shift + G to go to the last line<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11336\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server.png\" alt width=\"1099\" height=\"675\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server.png 1099w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-300x184.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-768x472.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-1024x629.png 1024w\" sizes=\"(max-width: 1099px) 100vw, 1099px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11336 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201099%20675%22%3E%3C%2Fsvg%3E\" alt width=\"1099\" height=\"675\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201099%20675%22%3E%3C%2Fsvg%3E 1099w\" sizes=\"(max-width: 1099px) 100vw, 1099px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server.png 1099w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-300x184.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-768x472.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server-1024x629.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Connecting-To-The-Server.png\"><\/p>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">Here <\/span><span style=\"font-weight: 400;\"><code>\u2018host all all 0.0.0.0\/0 md5\u2019<\/code> <\/span><span style=\"font-weight: 400;\">means that all the databases and all the users are allowed to connect remotely from anywhere on the internet and the password should be encoded using md5 hash.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For the local host address (e.g: 127.0.0.1), if the \u2018\/\u2019 is set to 32 (e.g. 127.0.0.1\/32). It means that all the 4 numbers of the IPv4 address must be matched.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If it is specified as 24, then a server having the address with matching first 3 numbers of IPv4 address will be allowed to connect.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Similarly, 16 means first 2 numbers of IPv4 address must match and 8 means first number of IPv4 address must match in order to connect.<\/span><\/p>\n<ul>\n<li><b>Restart the PostgreSQL server<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">You need to run the following command<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo service postgresql restart<\/code><\/span><\/pre>\n<ul>\n<li><b>Connect to the database (e.g. template1)<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">As you know, the default user is \u2018postgres\u2019. So you need to allow password authentication for this server.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For that you need to connect to the <\/span><b>\u2018template1\u2019<\/b><span style=\"font-weight: 400;\"> database by running the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo -u postgres psql template1<\/code><\/span><\/pre>\n<p><span style=\"font-weight: 400;\">You will run this command as \u2018<\/span><b>postgres\u2019 <\/b><span style=\"font-weight: 400;\">user and open the \u2018<\/span><b>psql\u2019 <\/b><span style=\"font-weight: 400;\">program for the \u2018<\/span><b>template1<\/b><span style=\"font-weight: 400;\">\u2019 database.<\/span><\/p>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">When you install the PostgreSQL server, the \u2018<\/span><b>postgres\u2019 <\/b><span style=\"font-weight: 400;\">user is automatically added to your Linux server.<\/span><\/p>\n<ul>\n<li><b>Set a new password for the postgres user<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Run the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>ALTER USER postgres with encrypted password 'dsfgrgS#^ffdfd345';<\/code><\/span><\/pre>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">Here, \u2018<\/span><span style=\"font-weight: 400;\">dsfgrgS#^ffdfd345\u2019 <\/span><span style=\"font-weight: 400;\">has been taken as a password for reference. You need to generate your own password.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Exit by running <\/span><span style=\"font-weight: 400;\">\u2018\/q\u2019<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Now you will check if you can <\/span><b>connect from your local machine<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Follow the below steps:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>pgAdmin 4<\/b><\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11362\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine.png\" alt width=\"1198\" height=\"681\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-768x437.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-1024x582.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11362 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20681%22%3E%3C%2Fsvg%3E\" alt width=\"1198\" height=\"681\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20681%22%3E%3C%2Fsvg%3E 1198w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-768x437.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine-1024x582.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/connect-from-your-local-machine.png\"><\/p>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">Since this postgres 9.5, you will require latest pgAdmin which is now a web app embedded inside a Native shell, which is a kind of a hybrid program and not much different from what we do while creating PhoneGap applications.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Now perform the following steps in <\/span><b>pgAdmin 4<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><b>Create a new server<\/b><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11338\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server.png\" alt width=\"1196\" height=\"677\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server.png 1196w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-1024x580.png 1024w\" sizes=\"(max-width: 1196px) 100vw, 1196px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11338 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201196%20677%22%3E%3C%2Fsvg%3E\" alt width=\"1196\" height=\"677\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201196%20677%22%3E%3C%2Fsvg%3E 1196w\" sizes=\"(max-width: 1196px) 100vw, 1196px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server.png 1196w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server-1024x580.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-server.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>\u2018Create-Server\u2019 <\/b><span style=\"font-weight: 400;\">dialog box, enter <\/span><b>\u2018Name\u2019 <\/b><span style=\"font-weight: 400;\">as <\/span><b>\u2018PG Demo Server\u2019<\/b><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11339\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server.png\" alt width=\"1197\" height=\"680\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server.png 1197w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-1024x582.png 1024w\" sizes=\"(max-width: 1197px) 100vw, 1197px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11339 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201197%20680%22%3E%3C%2Fsvg%3E\" alt width=\"1197\" height=\"680\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201197%20680%22%3E%3C%2Fsvg%3E 1197w\" sizes=\"(max-width: 1197px) 100vw, 1197px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server.png 1197w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server-1024x582.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/PG-Demo-Server.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>Connection <\/b><span style=\"font-weight: 400;\">Tab<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Enter your Elastic IP (e.g. 54.210.213.181) as the <\/span><b>\u2018Host name\/address\u2019<\/b><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Enter <\/span><b>\u2018Port\u2019 <\/b><span style=\"font-weight: 400;\">as 5432, \u2018<\/span><b>User name\u2019<\/b><span style=\"font-weight: 400;\"> (e.g. postgres) and \u2018<\/span><b>Password\u2019 <\/b><span style=\"font-weight: 400;\">which you have previously generated.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on <\/span><b>\u2018Save\u2019<\/b><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11340\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address.png\" alt width=\"1198\" height=\"682\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-768x437.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-1024x583.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11340 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20682%22%3E%3C%2Fsvg%3E\" alt width=\"1198\" height=\"682\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20682%22%3E%3C%2Fsvg%3E 1198w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-768x437.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address-1024x583.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Host-name-address.png\"><\/p>\n<p><span style=\"font-weight: 400;\">Now you can connect to the server<\/span><\/p>\n<p><b>Create a new Database<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>Servers<\/b><span style=\"font-weight: 400;\"> &gt;&gt; <\/span><b>PG Demo Server<\/b><span style=\"font-weight: 400;\"> &gt;&gt; <\/span><b>Database <\/b><span style=\"font-weight: 400;\">&gt;&gt;<\/span><b> Create <\/b><span style=\"font-weight: 400;\">&gt;&gt;<\/span><b> Database<\/b><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11363\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database.png\" alt width=\"1206\" height=\"683\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database.png 1206w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-1024x580.png 1024w\" sizes=\"(max-width: 1206px) 100vw, 1206px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11363 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201206%20683%22%3E%3C%2Fsvg%3E\" alt width=\"1206\" height=\"683\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201206%20683%22%3E%3C%2Fsvg%3E 1206w\" sizes=\"(max-width: 1206px) 100vw, 1206px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database.png 1206w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database-1024x580.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-new-Database.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>\u2018Create-Database\u2019 <\/b><span style=\"font-weight: 400;\">dialog box, enter the <\/span><b>\u2018Database name\u2019 (<\/b><span style=\"font-weight: 400;\">e.g. dev_db)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>Definition tab <\/b><span style=\"font-weight: 400;\">and select <\/span><b>\u2018Encoding\u2019 <\/b><span style=\"font-weight: 400;\">as UTF8 from the drop down list<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Set <\/span><b>\u2018Collation\u2019 <\/b><span style=\"font-weight: 400;\">as<\/span><b> \u2018en_US.UTF-8\u2019<\/b><span style=\"font-weight: 400;\">. This will help in proper sorting and searching of International character sets.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Click on <\/span><b>\u2018Save\u2019<\/b><span style=\"font-weight: 400;\">, that will run the query.<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11341\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name.png\" alt width=\"1194\" height=\"681\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name.png 1194w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-768x438.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-1024x584.png 1024w\" sizes=\"(max-width: 1194px) 100vw, 1194px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11341 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201194%20681%22%3E%3C%2Fsvg%3E\" alt width=\"1194\" height=\"681\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201194%20681%22%3E%3C%2Fsvg%3E 1194w\" sizes=\"(max-width: 1194px) 100vw, 1194px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name.png 1194w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-768x438.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name-1024x584.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Database-name.png\"><\/p>\n<p><span style=\"font-weight: 400;\">Now you can see that you database has been connected<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If you Go to the <\/span><b>\u2018SQL\u2019 <\/b><span style=\"font-weight: 400;\">tab, you can check the information about database name, encoding and collation as you entered.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">So your development PostgreSQL server is ready for use. However, in some Projects you might want to use a spatial extension for PostgreSQL which is called PostGIS.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">You can install PostGIS by performing the following steps:<\/span><\/p>\n<p><b>Step 1: Install PostGIS<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Run the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo apt-get install -y postgis postgresql-9.5-postgis-2.2<\/code><\/span><\/pre>\n<p><b>Step 2: Enable PostGIS for Database<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Run the following command:<\/span><\/p>\n<pre><span style=\"font-weight: 400;\"><code>sudo -u postgres psql -c \"CREATE EXTENSION postgis; CREATE EXTENSION postgis_topology;\" dev_db<\/code><\/span><\/pre>\n<p><span style=\"font-weight: 400;\">This command usually runs <\/span><b>\u201cCREATE EXTENSION\u201d <\/b><span style=\"font-weight: 400;\">query on the database. As you are running this command on the server, that\u2019s why you need to run it as postgres user.<\/span><\/p>\n<p><b>Step 3: <\/b><span style=\"font-weight: 400;\">Once the extension is installed, <\/span><\/p>\n<p><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>pgAdmin 4 <\/b><span style=\"font-weight: 400;\">&gt;&gt;<\/span><b> Servers <\/b><span style=\"font-weight: 400;\">&gt;&gt;<\/span><b> pg Demo Server <\/b><span style=\"font-weight: 400;\">&gt;&gt;<\/span><b> Databases &gt;&gt; dev_db <\/b><span style=\"font-weight: 400;\">and click \u2018<\/span><b>Refresh\u2019 <\/b><span style=\"font-weight: 400;\">from the options.<\/span><\/p>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11342\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh.png\" alt width=\"1199\" height=\"684\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh.png 1199w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-768x438.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-1024x584.png 1024w\" sizes=\"(max-width: 1199px) 100vw, 1199px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11342 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201199%20684%22%3E%3C%2Fsvg%3E\" alt width=\"1199\" height=\"684\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201199%20684%22%3E%3C%2Fsvg%3E 1199w\" sizes=\"(max-width: 1199px) 100vw, 1199px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh.png 1199w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-300x171.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-768x438.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh-1024x584.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Refresh.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Check if all the extensions are present <\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11343\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions.png\" alt width=\"1195\" height=\"678\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions.png 1195w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-1024x581.png 1024w\" sizes=\"(max-width: 1195px) 100vw, 1195px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11343 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201195%20678%22%3E%3C%2Fsvg%3E\" alt width=\"1195\" height=\"678\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201195%20678%22%3E%3C%2Fsvg%3E 1195w\" sizes=\"(max-width: 1195px) 100vw, 1195px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions.png 1195w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions-1024x581.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/extensions.png\"><\/p>\n<p><b>Step 4: Create a Table with Spatial Column<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to &gt;&gt; &nbsp;<\/span><b>Tools <\/b><span style=\"font-weight: 400;\">&gt;&gt; <\/span><b>Query Tool<\/b><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11364\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column.png\" alt width=\"1212\" height=\"684\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column.png 1212w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-1024x578.png 1024w\" sizes=\"(max-width: 1212px) 100vw, 1212px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11364 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201212%20684%22%3E%3C%2Fsvg%3E\" alt width=\"1212\" height=\"684\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201212%20684%22%3E%3C%2Fsvg%3E 1212w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column.png 1212w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column-1024x578.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Create-a-Table-with-Spatial-Column.png\"><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Create a table use the below query:<\/span><\/li>\n<\/ul>\n<pre><span style=\"font-weight: 400;\"><code>CREATE TABLE gis_table ( \n   id SERIAL PRIMARY KEY,\n &nbsp; geom GEOMETRY(Point, 26910),\n   name VARCHAR(128)\n);<\/code> <\/span><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Execute the query<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11345\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table.png\" alt width=\"1198\" height=\"678\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-1024x580.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11345 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20678%22%3E%3C%2Fsvg%3E\" alt width=\"1198\" height=\"678\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20678%22%3E%3C%2Fsvg%3E 1198w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-768x435.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table-1024x580.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/GIS-Table.png\"><\/p>\n<p><span style=\"font-weight: 400;\">To check the created table in <\/span><b>dev_db <\/b><span style=\"font-weight: 400;\">database,<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Go to &gt;&gt; <\/span><b>Schemas<\/b><span style=\"font-weight: 400;\"> &gt;&gt; <\/span><b>public<\/b><span style=\"font-weight: 400;\"> &gt;&gt; <\/span><b>Tables,<\/b><span style=\"font-weight: 400;\"> and you will see that \u2018<\/span><b>GIS Table<\/b><span style=\"font-weight: 400;\">\u2019 is present<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11346\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query.png\" alt width=\"1192\" height=\"676\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query.png 1192w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-1024x581.png 1024w\" sizes=\"(max-width: 1192px) 100vw, 1192px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11346 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201192%20676%22%3E%3C%2Fsvg%3E\" alt width=\"1192\" height=\"676\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201192%20676%22%3E%3C%2Fsvg%3E 1192w\" sizes=\"(max-width: 1192px) 100vw, 1192px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query.png 1192w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query-1024x581.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Execute-the-query.png\"><\/p>\n<p><b>Step 5: Add a Spatial Index<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Query Tool, <\/b><span style=\"font-weight: 400;\">use the below query<\/span><\/li>\n<\/ul>\n<pre><span style=\"font-weight: 400;\"><code>CREATE INDEX gis_table_gix\nON gis_table\nUSING GIST (geom);<\/code><\/span><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Execute the query<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11347\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index.png\" alt width=\"1198\" height=\"680\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-1024x581.png 1024w\" sizes=\"(max-width: 1198px) 100vw, 1198px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11347 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20680%22%3E%3C%2Fsvg%3E\" alt width=\"1198\" height=\"680\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201198%20680%22%3E%3C%2Fsvg%3E 1198w\" sizes=\"(max-width: 1198px) 100vw, 1198px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index.png 1198w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-300x170.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-768x436.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index-1024x581.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Spatial-Index.png\"><\/p>\n<p><b>Step 6: Add a Test Record<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Query Tool, <\/b><span style=\"font-weight: 400;\">use the below query<\/span><\/li>\n<\/ul>\n<pre><span style=\"font-weight: 400;\"><code>INSERT INTO gis_table (geom) VALUES (\n&nbsp;ST_GeomFromText('POINT(0 0)', 26910);\n);<\/code><\/span><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Execute the query<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11348\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record.png\" alt width=\"1212\" height=\"680\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record.png 1212w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-300x168.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-1024x575.png 1024w\" sizes=\"(max-width: 1212px) 100vw, 1212px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11348 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201212%20680%22%3E%3C%2Fsvg%3E\" alt width=\"1212\" height=\"680\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201212%20680%22%3E%3C%2Fsvg%3E 1212w\" sizes=\"(max-width: 1212px) 100vw, 1212px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record.png 1212w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-300x168.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-768x431.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record-1024x575.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Add-a-Test-Record.png\"><\/p>\n<p><b>Note: <\/b><span style=\"font-weight: 400;\">POINT(0 0) is a valid Geolocation. A lot of people don\u2019t consider it in validations.<\/span><\/p>\n<p><b>Step 7: Adding Nearby Points<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">In the <\/span><b>Query Tool, <\/b><span style=\"font-weight: 400;\">use the below query<\/span><\/li>\n<\/ul>\n<pre><code>SELECT id, name FROM gis_table \nWHERE ST_DWithin(\ngeom, \nST_GeomFromText('POINT(0 0)', 26910), \n1000\n);<\/code><\/pre>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Execute the query. It returns 1 record for a visit<\/span><\/li>\n<\/ul>\n<p><noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11365\" src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points.png\" alt width=\"1195\" height=\"674\" srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points.png 1195w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-1024x578.png 1024w\" sizes=\"(max-width: 1195px) 100vw, 1195px\"><\/noscript><img decoding=\"async\" class=\"alignnone size-full wp-image-11365 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201195%20674%22%3E%3C%2Fsvg%3E\" alt width=\"1195\" height=\"674\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%201195%20674%22%3E%3C%2Fsvg%3E 1195w\" sizes=\"(max-width: 1195px) 100vw, 1195px\" data-srcset=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points.png 1195w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-300x169.png 300w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-768x433.png 768w, https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points-1024x578.png 1024w\" data-src=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/Adding-Nearby-Points.png\"><\/p>\n<p><span style=\"font-weight: 400;\">With this, the PostgreSQL server and PostGIS Geospatial extension installation is completed.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server. So, first you have to Create a Regular EC2 server and Launch an Instance to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":11354,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_s2mail":"yes","footnotes":""},"categories":[450],"tags":[768,767],"class_list":["post-11330","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mguide","tag-postgis","tag-postgresql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>How to Setup a PostgreSQL Server for Development Deployment?<\/title>\n<meta name=\"description\" content=\"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Setup a PostgreSQL Server for Development Deployment?\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\" \/>\n<meta property=\"og:site_name\" content=\"Mobisoft Infotech\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-08T13:48:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-10-06T09:11:40+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png\" \/>\n\t<meta property=\"og:image:width\" content=\"853\" \/>\n\t<meta property=\"og:image:height\" content=\"391\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Pritam Barhate\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Pritam Barhate\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"12 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#article\",\"isPartOf\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\"},\"author\":{\"name\":\"Pritam Barhate\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\"},\"headline\":\"How to Setup a PostgreSQL Server for Development Deployment?\",\"datePublished\":\"2018-01-08T13:48:08+00:00\",\"dateModified\":\"2025-10-06T09:11:40+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\"},\"wordCount\":1545,\"image\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png\",\"keywords\":[\"PostGIS\",\"PostgreSQL Server\"],\"articleSection\":[\"MGuide\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\",\"name\":\"How to Setup a PostgreSQL Server for Development Deployment?\",\"isPartOf\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage\"},\"image\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png\",\"datePublished\":\"2018-01-08T13:48:08+00:00\",\"dateModified\":\"2025-10-06T09:11:40+00:00\",\"author\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\"},\"description\":\"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.\",\"breadcrumb\":{\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png\",\"contentUrl\":\"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png\",\"width\":853,\"height\":391,\"caption\":\"how to setup a postrgesql server for development deployment_banner\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mobisoftinfotech.com\/resources\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Setup a PostgreSQL Server for Development Deployment?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#website\",\"url\":\"https:\/\/mobisoftinfotech.com\/resources\/\",\"name\":\"Mobisoft Infotech\",\"description\":\"Discover Mobility\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mobisoftinfotech.com\/resources\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee\",\"name\":\"Pritam Barhate\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g\",\"caption\":\"Pritam Barhate\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Setup a PostgreSQL Server for Development Deployment?","description":"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment","og_locale":"en_US","og_type":"article","og_title":"How to Setup a PostgreSQL Server for Development Deployment?","og_description":"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.","og_url":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment","og_site_name":"Mobisoft Infotech","article_published_time":"2018-01-08T13:48:08+00:00","article_modified_time":"2025-10-06T09:11:40+00:00","og_image":[{"width":853,"height":391,"url":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png","type":"image\/png"}],"author":"Pritam Barhate","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Pritam Barhate","Est. reading time":"12 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#article","isPartOf":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment"},"author":{"name":"Pritam Barhate","@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee"},"headline":"How to Setup a PostgreSQL Server for Development Deployment?","datePublished":"2018-01-08T13:48:08+00:00","dateModified":"2025-10-06T09:11:40+00:00","mainEntityOfPage":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment"},"wordCount":1545,"image":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage"},"thumbnailUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png","keywords":["PostGIS","PostgreSQL Server"],"articleSection":["MGuide"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment","url":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment","name":"How to Setup a PostgreSQL Server for Development Deployment?","isPartOf":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage"},"image":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage"},"thumbnailUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png","datePublished":"2018-01-08T13:48:08+00:00","dateModified":"2025-10-06T09:11:40+00:00","author":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee"},"description":"In this tutorial, we will learn how to setup a PostgreSQL server for your development environment. Typically, for the production deployment we will use Amazon RDS as the database. However, for development deployments, we can use a standalone PgSQL server.","breadcrumb":{"@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#primaryimage","url":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png","contentUrl":"https:\/\/mobisoftinfotech.com\/resources\/wp-content\/uploads\/2018\/01\/how-to-setup-a-postrgesql-server-for-development-deployment_banner.png","width":853,"height":391,"caption":"how to setup a postrgesql server for development deployment_banner"},{"@type":"BreadcrumbList","@id":"https:\/\/mobisoftinfotech.com\/resources\/mguide\/how-to-setup-postgresql-server-development-deployment#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mobisoftinfotech.com\/resources\/"},{"@type":"ListItem","position":2,"name":"How to Setup a PostgreSQL Server for Development Deployment?"}]},{"@type":"WebSite","@id":"https:\/\/mobisoftinfotech.com\/resources\/#website","url":"https:\/\/mobisoftinfotech.com\/resources\/","name":"Mobisoft Infotech","description":"Discover Mobility","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mobisoftinfotech.com\/resources\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/mobisoftinfotech.com\/resources\/#\/schema\/person\/fa762036b3364f26abeea146c01487ee","name":"Pritam Barhate","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0e481c7ce54b3567ac70ddfc493523eefce0bdc3ee69fd2654f8f60a79e2f178?s=96&r=g","caption":"Pritam Barhate"}}]}},"_links":{"self":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/11330","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/comments?post=11330"}],"version-history":[{"count":24,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/11330\/revisions"}],"predecessor-version":[{"id":43636,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/posts\/11330\/revisions\/43636"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/media\/11354"}],"wp:attachment":[{"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/media?parent=11330"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/categories?post=11330"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mobisoftinfotech.com\/resources\/wp-json\/wp\/v2\/tags?post=11330"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}