{"id":42839,"date":"2024-05-31T12:15:58","date_gmt":"2024-05-31T12:15:58","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&p=42839"},"modified":"2026-02-19T04:29:07","modified_gmt":"2026-02-19T04:29:07","slug":"remote-access-to-postgresql","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql","title":{"rendered":"Remote Access to PostgreSQL"},"content":{"rendered":"

Remote Access to PostgreSQL<\/h2>\n

You now can manage your databases remotely from your computer without needing to log into our dashboard<\/a>. Here’s a guide specifically for PostgreSQL users:<\/p>\n

Setting Up Your Environment<\/h2>\n

You can access your database through a public IP<\/a> address or via endpoints<\/a> that don’t require a public IP. Let’s explore both methods for creating your database environment.<\/p>\n

Environment With Public IP<\/h3>\n

1. Log in<\/a> to the platform.<\/p>\n

2. Click on the New Environment<\/strong> button located at the top left of the dashboard.<\/p>\n

\"New<\/a><\/p>\n

3. In the Environment Topology<\/a> wizard, select PostgreSQL<\/strong> as your database. If you need a database cluster, enable the Auto-Clustering feature by sliding the switch to the right. Next, add a Public IPv4<\/strong> address. Provide a name for your environment, such as remotepostgres<\/strong>, and click the Create<\/strong> button.<\/p>\n

\"PostgreSQL<\/a><\/p>\n

The environment setup may take around a minute.<\/p>\n

\"Created<\/a><\/p>\n

Both nodes will have public IP addresses assigned.<\/p>\n

Environment Without Public IP<\/h3>\n

1. Follow the same steps as above to create a clustered database environment without attaching a public IP.<\/p>\n

\"PostgreSQL<\/a><\/p>\n

2. Once your environment is ready, navigate to the Endpoints<\/strong> section under Settings<\/strong> and click Add<\/strong> to create a new port mapping.<\/p>\n

\"Endpoints\"<\/a><\/p>\n

3. Select the Node<\/strong> you want to access and the PostgreSQL<\/strong> service Name<\/strong>. The remaining parameters (Private Port<\/strong>, Protocol<\/strong>, Public Port<\/strong>, and Access URL<\/strong>) will be generated automatically.<\/p>\n

\"Adding<\/a><\/p>\n

A port mapping for the database master node might look like this.<\/p>\n

\"Post<\/a><\/p>\n

Repeat the process for the slave node if necessary.<\/p>\n

<\/div>\n\t\t
\n\t\t\t
\n \n
\n
\n
\n \n \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t <\/div>\n <\/div>\n <\/div>\n <\/section>\n \t\t<\/div>\n\t\t\n
<\/div>\n

Remote Connection to PostgreSQL<\/h2>\n

To establish a connection to the database, you can use any desktop or web client. In this example, we\u2019ll use pgAdmin4, a highly popular and feature-rich Open Source administration and development tool for PostgreSQL. You can find client software suitable for your platform on the download page<\/a>, or deploy it by importing the corresponding pgAdmin4 manifest<\/a>.<\/p>\n

If you have a database cluster, it’s convenient to group all servers that belong to the cluster.<\/p>\n

\"Make<\/a><\/p>\n

1. Name the group, for example, remotepostgres<\/strong>.<\/p>\n

\"Name<\/a><\/p>\n

2. Add each database server to the group one by one. To add the Master database, right-click on the group (e.g., remotepostgres) and select Create > Server<\/strong>.<\/p>\n

\"Add<\/a><\/p>\n

3. In the General<\/strong> tab, enter the server name (e.g., Master<\/strong> for the primary database of your cluster).<\/p>\n

\"Add<\/a><\/p>\n

4. Specify the server access settings, based on whether your database was created with or without a public IP, as outlined earlier.<\/p>\n

Connection to Public IP<\/h3>\n

Head over to the Connection tab, where you’ll need to input the public IP of your master database in the Host name\/address<\/strong> field. Remember to fill in the Username<\/strong> and Password<\/strong> that you received via email when setting up your database environment.<\/p>\n

\"Connect<\/a><\/p>\n

Connection via Endpoints<\/h3>\n

Next, grab the URL<\/strong> and Public Port<\/strong> from the port mapping that was generated, and use these to configure your database server connection settings. Ensure that the Username<\/strong> and Password<\/strong> match the ones mentioned earlier.<\/p>\n

\"Server<\/a><\/p>\n

Feel free to adjust any other specific options if you’re confident in your choices.<\/p>\n

Once you’re done, hit Save<\/strong> to implement the changes. You’ll notice that the connection is successfully established.<\/p>\n

In our example, master databases are presented as follows:<\/p>\n

\"Established<\/a><\/p>\n

With that, PostgreSQL remote access is all set up, and you’re ready to start querying.<\/p>\n

<\/div>\n\t\t
\n\t\t\t
\n \n
\n
\n
\n \n \t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t <\/div>\n <\/div>\n <\/div>\n <\/section>\n \t\t<\/div>\n\t\t\n
<\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-42839","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-databases","faq_topics-kb","faq_topics-postgre-sql","faq_topics-product-documentation","faq_topics-remote-access-to-postgresql"],"yoast_head":"\nPostgreSQL Remote Access Explained | AccuWeb.Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Remote Access to PostgreSQL\" \/>\n<meta property=\"og:description\" content=\"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-19T04:29:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1280\" \/>\n\t<meta property=\"og:image:height\" content=\"720\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"Remote Access to PostgreSQL\",\"datePublished\":\"2024-05-31T12:15:58+00:00\",\"dateModified\":\"2026-02-19T04:29:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\"},\"wordCount\":543,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"inLanguage\":\"en-US\"},{\"@type\":[\"WebPage\",\"FAQPage\"],\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\",\"name\":\"PostgreSQL Remote Access Explained | AccuWeb.Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2024-05-31T12:15:58+00:00\",\"dateModified\":\"2026-02-19T04:29:07+00:00\",\"description\":\"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"width\":1280,\"height\":720},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Remote Access to PostgreSQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"name\":\"AccuWeb Cloud\",\"description\":\"Cutting Edge Cloud Computing\",\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\",\"name\":\"AccuWeb.Cloud\",\"url\":\"https:\/\/accuweb.cloud\/resource\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"contentUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg\",\"width\":156,\"height\":87,\"caption\":\"AccuWeb.Cloud\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\",\"name\":\"Jilesh Patadiya\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g\",\"caption\":\"Jilesh Patadiya\"},\"description\":\"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.\",\"sameAs\":[\"https:\/\/accuweb.cloud\/resource\",\"https:\/\/www.facebook.com\/accuwebhosting\",\"https:\/\/www.instagram.com\/accuwebhosting\/\",\"https:\/\/www.linkedin.com\/company\/accuwebhosting\/\",\"https:\/\/x.com\/accuwebhosting\",\"https:\/\/www.youtube.com\/c\/Accuwebhosting\"],\"url\":\"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL Remote Access Explained | AccuWeb.Cloud","description":"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.","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:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql","og_locale":"en_US","og_type":"article","og_title":"Remote Access to PostgreSQL","og_description":"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-19T04:29:07+00:00","og_image":[{"width":1280,"height":720,"url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"Remote Access to PostgreSQL","datePublished":"2024-05-31T12:15:58+00:00","dateModified":"2026-02-19T04:29:07+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql"},"wordCount":543,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","inLanguage":"en-US"},{"@type":["WebPage","FAQPage"],"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql","url":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql","name":"PostgreSQL Remote Access Explained | AccuWeb.Cloud","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2024-05-31T12:15:58+00:00","dateModified":"2026-02-19T04:29:07+00:00","description":"Learn how to set up remote access to your PostgreSQL databases with this guide. Manage your databases from your computer hassle-free.","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#primaryimage","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","width":1280,"height":720},{"@type":"BreadcrumbList","@id":"https:\/\/accuweb.cloud\/resource\/articles\/remote-access-to-postgresql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"Remote Access to PostgreSQL"}]},{"@type":"WebSite","@id":"https:\/\/accuweb.cloud\/resource\/#website","url":"https:\/\/accuweb.cloud\/resource\/","name":"AccuWeb Cloud","description":"Cutting Edge Cloud Computing","publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/accuweb.cloud\/resource\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/accuweb.cloud\/resource\/#organization","name":"AccuWeb.Cloud","url":"https:\/\/accuweb.cloud\/resource\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/","url":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","contentUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/04\/accuwebcloud_logo_black_tagline.jpg","width":156,"height":87,"caption":"AccuWeb.Cloud"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58","name":"Jilesh Patadiya","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2cea2bdb5bbabb771ee67e96acad7396f25cb1a0c360b9bc4a9ac40cea9cd8b2?s=96&d=mm&r=g","caption":"Jilesh Patadiya"},"description":"Jilesh Patadiya, the visionary Co-Founder and Chief Technology Officer (CTO) behind AccuWeb.Cloud. Founder & CTO at AccuWebHosting.com. He shares his web hosting insights on the AccuWeb.Cloud blog. He mostly writes on the latest web hosting trends, WordPress, storage technologies, and Windows and Linux hosting platforms.","sameAs":["https:\/\/accuweb.cloud\/resource","https:\/\/www.facebook.com\/accuwebhosting","https:\/\/www.instagram.com\/accuwebhosting\/","https:\/\/www.linkedin.com\/company\/accuwebhosting\/","https:\/\/x.com\/accuwebhosting","https:\/\/www.youtube.com\/c\/Accuwebhosting"],"url":"https:\/\/accuweb.cloud\/resource\/author\/accuwebadmin"}]}},"_links":{"self":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/42839","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq"}],"about":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/types\/faq"}],"author":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/comments?post=42839"}],"version-history":[{"count":3,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/42839\/revisions"}],"predecessor-version":[{"id":53183,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/42839\/revisions\/53183"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media\/52879"}],"wp:attachment":[{"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/media?parent=42839"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}