Re: [ADMIN] postgresql stream replication question
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 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 Red Hat Cluster Suite) for that. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
[ADMIN] postgresql stream replication question
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
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 Red Hat Cluster Suite) for that. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz signature.asc Description: This is a digitally signed message part
Re: [ADMIN] Postgresql 8.4 replication using Londiste
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 anything in the docs that specify how to replicate only one column - not the entire table. Anybody out there have any expertise in this that can point me in the right direction? That's supported in skytools3, currently in release candidate status. Those are the arguments you can give to the add table command: londiste ini provider add table --trigger-arg ... -- Optinal arguments: -- SKIP- The actual operation should be skipped (BEFORE trigger) -- ignore=col1[,col2] - don't look at the specified arguments -- pkey=col1[,col2]- Set pkey fields for the table, autodetection will be skipped -- backup - Put urlencoded contents of old row to ev_extra2 -- colname=EXPR- Override field value with SQL expression. Can reference table --columns. colname can be: ev_type, ev_data, ev_extra1 .. ev_extra4 -- when=EXPR - If EXPR returns false, don't insert event. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Postgresql 8.4 replication using Londiste
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 sure. And it stopped working somewhere in the 2.1 branch, I would guess by 2.1.9 from memory. Now the trigger notices when you ALTER TABLE and will queue events with the new columns by itself. Well, that might also depend on which trigger you use, but the default one is now smart enough. Skytools3 ahead! :) Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Postgresql 8.4 replication using Londiste
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 only one column - not the entire table. Anybody out there have any expertise in this that can point me in the right direction? thanks! Maria Wilson NASA/Langley Research Center Hampton, Virginia 23666 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Postgresql 8.4 replication using Londiste
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 in the docs that specify how to replicate only one column - not the entire table. Anybody out there have any expertise in this that can point me in the right direction? Londiste is a table-level replicator. You might be able to create one table with the column you want replicated (plus a primary key), another table with the rest of the columns, and a view to give your app the original view. Even so, you have to replicate the one column plus the PK, unless the data you're replicating is unique and can be its own PK. 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 sure. Craig -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] postgresql and replication
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 behind on my list responses.) A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] postgresql and replication
I am unable to find the adress to unsuscribe, could you please help me and give me that adress... thanks for advance!! Message d'origine Date: Tue, 2 Sep 2003 17:21:05 -0300 (ADT) De: Marc G. Fournier [EMAIL PROTECTED] A: Somasekhar Bangalore [EMAIL PROTECTED] Copie à: Andrew Sullivan [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 \ --slaveserver=otherserver --slavedb=erp \ --slaveuser=anotheruser --slavepass=foo I am getting below error Can't locate object method connect via package DBI (perhaps you forgot to load DBI?) at ./ers_setup line 73. I would be very thankful if any one can give the solution. do you have DBI installed? and DBD::Pg? Taking a look at the code, 'use DBI' is right at the top, so there should be no reason to get that error ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] postgresql and replication
Hi, I tried installing the erserver software . After running the make command. i am getting this error [javac] An exception has occurred in the compiler (1.4.1_02). Please file a bug at the Java Developer Connection (http://java.sun.com/cgi-bin/bugreport.cgi) after checking the Bug Parade for duplicates. Include your program and the following diagnostic in your report. Thank you. [javac] java.lang.InternalError: jzentry == 0, [javac] jzfile = 136119320, [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) BUILD FAILED /home/postgres/erserver/erserver_v1.2/java/build.xml:146: Compile failed, messages should have been provided. I appreciate if some one can help me how to install configure erserver. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: [EMAIL PROTECTED] Weaving the knowledge tapestry' -Original Message- From: Chris Miles [mailto:[EMAIL PROTECTED] Sent: 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 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 last night and was informed that they will be releasing their previous versions of eRServer to the open source community 6-12 months after it has been replaced by the next commercial version. The commercial version is still sold, supported and developed, and is currently at version 1.3. The open source version just released is a modified version of 1.2 basically. Cheers, Chris. Andrew Sullivan 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 grovelling around on gborg some time late this afternoon (uh, EDT), I think you'll stumble on it. -- Chris Miles http://chrismiles.info/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [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 is corrupt. Justin Clift told me why -- I just need to fix it. You can get the xerces jar file independently for the time being if need be. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [ADMIN] postgresql and replication
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 \ --slaveuser=anotheruser --slavepass=foo I am getting below error Can't locate object method connect via package DBI (perhaps you forgot to load DBI?) at ./ers_setup line 73. I would be very thankful if any one can give the solution. Regards, Somasekhar Bangalore Principal Software Engineer ZenSutra Software Technologies Pvt. Ltd. Suite 601, HM Geneva House #14, Cunningham Road Bangalore 560-052, India Ph:+91-80-235-0481 Fax:+91-80-235-0486 Email: [EMAIL PROTECTED] Weaving the knowledge tapestry' -Original Message- From: Andrew Sullivan [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 4:53 PM To: [EMAIL PROTECTED] Subject: Re: [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 is corrupt. Justin Clift told me why -- I just need to fix it. You can get the xerces jar file independently for the time being if need be. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
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 \ --slaveserver=otherserver --slavedb=erp \ --slaveuser=anotheruser --slavepass=foo I am getting below error Can't locate object method connect via package DBI (perhaps you forgot to load DBI?) at ./ers_setup line 73. I would be very thankful if any one can give the solution. do you have DBI installed? and DBD::Pg? Taking a look at the code, 'use DBI' is right at the top, so there should be no reason to get that error ... ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] postgresql and replication
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 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 synchronized the Master DB and the Slave DB, work only on the default port 5432. I'm waiting for an other machine to create the Slave DB on a different machine. Thierry Missimilly Chris Miles wrote: 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) and we are not convinced that PostgreSQL replication projects are production ready (with one commercial exception). Hopefully we are wrong however, as the MySQL built-in replication does seem very mature and makes me look across with envy. But considering all the effort we've put into our PG installation, we'd rather stick to PG if possible. I will briefly list the PG Replication projects I have come across below. I am looking for more experienced people, who have hopefully already implemented any of these, or the authors themselves, to provide more details and guide us in the right direction as to which project is the best to go with. I am happy to summarize the info we put together for others looking to do the same. eRServer http://www.erserver.com/ Commercial, looks professional. Not free. However, No trial or evaluation ? PGReplication http://gborg.postgresql.org/project/pgreplication/projdisplay.php Software is: Postgres-R with Spread. Free. Looks to be still very much in development, can only consider beta ? RServ http://gborg.postgresql.org/project/rservimp/projdisplay.php Looks far too beta Free PostgreSQL Replicator http://pgreplicator.sourceforge.net/ Store and forward asynchronous data replication. Free Tested up to PG 7.1 Peer-to-peer (single master/slave pair) not multi-slave. Usogres http://usogres.good-day.net/ Very simple and not real-time replication. Free. Just duplication and only one master/slave pair. Regards, Chris. -- Chris Miles http://chrismiles.info/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] postgresql and replication
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. We can fix that. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
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 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 last night and was informed that they will be releasing their previous versions of eRServer to the open source community 6-12 months after it has been replaced by the next commercial version. The commercial version is still sold, supported and developed, and is currently at version 1.3. The open source version just released is a modified version of 1.2 basically. Cheers, Chris. Andrew Sullivan 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 grovelling around on gborg some time late this afternoon (uh, EDT), I think you'll stumble on it. -- Chris Miles http://chrismiles.info/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
Re: [ADMIN] postgresql and replication
* 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 grovelling around on gborg some time late this afternoon (uh, EDT), I think you'll stumble on it. 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. Stephen pgp0.pgp Description: PGP signature
Re: [ADMIN] postgresql and replication
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 synchronized the Master DB and the Slave DB, work only on the default port 5432. I'm waiting for an other machine to create the Slave DB on a different machine. Thierry Missimilly Chris Miles wrote: 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) and we are not convinced that PostgreSQL replication projects are production ready (with one commercial exception). Hopefully we are wrong however, as the MySQL built-in replication does seem very mature and makes me look across with envy. But considering all the effort we've put into our PG installation, we'd rather stick to PG if possible. I will briefly list the PG Replication projects I have come across below. I am looking for more experienced people, who have hopefully already implemented any of these, or the authors themselves, to provide more details and guide us in the right direction as to which project is the best to go with. I am happy to summarize the info we put together for others looking to do the same. eRServer http://www.erserver.com/ Commercial, looks professional. Not free. However, No trial or evaluation ? PGReplication http://gborg.postgresql.org/project/pgreplication/projdisplay.php Software is: Postgres-R with Spread. Free. Looks to be still very much in development, can only consider beta ? RServ http://gborg.postgresql.org/project/rservimp/projdisplay.php Looks far too beta Free PostgreSQL Replicator http://pgreplicator.sourceforge.net/ Store and forward asynchronous data replication. Free Tested up to PG 7.1 Peer-to-peer (single master/slave pair) not multi-slave. Usogres http://usogres.good-day.net/ Very simple and not real-time replication. Free. Just duplication and only one master/slave pair. Regards, Chris. -- Chris Miles http://chrismiles.info/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) begin:vcard n:Missimilly;Thierry tel;fax:+33 (0)4 76 29 78 78 tel;work:+33 (0)4 76 29 74 54 x-mozilla-html:FALSE url:http:\\www.bull.com org:BIS/RD adr:;;Bull SA, 1, rue de provence - BP 208;ECHIROLLES;;38432;FRANCE version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;-18184 fn:Thierry Missimilly end:vcard ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[ADMIN] postgresql and replication
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) and we are not convinced that PostgreSQL replication projects are production ready (with one commercial exception). Hopefully we are wrong however, as the MySQL built-in replication does seem very mature and makes me look across with envy. But considering all the effort we've put into our PG installation, we'd rather stick to PG if possible. I will briefly list the PG Replication projects I have come across below. I am looking for more experienced people, who have hopefully already implemented any of these, or the authors themselves, to provide more details and guide us in the right direction as to which project is the best to go with. I am happy to summarize the info we put together for others looking to do the same. eRServer http://www.erserver.com/ Commercial, looks professional. Not free. However, No trial or evaluation ? PGReplication http://gborg.postgresql.org/project/pgreplication/projdisplay.php Software is: Postgres-R with Spread. Free. Looks to be still very much in development, can only consider beta ? RServ http://gborg.postgresql.org/project/rservimp/projdisplay.php Looks far too beta Free PostgreSQL Replicator http://pgreplicator.sourceforge.net/ Store and forward asynchronous data replication. Free Tested up to PG 7.1 Peer-to-peer (single master/slave pair) not multi-slave. Usogres http://usogres.good-day.net/ Very simple and not real-time replication. Free. Just duplication and only one master/slave pair. Regards, Chris. -- Chris Miles http://chrismiles.info/ ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
Re: [ADMIN] postgresql and replication
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 afternoon (uh, EDT), I think you'll stumble on it. A -- Andrew Sullivan 204-4141 Yonge Street Liberty RMS Toronto, Ontario Canada [EMAIL PROTECTED] M2P 2A8 +1 416 646 3304 x110 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
[ADMIN] Postgresql, DB2, replication
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 the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])