Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread David Goodenough
On Sunday 20 June 2010, Peter Eisentraut wrote: > On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote: > > These projects need help to realise that adding Postgresql is not a > > big > > job, especially for those using JDBC which can already connect to all > > DBs. It strikes me that if the

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread Sim Zacks
database agnostic code is theoretically a great idea. However, you lose most of the advantages of the chosen database engine. For example, if you support an engine that does not support relational integrity you cannot use delete cascades. The most efficient way is to have a separate backend module

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread David Goodenough
On Sunday 20 June 2010, Sim Zacks wrote: > database agnostic code is theoretically a great idea. However, you lose > most of the advantages of the chosen database engine. For example, if > you support an engine that does not support relational integrity you > cannot use delete cascades. > The most

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread Thomas Kellerer
David Goodenough wrote on 20.06.2010 11:08: I don't support anyone has written a "how to write database agnostic code" guide? That way its not a matter of porting, more a matter of starting off right. I don't believe in "database agnostic code". In the end it basically means that the applicat

Re: [GENERAL] Working with pages of data (LIMIT/OFFSET keyword)

2010-06-20 Thread Szymon Guz
2010/6/20 AI Rumman > I am using a PHP client. Is there a way to do the above task with php? > > > Sure, perform two queries in one transaction. regards Szymon Guz

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread Ivan Sergio Borgonovo
On Sun, 20 Jun 2010 12:52:22 +0200 Thomas Kellerer wrote: > David Goodenough wrote on 20.06.2010 11:08: > > I don't support anyone has written a "how to write database > > agnostic code" guide? That way its not a matter of porting, > > more a matter of starting off right. > > I don't believe in

[GENERAL] High Availability with Postgres

2010-06-20 Thread Elior Soliman
Hello, My company looking for some solution for High availability with Postgres. Our optional solution is as follows : Two DB servers will be using a common external storage (with raid). Both servers are going to use the same DB files on the storage (as active/passive) Now I'm trying to understa

Re: [GENERAL] High Availability with Postgres

2010-06-20 Thread David Fetter
On Sun, Jun 20, 2010 at 07:34:10PM +0300, Elior Soliman wrote: > Hello, > > My company looking for some solution for High availability with Postgres. > > Our optional solution is as follows : > Two DB servers will be using a common external storage (with raid). Stop right there. This is the Ora

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread David Fetter
On Sun, Jun 20, 2010 at 10:08:34AM +0100, David Goodenough wrote: > On Sunday 20 June 2010, Peter Eisentraut wrote: > > On lör, 2010-06-19 at 22:56 +0100, David Goodenough wrote: > > > These projects need help to realise that adding Postgresql is > > > not a big job, especially for those using JDBC

Re: [GENERAL] High Availability with Postgres

2010-06-20 Thread Craig Ringer
On 21/06/10 00:34, Elior Soliman wrote: > Hello, > > My company looking for some solution for High availability with Postgres. > > Our optional solution is as follows : > Two DB servers will be using a common external storage (with raid). Both > servers are going to use the same DB files on the s

Re: [GENERAL] Inserting additional data into pg_statistics

2010-06-20 Thread Teodor Macicas
Sorry for being so insistent, but I need to solve this one and I think that you can help me. Is here anyone who faced the same situation / problem ? If it is, please tell me how can I manually insert records into pg_statistics. Thank you again. Regards, Tedy Teodor Macicas wrote: Hello everyo

Re: [GENERAL] A thought about other open source projects

2010-06-20 Thread Adrian von Bidder
On Sunday 20 June 2010 12.52:22 Thomas Kellerer wrote: > I don't believe in "database agnostic code". Using a db abstraction may be the right way to write "database agnostic code". I have quite a good impression of SQLAlchemy, for example: it is quite generic, and it is still possible to write

Re: [GENERAL] High Availability with Postgres

2010-06-20 Thread John R Pierce
On 06/20/10 10:36 AM, David Fetter wrote: On Sun, Jun 20, 2010 at 07:34:10PM +0300, Elior Soliman wrote: My company looking for some solution for High availability with Postgres. Our optional solution is as follows : Two DB servers will be using a common external storage (with raid).

Re: [GENERAL] High Availability with Postgres

2010-06-20 Thread Raymond O'Donnell
On 20/06/2010 17:34, Elior Soliman wrote: > Hello, > > My company looking for some solution for High availability with Postgres. There's quite a bit of information in the documentation here: http://www.postgresql.org/docs/8.4/static/high-availability.html HTH, Ray. -- Raymond O'Donnell ::

Re: [GENERAL] High Availability with Postgres

2010-06-20 Thread Yaroslav Tykhiy
Hi, On 21/06/2010, at 3:37 AM, Raymond O'Donnell wrote: On 20/06/2010 17:34, Elior Soliman wrote: Hello, My company looking for some solution for High availability with Postgres. There's quite a bit of information in the documentation here: http://www.postgresql.org/docs/8.4/static/high