[ADMIN] replication?

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-server, the other instance will be installed on a Windows-client-l

[ADMIN] Replication

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 per month there is short disconnection, longer discoonection 2x per year (1-2+ hours) on both are running updates i need have same data in time, but i never upda

[ADMIN] replication

Hello, Is it possible to do replication through postgresql on Solaris 2.6..? Can you show me any adress that tells replication on postrgres..? Thanks.. Safa Pilavcı Rumeli Telekom A.Ş Tel : (90) 212 288 78 50 Fax : (90) 212 274 87 21 [EMAIL PROTECTED]

[ADMIN] replication

dear developers, I've seen the replication skill on the todo-list. when will this be released? Or is it possibly with the actual build to synchronize two databases? Thanks for your answers. F. Röttger Emsland Messe GmbH BEGIN:VCARD VERSION:2.1 N:Röttger;Florian FN:Florian Röttger ORG:Emsland

[ADMIN] Replication

Hellow everyone, I am facing a problem using postgresql. How replication can be performed for postgres databases? TIA.

[ADMIN] replication

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 it, the standby database should be replicated automatically from the regualar database. Notonly that, the replication will be useful to

[ADMIN] replication

Hello I want to add replication capabilities to my postgresql installation. Can anyone recommend a good way (open source or otherwise) to do so? Basically, I have a web tracking application that must quickly and reliably store massive amounts of tracking data. Later, I run complex queries to ana

[ADMIN] Replication

Hi, Anyone have thoughts on how I might handle replication with 1 master and 2 slave databases (minimum)? I am switching our political database from mysql to postgres and need a solid way to replicate data from our internal server to our webserver. We currently use 2 databases per server, o

[ADMIN] replication

Is there a howto/demo/tutorial for setting up replication with Postgres 7.2? Thanks ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

[ADMIN] replication

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. Do you have any good pointers/how-to to direct me to? Thanks for th

[ADMIN] Replication

Can PostgreSQL do replication ? If possible could guide me in the right direction. Regards Marco Rademeyer Read our disclaimer at: http://www.picknpay.co.za/pnp/view/pnp/en/page5093? If you don't have web access, the disclaimer can be mailed to you on request. Disclaimer requests to be se

[ADMIN] Replication

Hi Folks,   is it possible to make a Replication between several PostgresSQL-Databases ?   Regards Jan Waiz

[ADMIN] replication

Please,anybody can tell me how to make replication of a PostGre DB

[ADMIN] Replication

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 ? . Thanks ---(end of broadcast)-

[ADMIN] Replication

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 documentation of the eRServer on postgres.com does not give very much detailed i

[ADMIN] Replication

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 latest news was eRServer v1.0. Is this the same as the v1.2 that Postgres INC announced early

[ADMIN] Replication

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.   Regards     Rodrigo

[ADMIN] replication loop

Hi, I am using Pgcluster 1.3 and Postgres 8. Can you tell me meaning of this messages from pgreplicate in verbose mode: 1. DEBUG:replicate_loop():replicate_loop selected 2. DEBUG:replicate_loop(): PGRread_packet failed query[(null)] cmdSys[] Thanx for your time. -- Anton P. Linevich

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

[ADMIN] Replication, HA ...?

Hello, 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? Thanks for answers Andreas -- Kraftl EDV - Dienstleistungen Schulungen, Linux, Linuxlösungen, Webpr

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,

[ADMIN] Replication Options.

Hi , 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 tableA in Node1 is the master and it should replic

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

[ADMIN] replication recommendations

I would like to setup database replication. It will primarily be used to maintain a quick swappable spare. I would also like to be able to shutdown backup occationally to make file system level backups while maintaining the ability to bring the spare up to date with the primary database once it c

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

[ADMIN] Replication Solution

Title: Message Hi   I need some help on this topic.   Can anyone give me an advice how I can to replicate data between one server and many slaves? If is posible I need the replication in two ways.   I was trying to look some solution on internet, but I don't understand.   Please, any ideas

[ADMIN] replication/redundancy

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 either database and the results replicated to the other master. Dave ---

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.

[ADMIN] replication/mirror

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. _ The new MSN toolbar! As convenient as it gets! http:

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

[ADMIN] Replication solution

Friends, 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. Thanks Palani -- Sent via pgsql-admin mailing list

[ADMIN] replication recommendation

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 schemas in the slave database that we would like to preserve The m

[ADMIN] replication solution

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 need a solution where the standby is always open in readonly , but

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

[ADMIN] Replication with PostgreSQL

Hi Can any one tell me how do I replicate my PostgreSql database from one server to another server? Prakash ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[ADMIN] Replication - standby question

Hi   I need some help implementing Hot standby.   Here is what I have done.   Create a base backup select pg_start_backup(‘label’); create a tar of data dir. restore on standby node select pg_stop_backup; ftp WAL files to standby database; configure recove

[ADMIN] Replication, High availability

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 more than couple of minutes. How to achieve this goal? Is Postgresql-R 7.2 already wo

[ADMIN] Replication, High availability

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 more than couple of minutes. How to achieve this goal? Is Postgresql-R 7.2 alread

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

[ADMIN] replication and availability

hi everyone, having read the online doc, and a book, i can't find precisely what i'm looking for, but it's maybe normal here it is I have a distant postgres database used to store networking info. This database "may" be unavailable, so i need to have another postgres database somewhere

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

[ADMIN] Replication/Mirror Help

Hello, 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. thanks, Darshan Patel. ---(end of broadcast)--- TIP 6: Have

[ADMIN] Replication for migration

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 a pg_dumpall, and then restore that information in 8.3. Taking some consider

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

  1   2   3   >