Switching to Postgresql from MySql26 Jun 2012
I have been using MySQL database as back end since my first Django web application. But as my applications started getting more and more complex, MySQL started giving me a lot of issues. One of the biggest issue was while performing south migrations. Usually migrations used to affect/break relationships and Django ORM used to return None objects. But a lot of times these migrations used to run correctly on my test PostgreSQL db. So finally I decided to switch onto PostgreSQL db.
But initially I faced a lot of problems while setting up PostgreSQL on my Ubuntu box. Basically its way different than the way we use MySQL. So gathered a lot of information over web and aggregating those here. This was for me, but probably useful for few of you, so making it public.
sudo apt-get install postgresql
Pgadmin tool for managing databases
sudo apt-get install pgadmin
Add password for default superuser postgres
The default superuser, called ‘postgres’, does not have a password by default. So we need to add password for this user
sudo su postgres -c psql template1 postgres=# ALTER USER postgres with PASSWORD '<your password>'; postgres=# q
Crate a user and database under that user
sudo -u postgres createuser -d -R -P <new username>
sudo -u postgres createdb -O <usename> <database name>
These are the basic things one should know who wants to switch their Django apps from MySql to PostgreSQL. Hope this post will help you. Do correct me if I made some wrong comments here in this post :).
Happy coding m/