Re: [ADMIN] postgresql stream replication question

2012-05-04 Thread sgm
Thank you sir. --- 12年5月3日,周四, Devrim GÜNDÜZ dev...@gunduz.org 写道: 发件人: Devrim GÜNDÜZ dev...@gunduz.org 主题: Re: [ADMIN] postgresql stream replication question 收件人: sgm sgm...@yahoo.com.cn 抄送: pgsql-admin@postgresql.org 日期: 2012年5月3日,周四,下午3:34 On Thu, 2012-05-03 at 13:47 +0800, sgm wrote: I

[ADMIN] postgresql stream replication question

2012-05-03 Thread sgm
Dear admin, I have successfully set up the stream replication M1--IP1, M2---IP2, my question is if the master is down, the slave will become read and write by trigger file, but the client will connect to the IP2,right? Thanks, Song

Re: [ADMIN] postgresql stream replication question

2012-05-03 Thread Devrim GÜNDÜZ
On Thu, 2012-05-03 at 13:47 +0800, sgm wrote: I have successfully set up the stream replication M1--IP1, M2---IP2, my question is if the master is down, the slave will become read and write by trigger file, but the client will connect to the IP2,right? No. You will need something else (like

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] 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

[ADMIN] Postgresql 8.4 replication using Londiste

2011-06-08 Thread Maria L. Wilson
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 anything in the docs that specify how to replicate

Re: [ADMIN] Postgresql 8.4 replication using Londiste

2011-06-08 Thread Craig James
On 6/8/11 12:39 PM, Maria L. Wilson wrote: 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 anything

Re: [ADMIN] postgresql and replication

2003-09-11 Thread Andrew Sullivan
On Wed, Sep 03, 2003 at 12:25:09PM +0200, [EMAIL PROTECTED] wrote: I am unable to find the adress to unsuscribe, could you please help me and give me that adress... thanks for advance!! http://gborg.postgresql.org/mailman/listinfo/erserver-general (Sorry, I've been buried lately and I'm

Re: [ADMIN] postgresql and replication

2003-09-03 Thread hugo_rousse
[EMAIL PROTECTED], Sujet: Re: [ADMIN] postgresql and replication On Tue, 2 Sep 2003, Somasekhar Bangalore wrote: Hi, My installation went through fine but while setting up the ers_setup ers_setup --masterserver=servername --masterdb=accounts \ --masteruser=someuser --masterpass=apasswd

Re: [ADMIN] postgresql and replication

2003-09-02 Thread Somasekhar Bangalore
: Wednesday, August 27, 2003 3:21 PM To: Andrew Sullivan Cc: [EMAIL PROTECTED] Subject: Re: [ADMIN] postgresql and replication Indeed, a free release of eRServer was released last night and is available at http://gborg.postgresql.org/project/erserver/download/download.php There was an announcement

Re: [ADMIN] postgresql and replication

2003-09-02 Thread Andrew Sullivan
On Tue, Sep 02, 2003 at 04:09:15PM +0530, Somasekhar Bangalore wrote: [javac] total = 556, [javac] name = /home/postgres/erserver/erserver_v1.2/java/lib/xerces.jar, [javac] i = 1, [javac] message = invalid LOC header (bad signature) The xerces file is corrupt. Justin Clift told me why --

Re: [ADMIN] postgresql and replication

2003-09-02 Thread Somasekhar Bangalore
: [ADMIN] postgresql and replication On Tue, Sep 02, 2003 at 04:09:15PM +0530, Somasekhar Bangalore wrote: [javac] total = 556, [javac] name = /home/postgres/erserver/erserver_v1.2/java/lib/xerces.jar, [javac] i = 1, [javac] message = invalid LOC header (bad signature) The xerces file

Re: [ADMIN] postgresql and replication

2003-09-02 Thread Marc G. Fournier
On Tue, 2 Sep 2003, Somasekhar Bangalore wrote: Hi, My installation went through fine but while setting up the ers_setup ers_setup --masterserver=servername --masterdb=accounts \ --masteruser=someuser --masterpass=apasswd \ --slaveserver=otherserver --slavedb=erp \

Re: [ADMIN] postgresql and replication

2003-08-28 Thread scott.marlowe
Look at User Mode Linux: http://user-mode-linux.sourceforge.net/ It'll let you run multiple linux instances on the same box. On Wed, 27 Aug 2003, Thierry Missimilly wrote: Hi, This is a good status. But i think you have forgotten DBMirror which is in the contrib directory. I have tried

Re: [ADMIN] postgresql and replication

2003-08-28 Thread Andrew Sullivan
On Tue, Aug 26, 2003 at 06:05:45PM -0400, Stephen Frost wrote: It appears to be up there now and you can puruse it using ViewCVS. The LICENSE file in erserver/docs certainly doesn't look like BSD (which is claimed on the main page) to me though. Oops, looks like something didn't get changed.

Re: [ADMIN] postgresql and replication

2003-08-28 Thread Chris Miles
Indeed, a free release of eRServer was released last night and is available at http://gborg.postgresql.org/project/erserver/download/download.php There was an announcement sent to pgsql-announce also. We will now be evaluating this to see if it is suitable for our needs. I spoke to PostgreSQL Inc

Re: [ADMIN] postgresql and replication

2003-08-28 Thread Stephen Frost
* Andrew Sullivan ([EMAIL PROTECTED]) wrote: On Tue, Aug 26, 2003 at 06:19:12PM +0100, Chris Miles wrote: eRServer http://www.erserver.com/ Commercial, looks professional. Not free. However, No trial or evaluation ? There's (about to be?) a free version available now. If you start

Re: [ADMIN] postgresql and replication

2003-08-27 Thread Thierry Missimilly
Hi, This is a good status. But i think you have forgotten DBMirror which is in the contrib directory. I have tried to run it on the same machine but on to 2 differents Postgres instances. The master on Port 5432 and the Slave on Port 5434. These does not work as the Perl script in charge of

[ADMIN] postgresql and replication

2003-08-26 Thread Chris Miles
Hi, we really want to get a reliable PostgreSQL replication setup going, with a Master Write server and many Slave Read-Only servers replicating off the master. This is to allow us to scale up our low-write/high-read application over many customers. We've done some research (ie, web searching)

Re: [ADMIN] postgresql and replication

2003-08-26 Thread Andrew Sullivan
On Tue, Aug 26, 2003 at 06:19:12PM +0100, Chris Miles wrote: eRServer http://www.erserver.com/ Commercial, looks professional. Not free. However, No trial or evaluation ? There's (about to be?) a free version available now. If you start grovelling around on gborg some time late this

[ADMIN] Postgresql, DB2, replication

2001-03-07 Thread pgsql-admin
Hello All! Somebody told me that DB2 has replication. Does PostgreSQL has it also? Anyway, does anybody here know the difference between PostgreSQL and DB2? Thanks. Sherwin ---(end of broadcast)--- TIP 2: you can get off all lists at once with