Tagged Questions
0
votes
1answer
663 views
How to send task to celery using redis pubsub with postgresql?
How do you send task to celery through redis pubsub once a new record has been inserted into a postgresql table?
My problem here is to get redis to listen for inserts in my postgresql table, and when ...
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 ...
0
votes
0answers
133 views
Postgres segfault on Ubuntu 12.04 64
i have a unbelivable problem:
Ubuntu server 12.04 64 bit running on Wmware Infrastructure, postgres 9.2 and django connecting via psycopg. Randomly postgres crashes with segfault, si i restart it an ...
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 ...
0
votes
1answer
926 views
How do I install psycopg2 for multiple python interpreters on a CentOS box?
I have a CentOS 5.5 box, which comes preloaded with Python 2.4. I wanted 2.6, so used yumto get it from the EPEL repository. I also used yum to install the psycopg2 package, but it installed it for ...
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
170 views
sqlalchemy fails to connect to db after server is idle for a few hours
I have a fairly standard setup where the application server is separated by a firewall from the database server. The application is using sqlalchemy and the db is postgres.
The system works fine for ...
0
votes
1answer
501 views
How to install Python and PostgreSQL on CentOS
I have a dedicated server running centOS.
I want to install python 2.6 and postgreSQL on it so python users can host their web apps on my server. (Apache)
Can anyone give me a detailed tutorial for ...
3
votes
1answer
244 views
How precise is cron?
Hey everyone.
I am trying to set up a python script to query a DB for all updates over the past 5 minutes. Given the number of updates, it must be as precise as possible (our records are timestamped ...
0
votes
3answers
158 views
creating database in remote server
I want to install a postgresql database on a remote linux server. In order to create the database on the remote server, I wrote a script in a python that executes the commands on the server. I am ...
1
vote
2answers
907 views
Install python-psycopg on Ubuntu 9.10
How can I install python-psycopg (not python-psycopg2) on Ubuntu 9.10
"apt-get install python-psycopg" returns "Package python-psycopg has no installation candidate"
I also downloaded source code at ...
2
votes
2answers
510 views
Recommend books/resources for this stack: linux, lighttpd, postgres, webpy
I'm trying to learn to run a simple server (and python simultaneously, but that's beside the point). The tutorials available at the websites of the aforementioned technologies were enough to get the ...
