Re: [ADMIN] [GENERAL] Using Postgresql as application server

2011-08-15 Thread Gavin Flower
On 14/08/11 05:12, David Johnston wrote: On Aug 13, 2011, at 11:57, c kshreeseva.learn...@gmail.com wrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As postgresql supports many languages like pl/perl, pl/python etc,

Re: [ADMIN] Using Postgresql as application server

2011-08-15 Thread Scott Marlowe
On Sat, Aug 13, 2011 at 9:57 AM, c k shreeseva.learn...@gmail.com wrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As postgresql supports many languages like pl/perl, Besides the previously mentioned nginx module there's

Re: [ADMIN] Using Postgresql as application server

2011-08-15 Thread Benjamin Krajmalnik
Further to Scott's comment, we are running our application platform on nginx/php (using php-fpm). It scales very well and it is extremely fast. When running under Apache, we had to constantly restart the apache service because it could not handle the load (at 150 concurrent users hitting the app

Re: [ADMIN] Using Postgresql as application server

2011-08-15 Thread s...@bestmx.ru
Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com wrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As postgresql supports many languages like pl/perl, Besides the previously mentioned

Re: [ADMIN] LONDISTE:replication tables with different names but same structure

2011-08-15 Thread Dimitri Fontaine
Prabhjot Sheena pshe...@ql2.com writes: what i know so far is that table name has to be same. but is there a way to have different table names but same table structures.If anyone have the answer plz help me It's possible in skytools3, using handlers, that are special python module to customize

Re: [ADMIN] Postgresql 8.4 replication using Londiste

2011-08-15 Thread Dimitri Fontaine
Maria L. Wilson maria.l.wilso...@nasa.gov writes: Interested in using Londiste to set up replication of only one column in a particular database to another database on a remote Postgres server. I've installed and configured londiste on the servers - that was no problem. I just don't see

Re: [ADMIN] Using Postgresql as application server

2011-08-15 Thread Scott Marlowe
On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.ru s...@bestmx.ru wrote: Scott Marlowe пишет: On Sat, Aug 13, 2011 at 9:57 AM, c kshreeseva.learn...@gmail.com  wrote: Dear Postgres users, from last few months I am reading and searching for can postgresql used as application server? As

Re: [ADMIN] Postgresql 8.4 replication using Londiste

2011-08-15 Thread Dimitri Fontaine
Craig James craig_ja...@emolecules.com writes: On the other hand, I've noticed that Londiste doesn't know when you change a table. You might be able to create your one-column table (plus PK), start replication with Londiste, then do ALTER TABLE to add the rest of the columns. A hack for

Re: [ADMIN] Postgresql 9.0.1 installation error

2011-08-15 Thread Venkat Balaji
Hi, This issue is resolved. Root Cause - 1. libpq library compilation problem 2. make file had the old configurations of previously performed installations Solution 1 - make clean must be fired after ./configure command and before make install command. Other work around ( possibly ) -