• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here:Home » Installing WordPress with PostgreSQL on Rackspace Cloud Server

By Abhishek Ghosh September 12, 2012 6:14 pm Updated on September 12, 2012

Installing WordPress with PostgreSQL on Rackspace Cloud Server

Advertisement

Installing WordPress with PostgreSQL on Rackspace Cloud Server is possible, and it is more fast, adaptable to load balanced Cloud with nginx and Apache server. There are many points you must know before really progressing to this this guide for Installing WordPress with PostgreSQL on Rackspace Cloud Server.

 

Installing WordPress with PostgreSQL on Rackspace Cloud Server : Facts You Must Know

 

Everyone knows WordPress is the best for several reasons. But it is matter of fact, WordPress is actually build for typical LAMP server, and Apache has plus and minus points. Instead of MySQL if we use PostgreSQL, theoretically it will work after doing a bit tweak, but with unmodified WordPress does have problem. There are some WordPress Plugin (s) that can change or translate the Database type, but they / it is a horrible approach because you are basically using a kind of compromised WordPress.

As we always want WordPress to work some what like Django framework, we can work a bit to run WordPress in that way. Please do not run your production / serious website in this way, this is a kind of experimentation,  basically it will be good if you have your own git repo on other server for maintenance and updates. So do not follow this guide for Installing WordPress with PostgreSQL on Rackspace Cloud Server if it is a serious website. You can use nginx instead of Apache, or normally Apache, it really does not matter much. Ultimately you have to run PHP to serve the pages.

Advertisement

---

 

Installing WordPress with PostgreSQL on Rackspace Cloud Server : The basics

 

This is the excerpt of the ways we did ourselves for Installing WordPress with PostgreSQL on Rackspace Cloud Server. It is intended for mainly for the developers who are used with Command Line Works and Cloud environment. This guide will point you towards Installing WordPress with PostgreSQL on Rackspace Cloud Server in a ‘public’ method, actually we used own moded version and unless we are sure it has at least some security, we can not publish the repo at github.

 

 

Installing WordPress with PostgreSQL on Rackspace Cloud Server

 

First build at least two servers.  One will run the nginx, that can be done easily by following this guide to install WordPress on nginx. You can run Apache http server if you want. Whatever, try to use Ubuntu as it will make the steps easier. This is not for your database server, this is for your FTP contents.  So map the domain accordingly. Basically you can see the default WordPress installation webpage if you start the webserver and point to the installation webpage on browser. Clean and clear. But we will not install WordPress fully in that way, we will install git. The steps should be like this :

 

Vim
1
sudo aptitude build-dep git-core

Vim
1
wget http://kernel.org/pub/software/scm/git/git-1.7.1.tar.gz

Vim
1
http://kernel.org/pub/software/scm/git/

Vim
1
cd git-1.7.1

Vim
1
./configure

Vim
1
 make

Vim
1
sudo make install

 

Or you can install by :

 

sudo apt-get install git python libssl-dev in the way we followed on this guide.

Stop here after installing git. Its ready but we will work on building the PostgreSQL server. Please read the article on Hostname and Fully Qualified Host Name to understand that, we will actually not use localhost, but either the IP or the  Fully Qualified Host Name. You can do it on the one server but it can be messy and the elastic fun of Cloud will not be perceived.

 

This database server will also be Ubuntu. The steps are :

 

Vim
1
sudo apt-get install postgresql

Vim
1
sudo apt-get install pgadmin3

 

The second one is to give you a GUI based web software like PHPMyAdmin.

 

Vim
1
sudo -u postgres psql postgres

Vim
1
sudo -u postgres createdb mydb

 

Basically you will be able to create your own PostgreSQL server, like Rackspace Cloud offers for MySQL and Oracle. Please try to understand how you can actually use git to pull and deploy the modified WordPress from Deploying WordPress as Facebook App With Heroku Cloud guide. As a developer, you will understand the logic.

 

This is not really a full step by step guide for Installing WordPress with PostgreSQL on Rackspace Cloud Server, as soon we can compile to make it more fast, with whatever the database is, we will release our repo after security testing. You basically need another server as git repo, where you have to modify the latest updates and install / update using git.

 

 

 

SignatureTagged With wordpress postgresql , wordpress with postgresql , wordpress 5 postgres , wordpress instal on postgress , wordpress postgresql language:en , wordpress running oin postgresql
Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Installing WordPress with PostgreSQL on Rackspace Cloud Server

  • Nginx WordPress Installation Guide (All Steps)

    This is a Full Nginx WordPress Installation Guide With All the Steps, Including Some Optimization and Setup Which is Compatible With WordPress DOT ORG Example Settings For Nginx.

  • WordPress Multisite on Nginx on Ubuntu 14.04 on HP Cloud

    Here is a Step by Step Guide on Setting Up WordPress Multisite on Nginx on Ubuntu 14.04 on HP Cloud with All Commands and the Configuration.

  • Steps To Install Nginx Plus on Ubuntu Server (HP Cloud)

    Here Are the Steps To Install Nginx Plus on Ubuntu Server Running on HP Cloud. Nginx Plus is the Paid Version of Nginx with Extra Features.

  • OpenShift OctoPress Auto install Script

    OpenShift OctoPress Auto install Script is an Advanced Script to Run OctoPress on Free OpenShift PaaS Practically Without Any Knowing Ruby or Git.

performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • PowerAmp Settings for Higher Sound QualityOctober 4, 2023
  • Affordable Earphone/IEM for Audiophiles: HiFiMan RE-400 WaterlineOctober 2, 2023
  • What is Hardware Security Module (HSM)September 30, 2023
  • Transducer Technologies of HeadphonesSeptember 28, 2023
  • What is Analog-to-Digital Converter (ADC)September 27, 2023
PC users can consult Corrine Chorney for Security.

Want to know more about us?

Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy