{"id":42601,"date":"2024-05-30T08:03:10","date_gmt":"2024-05-30T08:03:10","guid":{"rendered":"https:\/\/accuweb.cloud\/resource\/?post_type=faq&#038;p=42601"},"modified":"2026-02-19T04:38:28","modified_gmt":"2026-02-19T04:38:28","slug":"ssl-connection-to-postgresql","status":"publish","type":"faq","link":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql","title":{"rendered":"How to Establish SSL Connection to PostgreSQL DB Server?"},"content":{"rendered":"<h2 class=\"ack-h2\">How to Establish SSL Connection to PostgreSQL DB Server?<\/h2>\n<p>One of the biggest challenges in the Internet of Things is achieving top security. Today, we&#8217;ll learn how to set up a secure SSL connection to your PostgreSQL container on <strong>AccuWeb.Cloud.<\/strong><\/p>\n<p>To keep your PostgreSQL database safe, the first step is to encrypt all connections to protect usernames, passwords, and data from being intercepted.<\/p>\n<p>We&#8217;ll cover how to adjust the database server and generate the necessary certificates for SSL. Then, we&#8217;ll show how to add certificates to a client machine and finally establish a secure connection to our server using pgAdmin. Let&#8217;s get started!<\/p>\n<h2 class=\"ack-h2\">PostgreSQL Server Setup<\/h2>\n<p>In the instructions below, we&#8217;ll look at two setups: a single PostgreSQL database and a two-node cluster with master-slave replication.<\/p>\n<p>You can create a single node easily using the <strong>environment setup wizard.<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-01-1-1.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42607 size-full\" title=\"Create a Single Node\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-01-1-1.png\" alt=\"Create a Single Node\" width=\"977\" height=\"606\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-01-1-1.png 977w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-01-1-1-300x186.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-01-1-1-768x476.png 768w\" sizes=\"(max-width: 977px) 100vw, 977px\" \/><\/a><\/p>\n<p>For a quick cluster setup, use the pre-configured PostgreSQL Database Replication package found in the <strong>Marketplace &gt; Clusters<\/strong> section. To find what you need, use the search bar at the top. Then click <strong>Install<\/strong> for the right option.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-02-1-1.png\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42608 size-full\" title=\"Marketplace &gt; Clusters\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-02-1-1.png\" alt=\"Marketplace &gt; Clusters\" width=\"948\" height=\"634\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-02-1-1.png 948w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-02-1-1-300x201.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-02-1-1-768x514.png 768w\" sizes=\"(max-width: 948px) 100vw, 948px\" \/><\/a><\/p>\n<h2 class=\"ack-h2\">PostgreSQL Server Setup<\/h2>\n<p>Depending on your chosen setup, you&#8217;ll see either a single database node or two connected nodes (as shown above) in your AccuWeb dashboard.<\/p>\n<p><strong>Step 1.<\/strong> Access Your Database Server<\/p>\n<p>To start setting up an SSL connection, access your database server through AccuWeb SSH Gate. You can do this in two ways:<\/p>\n<p>The easiest way is to use the built-in <strong>Web SSH<\/strong> client directly from your AccuWeb Dashboard.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-03-1.png\"><img decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42609 size-full\" title=\"Web SSH\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-03-1.png\" alt=\"Web SSH\" width=\"1000\" height=\"328\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-03-1.png 1000w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-03-1-300x98.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-03-1-768x252.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<p>Alternatively, use your local SSH client. If you haven&#8217;t done this before, you&#8217;ll need to:<\/p>\n<ul class=\"ack-ul\">\n<li>Generate an SSH keypair.<\/li>\n<li>Add your public SSH key to the dashboard.<\/li>\n<li>Access your account via SSH.<\/li>\n<\/ul>\n<p><strong>Step 2.<\/strong> Add SSL Files<\/p>\n<p>Once you&#8217;re connected to your PostgreSQL server via SSH, add the following files to the \/var\/lib\/pgsql\/data directory for SSL:<\/p>\n<ul class=\"ack-ul\">\n<li>server.key \u2013 private key<\/li>\n<li>server.crt \u2013 server certificate<\/li>\n<li>root.crt \u2013 trusted root certificate<\/li>\n<\/ul>\n<p>If you already have these files, upload them using the Configuration Manager in the Accuweb dashboard and skip to Step 6. Otherwise, follow Steps 3-5 to generate them.<\/p>\n<p><strong>Step 3.<\/strong> Create the server.key File<\/p>\n<p>To create the server.key file, run these commands:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>$ cd \/var\/lib\/pgsql\/data<\/strong><\/li>\n<li><strong>$ openssl genrsa -des3 -out server.key 1024<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-045.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42617 size-full\" title=\"server.key\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-045.png\" alt=\"server.key\" width=\"997\" height=\"222\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-045.png 997w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-045-300x67.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-045-768x171.png 768w\" sizes=\"(max-width: 997px) 100vw, 997px\" \/><\/a><\/p>\n<p>You&#8217;ll be asked for a passphrase\u2014enter and confirm it. Then, remove the passphrase with this command:<\/p>\n<p><strong>$ openssl rsa -in server.key -out server.key<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-05-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42615 size-full\" title=\" openssl rsa\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-05-1.png\" alt=\" openssl rsa\" width=\"995\" height=\"202\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-05-1.png 995w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-05-1-300x61.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-05-1-768x156.png 768w\" sizes=\"(max-width: 995px) 100vw, 995px\" \/><\/a><\/p>\n<p>Re-enter the passphrase to confirm. Finally, set the file permissions and ownership:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>$ chmod 400 server.key<\/strong><\/li>\n<li><strong>$ chown postgres.postgres server.key<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-07.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42614 size-full\" title=\"400 server.key\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-07.png\" alt=\"400 server.key\" width=\"1000\" height=\"180\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-07.png 1000w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-07-300x54.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-07-768x138.png 768w\" sizes=\"(max-width: 1000px) 100vw, 1000px\" \/><\/a><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\"><strong>Note:<\/strong> If using a pre-generated certificate, ensure its permissions and ownership match those of the server.key file.<\/div>\n<div class=\"article-space\"><\/div>\n<p><strong>Step 4.<\/strong> Create the server.crt File<\/p>\n<p>Create a server certificate based on your server.key file:<\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-formula\">openssl req -new -key server.key -days 3650 -out server.crt -x509 -subj &#8216;\/C=US\/ST=NL\/L=Old Tappan\/O=Accuweb.cloud\/CN=mysite.com\/emailAddress=mail@Accuweb.com&#8217;<\/div>\n<div class=\"article-extra-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL08.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42613 size-full\" title=\"Create a server Certificate\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL08.png\" alt=\"Create a server Certificate\" width=\"998\" height=\"199\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL08.png 998w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL08-300x60.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL08-768x153.png 768w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/a><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\"><strong>Note:<\/strong> The -subj parameter is optional and needed only for production. You can also provide this information interactively if you prefer.<\/div>\n<div class=\"article-space\"><\/div>\n<p><strong>Step 5.<\/strong> Copy the Certificate<\/p>\n<p>Since we&#8217;re signing certificates ourselves, the server certificate we generated can also serve as a trusted root certificate. Simply make a copy of it with the appropriate name:<\/p>\n<p><strong>$ cp server.crt root.crt<\/strong><\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-09.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42612 size-full\" title=\"Copy the Certificate\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-09.png\" alt=\"Copy the Certificate\" width=\"1001\" height=\"163\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-09.png 1001w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-09-300x49.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-09-768x125.png 768w\" sizes=\"(max-width: 1001px) 100vw, 1001px\" \/><\/a><\/p>\n<p>Now that you have all three certificate files, you can proceed to configure PostgreSQL for SSL activation and usage.<\/p>\n<p><strong>Step 6.<\/strong> Configure pg_hba.conf<\/p>\n<p>In the same folder, edit the pg_hba.conf file. Replace its default content with the following lines:<\/p>\n<div class=\"article-space\"><\/div>\n<pre><code class=\"language-javascript\">\r\n# TYPE DATABASE USER CIDR-ADDRESS METHOD\r\n# \"local\" is for Unix domain socket connections only\r\nlocal all all trust\r\n# IPv4 local connections:\r\nhost all all 127.0.0.1\/32 trust\r\n# IPv4 remote connections for authenticated users\r\nhostssl all webadmin 0.0.0.0\/0 md5 clientcert=1\r\n# IPv6 remote connections for authenticated users\r\nhostssl all webadmin ::\/0 md5 clientcert=1<\/code><\/pre>\n<div class=\"article-extra-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-10-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42618 size-full\" title=\"Configure pg_hba.conf\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-10-1.png\" alt=\"Configure pg_hba.conf\" width=\"864\" height=\"604\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-10-1.png 864w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-10-1-300x210.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-10-1-768x537.png 768w\" sizes=\"(max-width: 864px) 100vw, 864px\" \/><\/a><\/p>\n<div class=\"article-space\"><\/div>\n<div class=\"ack-formula\"><strong>Tips:<\/strong><\/p>\n<ul class=\"ack-ul\">\n<li>If you have a clustered solution installed, perform the same step described above, except for the line related to replication\u2014it must remain unchanged to keep data replication enabled.<\/li>\n<li>If you&#8217;re not using the default webadmin user, replace it with your database username in the last lines of the file. Remember to use this username for all further commands.<\/li>\n<\/ul>\n<\/div>\n<div class=\"article-extra-space\"><\/div>\n<p><strong>Save<\/strong> the updated file.<\/p>\n<p><strong>Step 7.<\/strong> Configure postgresql.conf<\/p>\n<p>Navigate to the Security and Authentication section of the postgresql.conf file (around line 80) and enable SSL usage by uncommenting the ssl parameter and setting its value to &#8220;on&#8221;. Also, add the ssl_ca_file parameter:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>ssl = on<\/strong><\/li>\n<li><strong>ssl_ca_file = &#8216;root.crt&#8217;<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-11-1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42619 size-full\" title=\"postgresql.conf\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-11-1.png\" alt=\"postgresql.conf\" width=\"982\" height=\"604\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-11-1.png 982w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-11-1-300x185.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-11-1-768x472.png 768w\" sizes=\"(max-width: 982px) 100vw, 982px\" \/><\/a><\/p>\n<p>Save these changes.<\/p>\n<p><strong>Step 8.<\/strong> Restart PostgreSQL<\/p>\n<p>Finally, restart your PostgreSQL server to apply the new settings:<\/p>\n<p><strong>$ sudo service postgresql restart<\/strong><\/p>\n<h2 class=\"ack-h2\">Creating SSL Certificate Files for Clients<\/h2>\n<p>Now, let&#8217;s make another set of SSL certificate files for the client instance to enable secure connections on both sides.<\/p>\n<p><strong>Step 1.<\/strong> Generate a Private Key<\/p>\n<p>Go back to the terminal window where you connected to your PostgreSQL server using SSH during server setup. Generate a private key for the client. You&#8217;ll do this in the tmp directory:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>openssl genrsa -des3 -out \/tmp\/postgresql.key 1024<\/strong><\/li>\n<li><strong>openssl rsa -in \/tmp\/postgresql.key -out \/tmp\/postgresql.key<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-12.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42628 size-full\" title=\"Generate a Private Key\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-12.png\" alt=\"Generate a Private Key\" width=\"923\" height=\"331\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-12.png 923w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-12-300x108.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-12-768x275.png 768w\" sizes=\"(max-width: 923px) 100vw, 923px\" \/><\/a><\/p>\n<p><strong>Step 2.<\/strong> Create an SSL Certificate<\/p>\n<p>Next, create an SSL certificate for your PostgreSQL database user (usually webadmin) and sign it with your trusted root.crt file on the server.<\/p>\n<ul class=\"ack-ul\">\n<li><strong>openssl req -new -key \/tmp\/postgresql.key -out \/tmp\/postgresql.csr -subj &#8216;\/C=US\/ST=NJ\/L=Old Tappan\/O=Accuweb.cloud\/CN=webadmin&#8217;<\/strong><\/li>\n<li><strong>openssl x509 -req -in \/tmp\/postgresql.csr -CA root.crt -CAkey server.key -out \/tmp\/postgresql.crt -CAcreateserial<\/strong><\/li>\n<\/ul>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-13.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42627 size-full\" title=\"Create an SSL Certificate\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-13.png\" alt=\"Create an SSL Certificate\" width=\"938\" height=\"339\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-13.png 938w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-13-300x108.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-13-768x278.png 768w\" sizes=\"(max-width: 938px) 100vw, 938px\" \/><\/a><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\">\n<p><strong>Note:<\/strong><\/p>\n<ul class=\"ack-ul\">\n<li>You can change the data provided within the -subj parameter to your personal information, but the Common Name (\/CN=) must match the database username set in the pg_hba.conf server configuration file during the first certificate generation (usually webadmin).<\/li>\n<li>The second command must be run from the location (server directory) where the root.crt and server.key files are stored. Otherwise, you need to specify the full path to them.<\/li>\n<\/ul>\n<\/div>\n<div class=\"article-space\"><\/div>\n<p><strong>Step 3.<\/strong> Move the Files to the Client<\/p>\n<p>Once the files (postgresql.key, postgresql.crt, and root.crt) are ready, move them to the .postgresql folder on your client machine. You can do this through the Accuweb dashboard UI by downloading them or copying\/pasting the files&#8217; content.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-14.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42626 size-full\" title=\"Move the Files\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-14.png\" alt=\"Move the Files\" width=\"938\" height=\"522\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-14.png 938w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-14-300x167.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-14-768x427.png 768w\" sizes=\"(max-width: 938px) 100vw, 938px\" \/><\/a><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\"><strong>Tip:<\/strong> If the directory doesn&#8217;t exist, create it with the mkdir ~\/.postgresql or a similar command based on your OS distribution.<\/div>\n<div class=\"article-extra-space\"><\/div>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42625 size-full\" title=\"Create it with the mkdir \" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15.png\" alt=\"Create it with the mkdir \" width=\"1092\" height=\"493\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15.png 1092w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15-300x135.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15-1024x462.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-15-768x347.png 768w\" sizes=\"(max-width: 1092px) 100vw, 1092px\" \/><\/a><\/p>\n<p>You can also set read permission for the key to the owner only for added security with the <strong>chmod 400 ~\/.postgresql\/postgresql.key command.<\/strong><\/p>\n<div class=\"article-extra-space\"><\/div>\n<div class=\"ack-formula\">\n<p><strong>Tip:<\/strong> Remember to delete the keys from the tmp directory on your DB server afterward.<\/div>\n<div class=\"article-space\"><\/div>\n<h2 class=\"ack-h2\">Connecting with PgAdmin<\/h2>\n<p>Once you&#8217;ve finished setting up the server and client, you&#8217;re ready to connect. We&#8217;ll use the pgAdmin 3 tool as an example.<\/p>\n<p><strong>Step 1.<\/strong> Set Up an Endpoint<\/p>\n<p>To connect to the database server using SSL, you need either a Public IP or an endpoint attached to your PostgreSQL database container.<\/p>\n<p>For the latter case, go to environment <strong>Settings<\/strong>, switch to the <strong>Endpoints<\/strong> section, and <strong>Add<\/strong> a new endpoint.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42624 size-full\" title=\"Add a New Endpoint.\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16.png\" alt=\"Add a New Endpoint.\" width=\"1176\" height=\"520\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16.png 1176w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16-300x133.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16-1024x453.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-16-768x340.png 768w\" sizes=\"(max-width: 1176px) 100vw, 1176px\" \/><\/a><\/p>\n<p><strong>Step 2.<\/strong> Register the Server in pgAdmin<\/p>\n<p>With an access point set up, open pgAdmin 3 and select New Server Registration.<\/p>\n<p>In the Properties tab, fill in:<\/p>\n<ul class=\"ack-ul\">\n<li><strong>Name:<\/strong> Choose any name for the connection (like ssl-to-pgsql)<\/li>\n<li><strong>Host:<\/strong> Use the access point from the first step (Public IP or endpoint Access URL without port)<\/li>\n<li><strong>Port:<\/strong> Use the default 5432 port for External IP or the endpoint\u2019s Public port<\/li>\n<li><strong>Username:<\/strong> Use the database user you configured for SSL (usually webadmin)<\/li>\n<li><strong>Password:<\/strong> Enter the corresponding user\u2019s password<\/li>\n<\/ul>\n<p>Leave the rest unchanged or adjust as needed.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42623 size-full\" title=\"Register the Server in pgAdmin\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17.png\" alt=\"Register the Server in pgAdmin\" width=\"1028\" height=\"750\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17.png 1028w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17-300x219.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17-1024x747.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-17-768x560.png 768w\" sizes=\"(max-width: 1028px) 100vw, 1028px\" \/><\/a><\/p>\n<p><strong>Step 3.<\/strong> Enable SSL<\/p>\n<p>Switch to the <strong>Parameters<\/strong> tab and select the required option from the drop-down list for the SSL line.<\/p>\n<p><a href=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18.png\"><img loading=\"lazy\" decoding=\"async\" class=\"ack-article-image aligncenter wp-image-42622 size-full\" title=\"Parameters\" src=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18.png\" alt=\"Parameters\" width=\"1027\" height=\"745\" srcset=\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18.png 1027w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18-300x218.png 300w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18-1024x743.png 1024w, https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/05\/PostgreSQL-18-768x557.png 768w\" sizes=\"(max-width: 1027px) 100vw, 1027px\" \/><\/a><\/p>\n<p>That\u2019s it! The necessary certificates will be loaded automatically during the first connection. If not, you can choose them manually. Click <strong>Save<\/strong> to start managing your database securely.<\/p>\n<p>Now you can connect your application to the database and enable SSL configurations to encrypt your data during fetching or transferring.<\/p>\n<h2 class=\"ack-h2\">Conclusion<\/h2>\n<p>Setting up an SSL connection to a PostgreSQL database server involves a few simple steps. First, make sure both the server and client have the required SSL certificates and keys. Enable SSL on the PostgreSQL server by setting ssl = on in the postgresql.conf file and specifying the locations of the SSL certificate and key files.<\/p>\n<p>On the client side, configure the connection settings to use SSL by choosing the SSL mode (e.g., require, verify-ca, verify-full) and providing the client certificate and key if needed. Finally, test the connection to ensure SSL is working properly, creating a secure communication channel between the client and the PostgreSQL server.<\/p>\n<div class=\"cta-btn-top-space\"><\/div>\n\t\t<div data-elementor-type=\"section\" data-elementor-id=\"38668\" class=\"elementor elementor-38668\" data-elementor-settings=\"{&quot;ha_cmc_init_switcher&quot;:&quot;no&quot;}\" data-elementor-post-type=\"elementor_library\">\n\t\t\t        <section class=\"elementor-section elementor-top-section elementor-element elementor-element-882321f elementor-section-boxed elementor-section-height-default elementor-section-height-default ct-header-fixed-none ct-row-max-none\" data-id=\"882321f\" data-element_type=\"section\" data-settings=\"{&quot;_ha_eqh_enable&quot;:false}\">\n            \n                        <div class=\"elementor-container elementor-column-gap-default \">\n                    <div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-7cc79cc\" data-id=\"7cc79cc\" data-element_type=\"column\">\n        <div class=\"elementor-widget-wrap elementor-element-populated\">\n                    \n        \t\t<div class=\"elementor-element elementor-element-e31b40f elementor-widget elementor-widget-shortcode\" data-id=\"e31b40f\" data-element_type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><\/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 class=\"cta-btn-bottom-space\"><\/div>\n","protected":false},"author":1,"featured_media":52879,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","class_list":["post-42601","faq","type-faq","status-publish","has-post-thumbnail","hentry","faq_topics-connection-to-application-postgre-sql","faq_topics-databases","faq_topics-kb","faq_topics-postgre-sql","faq_topics-product-documentation","faq_topics-ssl-connection-to-postgresql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.10 (Yoast SEO v24.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>A secure SSL connection to PostgreSQL on AccuWeb.Cloud<\/title>\n<meta name=\"description\" content=\"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.\" \/>\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\/ssl-connection-to-postgresql\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Establish SSL Connection to PostgreSQL DB Server?\" \/>\n<meta property=\"og:description\" content=\"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql\" \/>\n<meta property=\"og:site_name\" content=\"AccuWeb Cloud\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-19T04:38:28+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=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#article\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql\"},\"author\":{\"name\":\"Jilesh Patadiya\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58\"},\"headline\":\"How to Establish SSL Connection to PostgreSQL DB Server?\",\"datePublished\":\"2024-05-30T08:03:10+00:00\",\"dateModified\":\"2026-02-19T04:38:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql\"},\"wordCount\":1408,\"publisher\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#organization\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-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\/ssl-connection-to-postgresql\",\"url\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql\",\"name\":\"A secure SSL connection to PostgreSQL on AccuWeb.Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#primaryimage\"},\"image\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#primaryimage\"},\"thumbnailUrl\":\"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg\",\"datePublished\":\"2024-05-30T08:03:10+00:00\",\"dateModified\":\"2026-02-19T04:38:28+00:00\",\"description\":\"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.\",\"breadcrumb\":{\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-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\/ssl-connection-to-postgresql#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/accuweb.cloud\/resource\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Establish SSL Connection to PostgreSQL DB Server?\"}]},{\"@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 &amp; 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":"A secure SSL connection to PostgreSQL on AccuWeb.Cloud","description":"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.","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\/ssl-connection-to-postgresql","og_locale":"en_US","og_type":"article","og_title":"How to Establish SSL Connection to PostgreSQL DB Server?","og_description":"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.","og_url":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql","og_site_name":"AccuWeb Cloud","article_modified_time":"2026-02-19T04:38:28+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":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#article","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql"},"author":{"name":"Jilesh Patadiya","@id":"https:\/\/accuweb.cloud\/resource\/#\/schema\/person\/a7a4cbe8405202b537509c757b588c58"},"headline":"How to Establish SSL Connection to PostgreSQL DB Server?","datePublished":"2024-05-30T08:03:10+00:00","dateModified":"2026-02-19T04:38:28+00:00","mainEntityOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql"},"wordCount":1408,"publisher":{"@id":"https:\/\/accuweb.cloud\/resource\/#organization"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-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\/ssl-connection-to-postgresql","url":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql","name":"A secure SSL connection to PostgreSQL on AccuWeb.Cloud","isPartOf":{"@id":"https:\/\/accuweb.cloud\/resource\/#website"},"primaryImageOfPage":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#primaryimage"},"image":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#primaryimage"},"thumbnailUrl":"https:\/\/accuweb.cloud\/resource\/wp-content\/uploads\/2024\/07\/NEW-OG-IMAGE-URL.jpg","datePublished":"2024-05-30T08:03:10+00:00","dateModified":"2026-02-19T04:38:28+00:00","description":"Learn how to set up a secure SSL connection to PostgreSQL container on AccuWeb.Cloud and protect your data from being intercepted.","breadcrumb":{"@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-to-postgresql"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/accuweb.cloud\/resource\/articles\/ssl-connection-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\/ssl-connection-to-postgresql#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/accuweb.cloud\/resource\/"},{"@type":"ListItem","position":2,"name":"How to Establish SSL Connection to PostgreSQL DB Server?"}]},{"@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 &amp; 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\/42601","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=42601"}],"version-history":[{"count":10,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/42601\/revisions"}],"predecessor-version":[{"id":53195,"href":"https:\/\/accuweb.cloud\/resource\/wp-json\/wp\/v2\/faq\/42601\/revisions\/53195"}],"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=42601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}