{"id":17715,"date":"2015-09-25T05:33:00","date_gmt":"2015-09-25T10:33:00","guid":{"rendered":"https:\/\/secure.rosehosting.com\/blog\/?p=17715"},"modified":"2024-07-04T01:56:06","modified_gmt":"2024-07-04T06:56:06","slug":"how-to-install-drupal-with-postgresql-on-a-debian-8-vps","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/","title":{"rendered":"How to install Drupal with PostgreSQL on a Debian 8 VPS"},"content":{"rendered":"
<\/div>

\"drupallogo\"In this tutorial we will cover the steps needed to install the latest stable version of Drupal on your Debian 8 VPS<\/a> along with PostgreSQL<\/a>.<\/p>\n

Drupal is very popular and easy to use open-source CMS (content management system ) written in PHP. It is distributed under the GNU General Public License and used for managing, publishing and organizing a website, regardless of whether it is a personal blog or a corporate website.<\/p>\n

This install guide assumes that Apache and PHP are already installed and configured on your Debian 8 Linux VPS<\/a>. If not, you can learn how to Install LAMP (Linux, Apache, MySQL, PHP) on Debian 9<\/a>.<\/p>\n

Please note that you don’t need to install MySQL because we will install and use PostgreSQL for the Drupal installation.<\/p>\n

At the time of writing this tutorial, Drupal 7.39 is the latest stable version available and it requires:<\/p>\n

– Web Server: Apache, Nginx or Hiawatha
\n– PHP: 5.2 or higher
\n– Database Server: MySQL – 5.0 or higher, PostgreSQL – 8.3 or higher, or SQLite<\/p>\n

You can find more information about Drupal’s system requirements from their official documentation.<\/p>\n

Login to your server via SSH<\/p>\n

# ssh root@server_ip<\/pre>\n
Let\u2019s reassure that we have the proper version of Debian installed on our server :<\/p>\n
# lsb_release -a\n\nDistributor ID: Debian\nDescription:\u00a0\u00a0\u00a0 Debian GNU\/Linux 8.2 (jessie)\nRelease:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 8.2\nCodename:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 jessie<\/pre>\n
UPDATE THE SYSTEM<\/strong><\/p>\n
Make sure your server is fully up to date using:<\/p>\n
# apt-get update && apt-get upgrade -y<\/pre>\n
Install Drush:<\/p>\n
# apt-get install drush php-console-table<\/pre>\n
Debian Jessie installs the 5.10.0 version of Drush. If you like to install and use the latest release, enter the underneath commands:<\/p>\n
# pear channel-discover pear.drush.org\n\n# pear install drush\/drush<\/pre>\n
Check if the update was successful:<\/p>\n
# drush version<\/pre>\n
You should get the following output:<\/p>\n
# Drush Version : 6.2.0<\/pre>\n
INSTALL DRUPAL<\/strong><\/p>\n
We will download the Drupal installation into the \/var\/www\/html<\/strong> directory. <\/em>Then unpack the archive and set the proper ownership so the files can be processed by Apache. The below commands do exactly that:<\/em><\/p>\n
# cd \/var\/www\/html\/\n\n# wget http:\/\/ftp.drupal.org\/files\/projects\/drupal-7.39.zip\n\n# unzip drupal-7.39.zip\n\n# chown www-data: -R drupal-7.39<\/pre>\n
Rename the unpacked archive to your website name.<\/p>\n
# mv drupal-7.39 your_domain<\/pre>\n
INSTALL POSTGRESQL<\/strong><\/p>\n
Now, you need to install PostgreSQL and create a database and user that you will need to finish the Drupal installation. Issue the following command:<\/p>\n
# apt-get install postgresql postgresql-client php5-pgsql<\/pre>\n
Switch from root to the PostgreSQL user:<\/p>\n
# su postgres<\/pre>\n
You can create a PostgreSQL user by executing:<\/p>\n
# createuser drupaluser --pwprompt --encrypted<\/pre>\n
Enter your drupaluser password when prompted. Now, create a database and assign the user to it:<\/p>\n
# createdb drupal --owner=drupaluser<\/pre>\n
Exit from the postgres user:<\/p>\n
# exit<\/pre>\n
Last but not least, you need to create a new virtual host directive in Apache for your domain. You can create the file with your favorite text editor. For example we are using vim:<\/p>\n
# vim \/etc\/apache2\/sites-available\/your_domain.conf<\/pre>\n
Replace your_domain with your actual domain name and paste the following into the file:<\/p>\n
<VirtualHost *:80>\n\nServerAdmin webmaster@your_domain\nServerName your_domain\n\nDocumentRoot \/var\/www\/html\/your_domain\n\n<Directory \/var\/www\/html\/your_domain>\nRewriteEngine on\nRewriteBase \/mysite\nRewriteCond %{REQUEST_FILENAME} !-f\nRewriteCond %{REQUEST_FILENAME} !-d\nRewriteRule ^(.*)$ index.php?q=$1 [L,QSA]\n<\/Directory>\n\n<\/VirtualHost><\/pre>\n
Activate the rewrite module:<\/p>\n
# a2enmod rewrite<\/pre>\n
Enable your new virtual host directive:<\/p>\n
# a2ensite your_domain.conf<\/pre>\n
Restart Apache for the changes to take effect:<\/p>\n
# \/etc\/init.d\/apache2 restart<\/pre>\n
Next, enter your Drupal installation document root:<\/p>\n
# cd \/var\/www\/html\/your_domain\/<\/pre>\n
Change permissions of the CHANGELOG.txt to avoid security problems:<\/p>\n
# chmod 600 CHANGELOG.txt<\/pre>\n
Now, open your favorite web browser and navigate to http:\/\/your_domain\/install.php . You will be welcomed by the Drupal installation page like the one below:<\/p>\n
\"drupal\"<\/p>\n
Choose the Standard install. Click on Save and continue.<\/p>\n
After you choose your language and the requirements are verified, the installation will take you to the ‘Set up database’ part. Here you need to check the Database Type to PostgreSQL and enter the database and user values that you configured previously. Also, under ‘ADVANCED OPTIONS’ you should set the database port to 5432. Use the below picture for reference:<\/p>\n
\"drpos\"<\/p>\n
Once you are finished, click on ‘Save and continue’. After the installation is completed, configure your site according to your needs. Congratulations, you have successfully installed Drupal<\/a> with PostgreSQL on your Debian 8 VPS<\/a>.<\/p>\n
\n
Of course you don\u2019t have to do any of this if you use one of our Linux VPS Hosting<\/a> services, in which case you can simply ask our expert Linux admins to do this installation for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n
PS.<\/span> If you liked this post 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":"
In this tutorial we will cover the steps needed to install the latest stable version of Drupal on your Debian … <\/p>\n
Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":17716,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1710,1702,1700,13],"tags":[878,160,434],"class_list":["post-17715","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cms-crm-erp","category-databases","category-debian","category-tutorials","tag-debian-8","tag-drupal","tag-postgresql","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"\nHow to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting<\/title>\n<meta name=\"description\" content=\"How to install Drupal with PostgreSQL on a Debian 8 VPS | 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-drupal-with-postgresql-on-a-debian-8-vps\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to install Drupal with PostgreSQL on a Debian 8 VPS\" \/>\n<meta property=\"og:description\" content=\"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\" \/>\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=\"2015-09-25T10:33:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-07-04T06:56:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png\" \/>\n\t<meta property=\"og:image:width\" content=\"251\" \/>\n\t<meta property=\"og:image:height\" content=\"258\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\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-drupal-with-postgresql-on-a-debian-8-vps\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to install Drupal with PostgreSQL on a Debian 8 VPS\",\"datePublished\":\"2015-09-25T10:33:00+00:00\",\"dateModified\":\"2024-07-04T06:56:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\"},\"wordCount\":656,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png\",\"keywords\":[\"debian 8\",\"drupal\",\"PostgreSQL\"],\"articleSection\":[\"CMS, CRM, ERP\",\"Databases\",\"Debian\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\",\"name\":\"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png\",\"datePublished\":\"2015-09-25T10:33:00+00:00\",\"dateModified\":\"2024-07-04T06:56:06+00:00\",\"description\":\"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png\",\"width\":251,\"height\":258},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to install Drupal with PostgreSQL on a Debian 8 VPS\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"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\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"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\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?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 Premium plugin. -->","yoast_head_json":{"title":"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting","description":"How to install Drupal with PostgreSQL on a Debian 8 VPS | 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-drupal-with-postgresql-on-a-debian-8-vps\/","og_locale":"en_US","og_type":"article","og_title":"How to install Drupal with PostgreSQL on a Debian 8 VPS","og_description":"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2015-09-25T10:33:00+00:00","article_modified_time":"2024-07-04T06:56:06+00:00","og_image":[{"width":251,"height":258,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png","type":"image\/png"}],"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-drupal-with-postgresql-on-a-debian-8-vps\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to install Drupal with PostgreSQL on a Debian 8 VPS","datePublished":"2015-09-25T10:33:00+00:00","dateModified":"2024-07-04T06:56:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/"},"wordCount":656,"commentCount":3,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png","keywords":["debian 8","drupal","PostgreSQL"],"articleSection":["CMS, CRM, ERP","Databases","Debian","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/","name":"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png","datePublished":"2015-09-25T10:33:00+00:00","dateModified":"2024-07-04T06:56:06+00:00","description":"How to install Drupal with PostgreSQL on a Debian 8 VPS | RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2015\/09\/drupallogo.png","width":251,"height":258},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-drupal-with-postgresql-on-a-debian-8-vps\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to install Drupal with PostgreSQL on a Debian 8 VPS"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","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":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"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\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?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\/17715","targetHints":{"allow":["GET"]}}],"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=17715"}],"version-history":[{"count":6,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/17715\/revisions"}],"predecessor-version":[{"id":48765,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/17715\/revisions\/48765"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/17716"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=17715"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=17715"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=17715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}