[ADMIN] Distributed database with PostgreSQL

2007-06-28 Thread POLONKAI Gergely
Hello list, We are currently developing a server cluster, and we are thinking of using PostgreSQL as our database backend. As I haven't found any information about this on the web (maybe I searched on the wrong keywords), I ask here: is it possible to run one database on multiple servers, so all t

Re: [ADMIN] Distributed database with PostgreSQL

2007-06-28 Thread hubert depesz lubaczewski
On 6/28/07, POLONKAI Gergely <[EMAIL PROTECTED]> wrote: keywords), I ask here: is it possible to run one database on multiple servers, so all the nodes would see the same data? what you're asking is replication, and i belive that if you do a simple search on "postgresql replication" it will r

Re: [ADMIN] Distributed database with PostgreSQL

2007-06-28 Thread POLONKAI Gergely
hubert depesz lubaczewski írta: > On 6/28/07, POLONKAI Gergely <[EMAIL PROTECTED]> wrote: >> >> keywords), I ask here: is it possible to run one database on multiple >> servers, so all the nodes would see the same data? >> > > what you're asking is replication, and i belive that if you do a simple

Re: [ADMIN] Distributed database with PostgreSQL

2007-06-28 Thread Adam Radlowski
Some ideas: With Slony one the one of these server You can install paralell a "central" database and "slave". They can work on two database clusters with running two PostgreSQL instances (on two different ports). Read the docs about dbmirror too (source tree - contrib/dbmirror). You can make Yo

Re: [ADMIN] Distributed database with PostgreSQL

2007-06-28 Thread hubert depesz lubaczewski
On 6/28/07, POLONKAI Gergely <[EMAIL PROTECTED]> wrote: hubert depesz lubaczewski írta: Actually, it is not replication we need, as all the nodes are equal, so there is no master server at all. I'm googling around now with these keywords tho, but I think this is not we need... if the nodes ar

[ADMIN] i need a rad/ide open source for work with postgresql

2007-06-28 Thread Mario Jose Canto Barea
why are you can make a good database relational server as postgresql 8.1, and dont make a rad/ide open source for programming with postgresql 8.1 as delphi\c++builder\progress 4gl ? thanks ___ Do Yo

Re: [ADMIN] i need a rad/ide open source for work with postgresql

2007-06-28 Thread Joshua D. Drake
Mario Jose Canto Barea wrote: why are you can make a good database relational server as postgresql 8.1, and dont make a rad/ide open source for programming with postgresql 8.1 as delphi\c++builder\progress 4gl ? Uhhh.. why not just use delphi, or c++builder with ODBC? Joshua D. Drake th

Re: [ADMIN] [GENERAL] i need a rad/ide open source for work with postgresql

2007-06-28 Thread Raymond O'Donnell
On 28/06/2007 18:47, Mario Jose Canto Barea wrote: why are you can make a good database relational server as postgresql 8.1, and dont make a rad/ide open source for programming with postgresql 8.1 as delphi\c++builder\progress 4gl ? Because they do different jobs. The languages you mention ar

[ADMIN] aborting startup due to startup process failure

2007-06-28 Thread George Wilk
I posted to this group before with the same topic but nobody replied. Please, provide some feedback if you can. I am running a warm standby server, which executes the following command in a recovery mode: triggered=false while (test ! -f /var/ipsc/WAL/$1 && ! $triggered) do echo waiting

Re: [ADMIN] aborting startup due to startup process failure

2007-06-28 Thread Kevin Grittner
>>> On Thu, Jun 28, 2007 at 2:55 PM, in message <[EMAIL PROTECTED]>, "George Wilk" <[EMAIL PROTECTED]> wrote: > > FATAL: could not restore file "0001003A" from archive: > return code 34048 > > LOG: startup process (PID 13994) exited with exit code 1 > > LOG: aborting startup

Re: [ADMIN] aborting startup due to startup process failure

2007-06-28 Thread Tom Arthurs
I think you may have a race condition in your code -- you don't find the new file, sleep, while sleeping both the new file and the stop file come in, you wake up, find the stop file and never copy the last segment over. George Wilk wrote: I posted to this group before with the same topic but

Re: [ADMIN] aborting startup due to startup process failure

2007-06-28 Thread Tom Lane
"George Wilk" <[EMAIL PROTECTED]> writes: > I am running a warm standby server, which executes the following command in > a recovery mode: > [ when done: ] > exit 133 Did you pick that number out of a hat? Postgres thinks it means that the recovery command died horribly, and abandons the recove