Migrate app from MySQL to PostgreSQL

2008-10-29 Thread Naitik Shah
I looked around but didn't find anything obvious or simple. This is a live Django app with data in MySQL which I want to migrate to PostgreSQL. Suggestions? (Before I do my own thing :)) -Naitik --~--~-~--~~~---~--~~ You received this message because you are subsc

Re: Migrate app from MySQL to PostgreSQL

2008-10-30 Thread Naitik Shah
manage.py loaddata to get it all back? That should be pretty easy. > > > > -David Christiansen > > > > On Oct 30, 2:39 am, "Naitik Shah" <[EMAIL PROTECTED]> wrote: > > > > > I looked around but didn't find anything obvious or simple. This is a

Multiple Copies of Libraries, Apache/mod_wsgi and Performance

2008-10-30 Thread Naitik Shah
I'm serving a few sites from a tiny VPS, and I'm quite happy with a Apache/mod_wsgi setup. I've managed to reduce the Apache footprint by having only a few necessary modules loaded. mod_wsgi is setup to use daemon mode and start multiple processes per site. Currently, each site has its own python-

Re: How to setup django-apache-mod_wsgi without killing existing php site?

2008-10-30 Thread Naitik Shah
On Thu, Oct 30, 2008 at 4:14 PM, HÃ¥kan Waara <[EMAIL PROTECTED]> wrote: > > Hi folks, > > I'm in the process of for the first time deploying a django site that > (unfortunately) needs to share its Apache with an existing PHP site. > > I've been reading a bunch about mod_wsgi and in many places the

Re: Multiple Copies of Libraries, Apache/mod_wsgi and Performance

2008-10-30 Thread Naitik Shah
Hey Graham, On Thu, Oct 30, 2008 at 8:36 PM, Graham Dumpleton < [EMAIL PROTECTED]> wrote: > > How many processes in each daemon group and how many threads? I'm using 2 processes and 15 threads in each group. > Can you post the Apache configuration showing relationship between > sites and daem

Re: Multiple Copies of Libraries, Apache/mod_wsgi and Performance

2008-10-31 Thread Naitik Shah
On Thu, Oct 30, 2008 at 10:58 PM, Graham Dumpleton < [EMAIL PROTECTED]> wrote: > > If there are definite idle periods of reasonable size, perhaps look at > 'inactivity-timeout' option to WSGIDaemonProcess. This way daemon > process will be restarted when doing nothing, and providing that > preload

Re: Multiple Copies of Libraries, Apache/mod_wsgi and Performance

2008-10-31 Thread Naitik Shah
On Fri, Oct 31, 2008 at 1:01 PM, Naitik Shah <[EMAIL PROTECTED]> wrote: > On Thu, Oct 30, 2008 at 10:58 PM, Graham Dumpleton < > [EMAIL PROTECTED]> wrote: > >> >> In respect of having nginx in front, one of the over benefits of that >> was that nginx could h

Re: Migrate app from MySQL to PostgreSQL

2008-10-31 Thread Naitik Shah
On Fri, Oct 31, 2008 at 6:29 AM, varikin <[EMAIL PROTECTED]> wrote: > > Check out django_extensions app, > http://code.google.com/p/django-command-extensions/. > It has a command, dumpscript, which creates a python script to > populate the database. That might get ride of the incompatible types. >