Re: [ADMIN] Using Postgresql as application server

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

Re: [ADMIN] lo_import/lo_export in other table

2011-08-16 Thread Greg Spiegelberg
On Fri, Aug 12, 2011 at 12:31 PM, Nelson Gonzaga ngonz...@yahoo.com wrote: Hi all, How can I modify (or create other one) lo_import to save data in my table (not in pg_largeobject). Because I'm making an app that create a table with my fields and a bytea field, but .net doesn't read that

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

2011-08-16 Thread John DeSoi
On Aug 13, 2011, at 2:44 PM, s...@bestmx.ru wrote: c k wrote: Yes, I know that I can not create a simple web application using only postgresql because we need a web server to server the html content. u r wrong. u CAN! there is nginx_htttp_postgresql_module exactly to connect webserver

Re: [ADMIN] Using Postgresql as application server

2011-08-16 Thread Scott Marlowe
2011/8/16 s...@bestmx.ru s...@bestmx.ru: Scott Marlowe пишет: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@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

Re: [ADMIN] Using Postgresql as application server

2011-08-16 Thread Evan Rempel
Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that goes against a large commercial database that shall also remain nameless. The middleware has been

Re: [ADMIN] Using Postgresql as application server

2011-08-16 Thread s...@bestmx.ru
Evan Rempel пишет: Security is near impossible to manage as well. Again, almost everything needs to run as the same user. throw your nameless DMS away, or fire the architect. Scott Marlowe ÐÉÛÅÔ: On Mon, Aug 15, 2011 at 11:33 AM, s...@bestmx.rus...@bestmx.ru šwrote: Scott Marlowe ÐÉÛÅÔ:

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

2011-08-16 Thread Chris Travers
I can't let this slide :-D On Tue, Aug 16, 2011 at 9:27 AM, Evan Rempel erem...@uvic.ca wrote: Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that

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

2011-08-16 Thread Merlin Moncure
On Tue, Aug 16, 2011 at 11:27 AM, Evan Rempel erem...@uvic.ca wrote: Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware product that shall remain nameless, that goes against a large

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

2011-08-16 Thread Scott Marlowe
On Tue, Aug 16, 2011 at 12:25 PM, Merlin Moncure mmonc...@gmail.com wrote: one point that is getting lost in all this that if you are using a database for an application server, this does not mean it's the same database as your main database or even on the same machine -- you can still keep

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

2011-08-16 Thread c k
I want to use the postgresql for exactly the same use. I want to keep my database separate and use another postgresql machine just as application server. Even for load balancing and scaling we can use many techniques mixed to get the work done. Chaitanya Kulkarni On Tue, Aug 16, 2011 at 11:55

Re: [ADMIN] lo_import/lo_export in other table

2011-08-16 Thread Nelson Gonzaga
Greg, Very cool your idea, I'll use it in my app. And about lo_export, how can I get the file from this table?   Tks, Nelson De: Greg Spiegelberg gspiegelb...@gmail.com Para: Nelson Gonzaga ngonz...@yahoo.com Cc: pgsql admin pgsql-admin@postgresql.org Enviadas: Terça-feira, 16 de Agosto de 2011

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

2011-08-16 Thread Craig James
On 8/16/11 10:24 AM, Chris Travers wrote: I can't let this slide :-D On Tue, Aug 16, 2011 at 9:27 AM, Evan Rempelerem...@uvic.ca wrote: Technically it can be done, but just because we can do something does not mean we should do something. Having said that... We have been using a middleware

[ADMIN] parsing audit table

2011-08-16 Thread M. D.
Hi everyone, I'm a bit lazy, or actually in a bit of a crunch. I added an audit recording a few months ago, but never really used it much, but today I'm seeing a bunch of suspicious activity by one user. Does someone have any function to quickly parse this data? I followed this:

Re: [ADMIN] parsing audit table

2011-08-16 Thread M. D.
Yes, that does work (and I've been doing just that), but I was hoping for some database function (in python preferably) that I could return a row with it's columns and then query corresponding data to make more sense out of it. I see it as a complicated function, but if someone would have a

Re: [ADMIN] [SQL] parsing audit table

2011-08-16 Thread Jaime Casanova
On Tue, Aug 16, 2011 at 4:02 PM, M. D. li...@turnkey.bz wrote: Hi everyone, I'm a bit lazy, or actually in a bit of a crunch.  I added an audit recording a few months ago, but never really used it much, but today I'm seeing a bunch of suspicious activity by one user.  Does someone have any