Re: [ADMIN] replication?

On Mon, Nov 13, 2006 at 10:21:40PM +0100, TomDB wrote: > > I'd like to create a setup where there are exactly 2 masters which > need to be synchronized against each other. The two masters should > have read+write access, but don't have a permanent connection to each > other. One will be on a LAN-s

Re: [ADMIN] replication?

hmm - I was hoping to have it in a database supported by PHP, preferably freely available. MySQL would be OK too, but I didn't find it there either. Strange, cause to my knowledge 'even' MS Access offers it - I used it before in the Access 97 version. And Access it not what I'd call a decent data

Re: [ADMIN] replication?

would there be any default available field (like the OID of the records) that would be unique in the two versions of the datbase? there isn't "by accident" something like a unique UID like an MD5 or something... ? cause if there is no replication available, I'd consider this (together with PHP)

Re: [ADMIN] replication?

Why not just have a primary key with 2 columns, one of which is a serial and the other is a "siteid" or "installid" that is different for each server? TomDB wrote: would there be any default available field (like the OID of the records) that would be unique in the two versions of the datbas

Re: [ADMIN] Replication

Did you try Slony with PostgreSQL? -- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 1/4/07, anorganic anorganic <[EMAIL PROTECTED]> wrote: Hello, i need make with postgre something as this: i have two servers S1 and S2, connection is quit good, but sometimes once or twice pe

Re: [ADMIN] Replication

Hi, did you check the manual about 'High Availability and Load Balancing"? http://www.postgresql.org/docs/8.2/static/high-availability.html Regards Markus ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Replication

Hi, anorganic anorganic wrote: >> did you check the manual about 'High Availability and Load >> Balancing"? >> http://www.postgresql.org/docs/8.2/static/high-availability.html > yes but this was really short i think. Interesting... where exactly is it to short for you? What else would you exp

Re: [ADMIN] Replication

Hi, [ please keep CCing to the list (reply all), as this certainly isn't a personal discussion and could help others. ] anorganic anorganic wrote: Hello, "I don't quite follow what you mean here. I assume you mean rows, not columns. Then probably you mean something like what we call data par

Re: [ADMIN] Replication

Hi, [ please keep CCing to the list (reply all), as this certainly isn't a personal discussion and could help others. ] anorganic anorganic wrote: my opinion: partitioning is vertical and horizontal, dived table into two or more parts. > replicated only part of some object,here table = rep

RE: [ADMIN] replication

Hi! On 26-Aug-99 Safa Pilavcý wrote: > Hello, > Is it possible to do replication through postgresql on Solaris 2.6..? > Can you show me any adress that tells replication on postrgres..? Hmmm.. And I'm interestind in postgres-topostgres replication program. Which replicate database from one host

Re: [ADMIN] replication

On Tue, 30 Nov 1999, F. Roettger wrote: > dear developers, > > I've seen the replication skill on the todo-list. when will this be > released? when someone decides to take it on as a project :) Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator

Re: [ADMIN] replication

You may look at this site: http://www.greatbridge.org/project/pgreplication/projdisplay.php Egon Srinivasa Rao Chava wrote: > Hai Friends, > Does postgresql supports replication? > Say, we want to install to servers , having the same databases. One of > them will work as standby database. For

Re: [ADMIN] replication

Peter T. Brown writes: > > I want to add replication capabilities to my postgresql installation. Can > anyone recommend a good way (open source or otherwise) to do so? > [snip] Check the contrib/rserv/ directory in the PostgreSQL source. Also check http://techdocs.postgresql.org/oresources.php#

Re: [ADMIN] replication

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Friday, January 11, 2002, at 09:27 AM, Peter T. Brown wrote: > Hello > > I want to add replication capabilities to my postgresql installation. > Can > anyone recommend a good way (open source or otherwise) to do so? I read this the other day,

Re: [ADMIN] replication

The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote: > Hello > > I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one > is a failover. I would like to implement a master-slave replication > process. > > I believe replication has been included in the base package since 7.3

Re: [ADMIN] replication

Christopher Browne wrote: The world rejoiced as [EMAIL PROTECTED] (Fred Blaise) wrote: Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base packa

Re: [ADMIN] replication

Fred Blaise wrote: Hello I am running postgres 7.4.6 on 2 BSDi boxes. One is live, the other one is a failover. I would like to implement a master-slave replication process. I believe replication has been included in the base package since 7.3.x. Hello, There are two major replication options for P

Re: [ADMIN] Replication

Am Freitag, 5. August 2005 14:32 schrieb Marco Rademeyer: > Can PostgreSQL do replication ? Yes. > If possible could guide me in the right direction. http://www.google.com/search?q=postgresql+replication -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(

Re: [ADMIN] Replication

On Fri, 5 Aug 2005, Marco Rademeyer wrote: Can PostgreSQL do replication ? Marco, This would probably be a good one to search for in the archives before asking, but Slony http://slony.info/ is probably the most popular replication engine for postgresql and command prompt has Mammoth Replica

Re: [ADMIN] Replication

Jan Waiz wrote: Hi Folks, is it possible to make a Replication between several PostgresSQL-Databases ? Short answer: Yes (for most cases). Long answer will depend on what your requirements are. What do you have in mind? Best Wishes, Chris Travers Metatron Technology Consulting

Re: [ADMIN] replication

On Fri, Sep 02, 2005 at 04:11:35PM -0400, Alain Rodriguez Arias wrote: > Please,anybody can tell me how to make replication of a PostGre DB Did you already look at Slony-I, www.slony.info ? -- Alvaro Herrera -- Valdivia, Chile Architect, www.EnterpriseDB.com "I think my standards hav

Re: [ADMIN] replication

[EMAIL PROTECTED] (Alain Rodriguez Arias) writes: > Please,anybody can tell me how to make replication of a PostGre DB What do you mean by "replication?" - If what you desire is to create a copy, then you can take a backup and restore it somewhere else. Read The Fine Manual if that fits

Re: [ADMIN] Replication

On Fri, 2005-09-16 at 03:35, vespadict wrote: > Hello, > > I need to replicate two databases in diferents servers . I'm reading > about some projects but i'm not sure what is the best option. I found > interesting dbmirror and pgcluster but I have doubts . Please , May you > help me ? . Do you

Re: [ADMIN] Replication

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

Re: [ADMIN] Replication

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

There's also pgcluster, but keep in mind that these are all statement-level replication solutions which have some rather big gotchas. On Mon, Sep 19, 2005 at 03:24:31PM -0500, Scott Marlowe wrote: > On Mon, 2005-09-19 at 02:02, the vespadict wrote: > > Hi , > > > > I want high Availability but I

Re: [ADMIN] Replication

Are there any non-statement level solution? Something that appends to the WAL on the slave server? On Tuesday 20 September 2005 12:28 pm, Jim C. Nasby wrote: > There's also pgcluster, but keep in mind that these are all > statement-level replication solutions which have some rather big > gotch

Re: [ADMIN] Replication

>Are there any non-statement level solution? Something that appends to the WAL >> on the slave server? For this kind of solution I'm also looking for a while - but in the meantime you can also take a look at "slony" - it can do really many things. Don't give up at the beginning, after you've u

Re: [ADMIN] Replication

On Thu, Jan 23, 2003 at 11:38:25AM +0100, Enrico Ortmann wrote: > > Hi folks, > > Does anyone know a solution for replicating a PG7.2 Database. We'd > prefer a bidirectional replication but it doesn't have to be that > way. A simple one-way-rep would match our basic interests as well. > The docum

Re: [ADMIN] Replication

"Andrew Sullivan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > We are currently using eRServer for the .info registry, and starting > next week it will also underpin the .org registry. Dunno if that's > good enough performance for you. It works for us. t

Re: [ADMIN] Replication

On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: > > the eRServer is for free or not ? "Not", as far as I know. Its baby cousin is in contrib/rserv in the source tree. I haven't tested it with 7.3, so I don't know whether it works. A -- Andrew Sullivan

Re: [ADMIN] Replication

On Mon, 27 Jan 2003, Andrew Sullivan wrote: > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: > > > > the eRServer is for free or not ? > > "Not", as far as I know. Its baby cousin is in contrib/rserv in the > source tree. I haven't tested it with 7.3, so I don't know whether >

Re: [ADMIN] Replication

I would give /contrib/dbmirror a try. --- Marc G. Fournier wrote: > On Mon, 27 Jan 2003, Andrew Sullivan wrote: > > > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: > > > > > > the eRServer is for free or

Re: [ADMIN] Replication

On Mon, 2003-01-27 at 21:10, Marc G. Fournier wrote: > On Mon, 27 Jan 2003, Andrew Sullivan wrote: > > > On Mon, Jan 27, 2003 at 07:38:29PM +0100, Gaetano Mendola wrote: > > > > > > the eRServer is for free or not ? > > > > "Not", as far as I know. Its baby cousin is in contrib/rserv in the > > s

Re: [ADMIN] Replication

On Tue, 28 Jan 2003, Will LaShell wrote: > Hrmm, this is kind of sad. rserv actually does work pretty well. We use > it in a production environment here at OFS on a medium size database > cluster. I think you are the first person taht I've seen that has admit'd to using it ... other then a few 'b

Re: [ADMIN] Replication

Hi folks! Is anybody using pgReplicator? I've read through the documentation but haven't tried it yet. I'm looking for a solution that can offer asynchronous, update-anywhere replication. Conflict resolution is not an issue. It seems that pgReplicator would

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 12:42, Fabian Peters wrote: > Hi folks! > > Is anybody using pgReplicator? > > I've read through the documentation but haven't tried it yet. I'm looking > for a solution that can offer asynchronous, update-anywhere replication. > Confli

Re: [ADMIN] Replication

On Tue, 28 Jan 2003, Will LaShell wrote: > > The biggest one I've heard: documentation sucks > > This truely is an issue, the documentation can be painful, however in > reality there is very little to do with it. Run the master / slave setup > add the tables, and run the replicate. I think perha

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 14:12, Andrew Sullivan wrote: > On Tue, Jan 28, 2003 at 09:59:52AM -0700, Will LaShell wrote: > > What problems have people been having getting rserv to work at all? > > In 2001 I tested it for our anticipated load. It worked for me, but > it was not up to the kind of load t

Re: [ADMIN] Replication

On Tue, 2003-01-28 at 11:01, Marc G. Fournier wrote: > On Tue, 28 Jan 2003, Will LaShell wrote: > > > Hrmm, this is kind of sad. rserv actually does work pretty well. We use > > it in a production environment here at OFS on a medium size database > > cluster. > > I think you are the first person

Re: [ADMIN] Replication

> Is anyone out there using this feature currently? If so , which package > & OS environment. > the latest news was eRServer v1.0. Is this the same as the v1.2 that > Postgres INC announced early this year ? yes, exactly the same source tree ... > Is there a master-master capability or only m

Re: [ADMIN] Replication

Martha Stewart called it a Good Thing [EMAIL PROTECTED] ("Ian Huynh")wrote: > Seems that there are a number of simultaneous project in trying to implement > replication > for postgres. > > Is anyone out there using this feature currently? If so , which package & OS > environment. > > the late

Re: [ADMIN] Replication

. -Original Message- From: Christopher Browne [mailto:[EMAIL PROTECTED] Sent: Sat 8/30/2003 4:47 PM To: [EMAIL PROTECTED] Cc: Subject: Re: [ADMIN] Replication Martha Stewart called it a Good Thing [EMAIL

Re: [ADMIN] Replication

On Sun, Aug 31, 2003 at 08:33:33PM -0700, Ian Huynh wrote: > There are certain cases where multi-master rep are very > implementable such as where the datasets being rep are fairly > disjointed but need to be replicated for completeness in terms of > reporting. But you are absolutely 110% correct.

Re: [ADMIN] Replication

Rodrigo, Rodrigo Botana wrote: There is any way to have a replication (master -> slave) whithout install anything on the slave computer. I ask this because i would like to have my website (that don't have any replication service avaliable) with the same information of my internal system. In the

Re: [ADMIN] Replication

The world rejoiced as [EMAIL PROTECTED] ("Rodrigo Botana") wrote: > There is any way to have a replication (master -> slave) whithout > install anything on the slave computer. I ask this because i would > like to have my website (that don't have any replication service > avaliable) with the same in

Re: [ADMIN] Replication, HA ...?

Check out cybercluster at http://www.postgresql.at/ It's free, however the support can cost a bit. But the software itself is free, and it's built on postgresql8.2. On Mon, 16 Jun 2008 09:46:57 +0200 Andreas Kraftl <[EMAIL PROTECTED]> wrote: > Hello, > > I have a webserver with postgresql. I wo

Re: [ADMIN] Replication, HA ...?

gt; CC: pgsql-admin@postgresql.org> Subject: Re: [ADMIN] Replication, > HA ...?> > Check out cybercluster at http://www.postgresql.at/> It's free, > however the support can cost a bit. But the software itself is free,> and > it's built on postgresql8.2.> > On

Re: [ADMIN] Replication, HA ...?

> I have a webserver with postgresql. I would have a backup from this > database. It should also be possible to query this backup solution. > So I think slony would be a good choice. Am I right? Slony will replicate the data from selected tables for you, and the replicated database will be availab

Re: [ADMIN] Replication Options.

[EMAIL PROTECTED] (Pallav Kalva) writes: > I need to implement the following the replication scenario in > postgres database. Here are the details of what we are looking to > implement. > > Lets say I have 2 nodes Node1(US) and Node2(Canada), > > Node1: tableA , tableB > Node2: tableB , tableA

Re: [ADMIN] Replication Options.

Chris Browne wrote: [EMAIL PROTECTED] (Pallav Kalva) writes: I need to implement the following the replication scenario in postgres database. Here are the details of what we are looking to implement. Lets say I have 2 nodes Node1(US) and Node2(Canada), Node1: tableA , tableB Node2: tableB , t

Re: [ADMIN] replication/redundancy

On Fri, Jun 27, 2003 at 08:05:02PM -0400, Dave [Hawk-Systems] wrote: > some searches on this have produced mixed results... > > do we have a stable means to replicate transactions between two physical > servers, preferrably in master - master configuration where updates/inserts can > be done on ei

Re: [ADMIN] replication/redundancy

[EMAIL PROTECTED] wrote: On Fri, Jun 27, 2003 at 08:05:02PM -0400, Dave [Hawk-Systems] wrote: some searches on this have produced mixed results... do we have a stable means to replicate transactions between two physical servers, preferrably in master - master configuration where updates/inse

Re: [ADMIN] replication/redundancy

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Sunday 29 June 2003 01:28, Toni Schlichting wrote: > [EMAIL PROTECTED] wrote: > It seems pgreplication will be the tool you are looking. it is under way > but it is > not here yet. It looks as if pgreplication will do much more than just > enabling

Re: [ADMIN] replication/redundancy

On Mon, Jun 30, 2003 at 08:31:09AM -0700, Jonathan Gardner wrote: > The really cool thing about pgreplication will be that it is > hot-swappable. If one of the servers goes down, the whole thing will > still work. You can also add databases to the system on-the-fly. > That way, you can always

Re: [ADMIN] replication/redundancy

On Tue, Jul 01, 2003 at 08:22:37AM -0700, Jonathan Gardner wrote: > So you are using "lazy" rather than "eager" replication. correct. > 1) The data is not consistent. This means if you run the same select query > at the same time on the two databases, you may get different results. For > so

Re: [ADMIN] replication/redundancy

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 30 June 2003 09:17, [EMAIL PROTECTED] wrote: > On Mon, Jun 30, 2003 at 08:31:09AM -0700, Jonathan Gardner wrote: > > * currently only an explicit sync-out is supported - from time to time > evry table has to be scanned for new records So y

Re: [ADMIN] replication/mirror

darshan patel wrote: I had install postgresql server on two different port : default(5432) and other(5545), now I have to setup replication/mirror between them So what are the steps/setup procedure. Hello Darshan! I'm not sure you realise this, but it's common sense (not to mention polite) to u

Re: [ADMIN] Replication solution

Palaniappan Thiyagarajan wrote: > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? > > Anybody has good step by step doc for warm standby setup? > > Any other suggestion to achieve replication is appreciated. You might wan

Re: [ADMIN] Replication solution

check this http://symmetricds.codehaus.org/ I just began playing with that one > Date: Thu, 19 Nov 2009 12:39:04 -0600 > From: kevin.gritt...@wicourts.gov > To: pthiyagara...@cashedge.com; pgsql-admin@postgresql.org > Subject: Re: [ADMIN] Replication solution > > Palani

Re: [ADMIN] Replication solution

edge.com; pgsql-admin@postgresql.org > > Subject: Re: [ADMIN] Replication solution > > > > Palaniappan Thiyagarajan wrote: > > > > > I am looking for Postgres replication solution for 8.3.x DB. https://projects.commandprompt.com/public/replicator http://www.slo

Re: [ADMIN] Replication solution

On Thu, 2009-11-19 at 18:25 +, Palaniappan Thiyagarajan wrote: > > I am looking for Postgres replication solution for 8.3.x DB. > > Any open source software available for replication? http://wiki.postgresql.org/wiki/Replication%2C_Clustering% 2C_and_Connection_Pooling > Anybody has good st

Re: [ADMIN] Replication solution

Thanks for the information. From: Julio Leyva [mailto:jcle...@hotmail.com] Sent: Thursday, November 19, 2009 10:53 AM To: kevin.gritt...@wicourts.gov; Palaniappan Thiyagarajan; pgsql-admin@postgresql.org Subject: RE: [ADMIN] Replication solution check this http://symmetricds.codehaus.org/ I

Re: [ADMIN] Replication solution

"Joshua D. Drake" writes: > http://pgfoundry.org/projects/skytools/ See also: http://wiki.postgresql.org/wiki/Londiste_Tutorial Regards, -- dim -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admi

Re: [ADMIN] Replication solution

We are currently using Slony for our client's database that has million of rows on some tables and 12GB of raw data. So far so good, we set it up as a service and using a watchdog script to monitor and notify us in case the service fails. On Fri, Nov 27, 2009 at 12:19 AM, Dimitri Fontaine wrote:

Re: [ADMIN] Replication solution

As much of a pain as slony can be to setup and get working on a large data set, it is pretty solid and reliable for us too. Our DB is about 100G or so. On Sun, Nov 29, 2009 at 9:09 PM, Mark Guadalupe wrote: > We are currently using Slony for our client's database that has million of > rows on so

Re: [ADMIN] replication recommendation

-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 > We are running PG 8.4.4 on Suse 9 and would like to set up a > master/slave configuration but have the following requirements: > - we want to be able to freeze the slave and only force it to update 'on > demand' > - we have data in other sch

Re: [ADMIN] replication solution

Silvio Brandani wrote: > we already have the Point In Time Recovery but we need a solution > where the standby is always open in readonly , but the data is > replicated continuosly from primary. What's your time frame? The Hot Standby and Streaming Replication features in PostgreSQL 9.0 wi

Re: [ADMIN] replication solution

Hi, 24.Ağu.2010 tarihinde 16:46 saatinde, Silvio Brandani t> şunları yazdı: The Slony solution could be a possibility but the production database is 80 Gb of data with around 1 transaction each hour. We do at least 15x more transactions with Slony, w/o any issues. Slony should be goo

Re: [ADMIN] replication solution

On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: > Hi all, > > we are looking for a solution to create a replicated database to be used > as reporting database with same data of production ( we can accept a lag > of some minutes). > > we already have the Point In Time Recovery but we n

Re: [ADMIN] replication solution

On Tue, Aug 24, 2010 at 10:38 AM, Joshua D. Drake wrote: > On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: >> The Slony solution could be a possibility but the production database is >> 80 Gb of data with  around 1 transaction each hour. > Slony (or Londiste) can handle that withou

Re: [ADMIN] replication solution

On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: > Hi all, > > we are looking for a solution to create a replicated database to be used > as reporting database with same data of production ( we can accept a lag > of some minutes). > > we already have the Point In Time Recovery but we n

Re: [ADMIN] replication solution

I've heard that rubyrep (http://www.rubyrep.org) is a good tool for replication too. I think it has gained popularity because of its ease of use. On a similar note I am eager to try postgreSQl 9.0 bulit in hot standby solution.I can't really wait till Postgersql rolls out replicated solution

Re: [ADMIN] replication solution

Simon Riggs ha scritto: On Tue, 2010-08-24 at 15:46 +0200, Silvio Brandani wrote: Hi all, we are looking for a solution to create a replicated database to be used as reporting database with same data of production ( we can accept a lag of some minutes). we already have the Point In Time

Re: [ADMIN] replication in 7.1

http://pgreplicator.sourceforge.net/ Haven't used it. Don't know. cheers, thalis On Wed, 20 Jun 2001, Matt Doughty wrote: > Is there anyeay to replicate servers using postgres 7.1.1? I can't find > Rserv or anything like it in the contrib tree. > > TIA, > > Matt > >

Re: [ADMIN] Replication with PostgreSQL

After a long battle with technology, [EMAIL PROTECTED] (prakash sompura), an earthling, wrote: > Can any one tell me how do I replicate my PostgreSql database from > one server to another server? One method involves using pg_dump to dump the state out, and load it onto the other server. Certainl

Re: [ADMIN] Replication with PostgreSQL

On Sun, 2005-03-20 at 22:33 -0500, Christopher Browne wrote: > After a long battle with technology, [EMAIL PROTECTED] (prakash sompura), an > earthling, wrote: > > Can any one tell me how do I replicate my PostgreSql database from > > one server to another server? You can use Mammoth Replicator o

Re: [ADMIN] Replication, High availability

On Sun, Sep 29, 2002 at 12:06:40PM +0200, Wojciech Bernacki wrote: > goal? Is Postgresql-R 7.2 already worth trying? Has anyone used No. It's only just been made to work this summer, and the patches haven't been merged with the main PsotgreSQL code. If reliability is what you want, don't use b

Re: [ADMIN] Replication, High availability

Hi I dont' think there are very stable neat solutions as yet for replication in potgresql. In your case usogres may be a good solution. but check its sorthcomnis also regds Mallah. > > My online app uses PostgreSQL 7.2 running on a single Debian box. I also have > a spare machine witch

Re: [ADMIN] Replication, High availability

Hi, check this link: http://usogres.good-day.net/ C. Wojciech Bernacki wrote: > My online app uses PostgreSQL 7.2 running on a single Debian box. I also have > a spare machine witch may act as a backup server. After even hardware > breakdowns the whole system must be up and running in no

Re: [ADMIN] Replication/Mirror Help

In the last exciting episode, [EMAIL PROTECTED] ("Mr. Darshan Patel") wrote: > I had install postgresql server on two different port : default(5432) and > other(5545), now I have to setup replication/mirror between them So what are > the steps/setup procedure. That presumably depends on which r

Re: [ADMIN] Replication for migration

On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: > Hi list! > > I've to do a migration of postgresql from version 8.2 to 8.3 in one > server. The problem I see here is, to avoid data loss (people still > using the web site that uses postgres), I'll need to stop postgres 8.2, > make

Re: [ADMIN] Replication for migration

On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote: > On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: > > Hi list! > > [snip] > > > > I'd love to read some experiences or advices, since I haven't done it > > before. Also if you have some link o document that you think I mu

Re: [ADMIN] Replication for migration

Hi, Martin Spinassi writes: > On Thu, 2009-05-14 at 08:59 -0500, Kenneth Marshall wrote: >> I used Slony replication to upgrade a database from 8.2 -> 8.3 and >> it worked quite well. You will need an outage to change the master >> to the 8.3 database and re-point your apps, but if scripted, tha

Re: [ADMIN] Replication for migration

On Thu, May 14, 2009 at 7:59 AM, Kenneth Marshall wrote: > On Thu, May 14, 2009 at 10:57:26AM -0300, Martin Spinassi wrote: >> Hi list! >> >> I've to do a migration of postgresql from version 8.2 to 8.3 in one >> server. The problem I see here is, to avoid data loss (people still >> using the web

Re: [ADMIN] Replication by schema

On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch wrote: > Hi there, > > what options do exist to replicate from a master by schema? > > What I'm really after is this scenario: > > Say, I have 100 databases out in the field. All of them have the same schema > and are autonomous masters. Now, at a cent

Re: [ADMIN] Replication by schema

On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe wrote: > On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch wrote: >> Hi there, >> >> what options do exist to replicate from a master by schema? >> >> What I'm really after is this scenario: >> >> Say, I have 100 databases out in the field. All of them h

Re: [ADMIN] Replication monitoring questions

On Jan 17, 2013, at 11:20 AM, Scott Whitney wrote: > What I want to know is whether there's a situation in which my standby is > running, the receiver process is running, but "something" is wrong. I compare pg_controldata output from the two clusters periodically.

Re: [ADMIN] Replication Multi Master Asyncronous

On Tue, 2007-04-24 at 00:35 -0700, Muhammad Isnaini wrote: > Hi.. > I success develop a Replication Multi Master Async through PHP. > Just few step to make replication with php, but I want to make this > replication can embedded into PostgreSQL. > > This step by step . > Make every record unique i

Re: [ADMIN] replication using WAL archives

On Thu, 2004-10-21 at 02:44, Iain wrote: > Hi, > > I thought I read something about this in relation to v8, but I can't > find any reference to it now... is it (or will it be) possible to do > master-slave style database replication by transmitting log files to the > standby server and having it

Re: [ADMIN] replication using WAL archives

Robert Treat wrote: On Thu, 2004-10-21 at 02:44, Iain wrote: Hi, I thought I read something about this in relation to v8, but I can't find any reference to it now... is it (or will it be) possible to do master-slave style database replication by transmitting log files to the standby server and havi

Re: [ADMIN] replication using WAL archives

ptions and keep an eye on it's progress. regards Iain - Original Message - From: "Gaetano Mendola" <[EMAIL PROTECTED]> To: "Robert Treat" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, October 22, 2004

Re: [ADMIN] replication using WAL archives

> Gaetano Mendola wrote > Postgres can help this process, as suggested by Tom creating a pg_current_wal() > or even better having two new GUC parameters: archive_current_wal_command and > archive_current_wal_delay. OK, we can modify the archiver to do this as well as the archive-when-full function

Re: [ADMIN] replication using WAL archives

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Simon Riggs wrote: |>Gaetano Mendola wrote |>Postgres can help this process, as suggested by Tom creating a | | pg_current_wal() | |>or even better having two new GUC parameters: archive_current_wal_command | | and | |>archive_current_wal_delay. | | | O

Re: [ADMIN] replication using WAL archives

On Fri, 2004-10-22 at 17:44, Gaetano Mendola wrote: > | Gaetano - skim-reading your script, how do you handle the situation when a > | new xlog file has been written within 10 seconds? That way the current file > | number will have jumped by 2, so when your script looks for the "Last wal" > | using

Re: [ADMIN] replication using WAL archives

Simon Riggs wrote: > Situation I thought I saw was: > > - copy away current partial filled xlog N > - xlog N fills, N+1 starts > - xlog N+1 fills, N+2 starts > - copy away current partial filled xlog: N+2 (+10 secs later) > > i.e. if time to fill xlog (is ever) < time to copy away current xlog, > t

Re: [ADMIN] replication using WAL archives

This thread has been added as a link on the TODO list under TODO.detail. --- Gaetano Mendola wrote: > Robert Treat wrote: > > On Thu, 2004-10-21 at 02:44, Iain wrote: > > > >>Hi, > >> > >>I thought I read something about t

Re: [ADMIN] replication for hot-standby?

Hi, maybe filesystem-snapshots with wal's are your solution. There is a block-device replication-tool too. It's called drbd (http://www.drbd.org). I never tested/used it, but i heard it should be fine. I'm using rsync/xfs_freeze to make incremental filesystem-snapshots (incremental by hardlinks)

Re: [ADMIN] replication for hot-standby?

Hannes Dorbath wrote: I need something that is able to replicate schema changes as well, so Slony seems out of the game :/ pg_cluster? mammoth postgresql? db_mirror? What to use for a hot-standby box? Thanks in advance Slony handles schema changes: http://gborg.postgresql.org/project/slon

Re: [ADMIN] replication for hot-standby?

Yes, it does in /some way/, but it's quite hackish and error prone.. :/ If there is anything broken about the script, or about how it executes on a particular node, this will cause the slon daemon for that node to panic and crash. If you restart the node, it will, more likely than not, try to

  1   2   >