{"id":27610,"date":"2018-08-07T07:00:01","date_gmt":"2018-08-07T12:00:01","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=27610"},"modified":"2022-06-03T03:34:45","modified_gmt":"2022-06-03T08:34:45","slug":"how-to-install-postgresql-on-debian-9","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/","title":{"rendered":"How To Install PostgreSQL on Debian 9"},"content":{"rendered":"
<\/div>

\"How<\/p>\n

We will show you how to install PostgreSQL on Debian 9. PostgreSQL is an object-relational database management system written in C. It is free and open-source database system which main features are to store the data securely and to return the data as response to other applications requests. Installing\u00a0PostgreSQL on Debian 9 is fairly easy task, and it shouldn’t take more then 10 minutes to finish installing\u00a0PostgreSQL on Debian 9. Let’s get started.<\/p>\n

<\/p>\n

Before you start with the installation steps, make sure that you have a full root access to your Debian 9 VPS<\/a>, or at least you have a system user with sudo privileges<\/a>. If you do, connect to your server via SSH<\/a> and make sure all your system software is up to date. First, update the package index using the following command:<\/p>\n

apt-get update<\/pre>\n
Once the package index is updated, you can go ahead an update all your system software to the latest version using the command below:<\/p>\n
apt-get upgrade<\/pre>\n
This may take from few seconds to few minutes depending on the software that needs to be updated.<\/p>\n
Install PostgreSQL on Debian 9<\/h3>\n
The next step is to install the PostgreSQL database system on your Debian 9 VPS<\/a>. This step is fairly simple, just run the following command:<\/p>\n
apt-get install postgresql<\/pre>\n
It will install the PostgreSQL database server, client and other required tools.<\/p>\n
To check an verify that PosgreSQL server\/client are installed, you can use the following command:<\/p>\n
psql --version<\/pre>\n
It will show you the current version of PostgreSQL you have installed on your server:<\/p>\n
# psql --version\r\npsql (PostgreSQL) 9.6.7<\/pre>\n
Manage PostgreSQL on Debian 9<\/h3>\n
Now that the installation of PostgreSQL is completed, it is good to know how you can manage the PostgreSQL service on your PostgreSQL VPS<\/a>. To start the PostgreSQL service, run the following command on the terminal:<\/p>\n
systemctl start postgresql.service<\/pre>\n
To stop the PostgreSQL service, you can use the following command:<\/p>\n
systemctl stop postgresql.service<\/pre>\n
To restart the service, you can run the following command:<\/p>\n
systemctl restart postgresql.service<\/pre>\n
To check the status of the PostgreSQL service, run the following command:<\/p>\n
systemctl status postgresql.service<\/pre>\n
If PostgreSQL is up and running on your Linux VPS<\/a> at the moment, the output will be similar to the one below:<\/p>\n
# systemctl status postgresql.service\r\npostgresql.service - PostgreSQL RDBMS\r\n   Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)\r\n   Active: active (exited) since Sat 2018-07-21 10:57:16 CDT; 40min ago\r\n Main PID: 1018 (code=exited, status=0\/SUCCESS)\r\n   CGroup: \/system.slice\/postgresql.service\r\n<\/pre>\n
To enable the PostgreSQL service on system boot, run the following command:<\/p>\n
systemctl enable postgresql.service<\/pre>\n
In case you want PostgreSQL disabled on system boot, run the following command:<\/p>\n
systemctl disable postgresql.service<\/pre>\n
If you want to manage the PostgreSQL file locations, connections and authentication, resource usage, logging etc. you need to edit the main configuration file. The main configuration file for PostgreSQL is located in \/etc\/postgresql\/VERSION-NUMBER\/main<\/code> directory. So if your PostgreSQL version is 9.6, the location will be \/etc\/postgresql\/9.6\/main\/postgresql.conf<\/code><\/p>\n
You can use any text editor of your choice to open and edit the configuration file for PostgreSQL. The file consists of lines of form of NAME = VALUE<\/code> and make sure the changes you make are valid. Otherwise, PostgreSQL will not work. The configuration file is read on server startup so when you make changes you need to restart the PostgreSQL service in order for the changes to take effect.<\/p>\n
systemctl restart postgresql.service<\/pre>\n
Basic PostgreSQL usage on Debian 9<\/h3>\n
To access the PostgreSQL command line interface and manage the databases, you should log in as postgres<\/code> system user. Run the following command:<\/p>\n
su - postgres<\/pre>\n
Now, to enter to the PostgreSQL interactive terminal run the following command:<\/p>\n
psql<\/pre>\n
Your shell will change as follows:<\/p>\n
~$ psql\r\npsql (9.6.7)\r\nType \"help\" for help.\r\n\r\npostgres=#<\/pre>\n
Now you can execute command specific to PostgreSQL. For example, to list all current databases you can type \\l<\/code> and press Enter<\/code><\/p>\n
postgres=# \\l\r\n                                  List of databases\r\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges\r\n-----------+----------+----------+-------------+-------------+-----------------------\r\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n(3 rows)\r\n<\/pre>\n
You can also create databases and tables, insert data, retrieve data and do many other things using the PostgreSQL interactive terminal. For more information you can check the official PostgreSQL documentation.<\/p>\n
If you prefer using a graphical user interface to manipulate the databases and the data stored, we can recommend you to install and use phpPgAdmin<\/a>. It is a web-based administration tool for PostgreSQL similar to phpMyAdmin for managing the MySQL database system.<\/p>\n
\n
\"InstallingOf course, you don\u2019t have to install PostgreSQL on Debian 9, if you use one of our PostgreSQL VPS Hosting<\/a> plans, in which case you can simply ask our expert Linux admins to install PostgreSQL on Debian 9 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n
PS<\/strong><\/span>. If you liked this post on how to install PostgreSQL on Debian 9, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"
We will show you how to install PostgreSQL on Debian 9. PostgreSQL is an object-relational database management system written in … <\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":27721,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1700,13],"tags":[48,434],"yoast_head":"\nHow To Install PostgreSQL on Debian 9 - RoseHosting<\/title>\n<meta name=\"description\" content=\"How To Install PostgreSQL on Debian 9 - RoseHosting\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Install PostgreSQL on Debian 9 - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"How To Install PostgreSQL on Debian 9 - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-07T12:00:01+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:34:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How To Install PostgreSQL on Debian 9\",\"datePublished\":\"2018-08-07T12:00:01+00:00\",\"dateModified\":\"2022-06-03T08:34:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\"},\"wordCount\":706,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg\",\"keywords\":[\"debian\",\"PostgreSQL\"],\"articleSection\":[\"Databases\",\"Debian\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\",\"name\":\"How To Install PostgreSQL on Debian 9 - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg\",\"datePublished\":\"2018-08-07T12:00:01+00:00\",\"dateModified\":\"2022-06-03T08:34:45+00:00\",\"description\":\"How To Install PostgreSQL on Debian 9 - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg\",\"width\":742,\"height\":372,\"caption\":\"How To Install PostgreSQL on Debian 9\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Install PostgreSQL on Debian 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Install PostgreSQL on Debian 9 - RoseHosting","description":"How To Install PostgreSQL on Debian 9 - RoseHosting","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:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/","og_locale":"en_US","og_type":"article","og_title":"How To Install PostgreSQL on Debian 9 - RoseHosting","og_description":"How To Install PostgreSQL on Debian 9 - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2018-08-07T12:00:01+00:00","article_modified_time":"2022-06-03T08:34:45+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How To Install PostgreSQL on Debian 9","datePublished":"2018-08-07T12:00:01+00:00","dateModified":"2022-06-03T08:34:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/"},"wordCount":706,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg","keywords":["debian","PostgreSQL"],"articleSection":["Databases","Debian","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/","name":"How To Install PostgreSQL on Debian 9 - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg","datePublished":"2018-08-07T12:00:01+00:00","dateModified":"2022-06-03T08:34:45+00:00","description":"How To Install PostgreSQL on Debian 9 - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/07\/How-To-Install-PostgreSQL-on-Debian-9.jpg","width":742,"height":372,"caption":"How To Install PostgreSQL on Debian 9"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Install PostgreSQL on Debian 9"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/27610"}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=27610"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/27610\/revisions"}],"predecessor-version":[{"id":41780,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/27610\/revisions\/41780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/27721"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=27610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=27610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=27610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}