Re: [ADMIN] Replication

2005-09-19 Thread Scott Marlowe
On Mon, 2005-09-19 at 02:02, the vespadict wrote: > Hi , > > I want high Availability but I don't need load balance. I need sync > replication if is posible using two way. If you need sync, then pgpool may be a good choice, or client side replication like C-JDBC or something like that. pgpool do

Re: [ADMIN] PostgreSQL configuration problem

2005-09-19 Thread Thomas F. O'Connell
On Sep 19, 2005, at 8:31 AM, Gandeed Phanibhushan Rao-A18356 wrote: HI,   I have a 128MB RAM based Linux (Redhat 9.0) desktop. I have installed Postgres 8.0.3 server in my system, for my application usage.   A bit novice, so not much aware of the configuration of tuning the database.   My applicati

Re: [ADMIN] Backup issue

2005-09-19 Thread Scott Marlowe
On Sat, 2005-09-17 at 02:49, Marcin Giedz wrote: > Hello... > > This is what I have now: postgresql 8.0.1 - database weights about 60GB > and increases about 2GB per week. Nowadays I do backup every day - > according to simple procedure (pg_start_backup:rsync > data:pg_stop_backup:save wals pro

Re: [ADMIN] backend unexpected SIG KILL (9)

2005-09-19 Thread Scott Marlowe
On Mon, 2005-09-19 at 11:16, David Stanaway wrote: > Why would the backend get a KILL signal like this? It was doing a > routine select ... into , or a copy ... to at the time. > > > 2005-09-19 09:52:46 [1511] LOG: server process (PID 19446) was > terminated by signal 9 > 2005-09-19 09:52:46 [15

[ADMIN] backend unexpected SIG KILL (9)

2005-09-19 Thread David Stanaway
Why would the backend get a KILL signal like this? It was doing a routine select ... into , or a copy ... to at the time. 2005-09-19 09:52:46 [1511] LOG: server process (PID 19446) was terminated by signal 9 2005-09-19 09:52:46 [1511] LOG: terminating any other active server processes 2005-09-1

[ADMIN] PostgreSQL configuration problem

2005-09-19 Thread Gandeed Phanibhushan Rao-A18356
Title: Message HI,   I have a 128MB RAM based Linux (Redhat 9.0) desktop. I have installed Postgres 8.0.3 server in my system, for my application usage.   A bit novice, so not much aware of the configuration of tuning the database.   My application inserts the data into the database at the

Re: [ADMIN] Replication

2005-09-19 Thread the vespadict
Hi , I want high Availability but I don't need load balance. I need sync replication if is posible using two way. Thak you. 2005/9/16, Scott Marlowe <[EMAIL PROTECTED]>: > On Fri, 2005-09-16 at 03:35, vespadict wrote: > > Hello, > > > > I need to replicate two databases in diferents servers . I