1
vote
1answer
133 views

RHEL SELinux blocking Apache access to PostgreSQL

I'm running a Django app that uses PostgreSQL. The server is running RHEL 6.5 with SELinux. I'm having an issue where the Django app can't connect to the DB, and I think it's because SELinux is ...
0
votes
1answer
59 views

Securing the Django web site which is run with Apache mod_wsgi

I have made a website in Django 1.6 with PostgreSQL database which is hosted on Ubuntu 12.04.3 with Apache 2.2.22 and I have recently noticed lots of hacking (probing) attempts from various IPs ...
-1
votes
1answer
33 views

Database management [closed]

First of all please forgive me if this question is off the topic. I have a developed social networking site where users can upload photos and update status. I thought of hosting in AWS EC2, but to get ...
1
vote
0answers
225 views

How to manage postgres server cpu load and idle in transaction warning? [closed]

I am using postgres db with django app. I created two daemon process out of it, one is used for scheduling some tasks(APScheduler) and other one is to dump events into database subscribing them via ...
1
vote
1answer
518 views

Django, PostGIS, Postgres on Mac OS X Installation Issues [closed]

So the context Django1.4.x doesn't support postgis2.0 (https://code.djangoproject.com/ticket/16455) Postgres9.2x doesnt support postgis1.5 ...
2
votes
5answers
5k views

Postgres used in Ubuntu 12.04

I am trying to get django running on an ubuntu 12.04 release using postgres (clean install). To get it running it used to be that you would have to edit the /etc/postgresql/9.1/main/pg_hba.conf file. ...
0
votes
1answer
97 views

Server performance worsened after a hardware upgrade: how should I reconfigure the server? [closed]

I'm running a site on an Ubuntu/Apache/Django/PostgreSQL stack. We upgraded our server recently from 1 processor with 2 Gb total RAM (with 0.5 Gb of that RAM assigned to memcached) to a new server ...
1
vote
1answer
427 views

Django error saying “could not connect to server: Permission denied”

I am getting an error trying to visit my Django app. I am running Gentoo and the web server is Apache with the mod_wsgi module to display Django. The error says OperationalError at /admin/ could not ...
3
votes
3answers
390 views

Getting more database performance - postgresql

There is a django "web application" (from hell) we are hosting on a dedicated server. After some benchmarking I found that the "Application" is amazingly bad at database operations (refactoring is not ...
1
vote
3answers
455 views

How to let python/django to access postgres db without requiring sudo -u

Still new in the Linux / django / python / postgres installation. I have install the latest kubuntu 11.04, installed the postgres and django packages. I have created a django_login in postgres with a ...
0
votes
1answer
286 views

Problem with Postgres authentification over apache

I'm on RHEL 5.4, and I've set up a Django project using PostgreSQL as the database (I've used MySQL before, but want to try something new :) ). When I run the Django test server, everything works, I ...
2
votes
2answers
2k views

Server Clustering (Django, Apache, Nginx, Postgres)

I have a project deployed with django, Apache, Nginx and Postgres. The project has requirement of live data viewable to customers. The projects main points are: 1. Devices in field send data to ...
6
votes
3answers
760 views

Development, Testing, Staging and Production model

I'm developing a run of the mill django powered website with a Postgres database. I develop locally and have 3 VPS servers for Testing, Staging and Production. Each VPS runs their own Linux / Apache ...
0
votes
2answers
1k views

How do I test whether a newly created user can communicate with a PostgreSQL database?

My settings: Ubuntu 9.10 PostgreSQL 8.4.2 I created a new user(jdoe) under my local PostgreSQL with the following command in the psql shell: CREATE USER jdoe WITH PASSWORD 'password'; I also ...
1
vote
3answers
2k views

How to debug slow queries in Django+Postgres

My database queries from Django are starting to take 1-2 seconds and I'm having trouble figuring out why. Not too big a site, about 1-2 requests per second (that hit Django; static files are just ...