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.
On 06/25/2012 11:40 AM, Rob Cowell wrote:
Why would the output from ‘ls’ show older filenames (013D...xx)
as newer in date than the “013F...xx” filenames?
Does Postgres re-cycle old log filenames ?
It recycles old log files. If you turn on log_checkpoints, you can see
how man
Simon Riggs writes:
> On Fri, Apr 6, 2012 at 2:56 AM, Rural Hunter wrote:
>> 2012-04-06 02:37:27 CST [@] PANIC: GIN metapage disappeared
Known bug, see
http://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=57b100fe0fb1d0d5803789d3113b89fa18a34fad
>> 2012-04-06 02:37:27 CST [@] CONT
On Fri, Apr 6, 2012 at 2:56 AM, Rural Hunter wrote:
> I'm trying to set up a standby server. Both the primary and standby servers
> are on latest version 9.1.3 on ubunt server 10.10. So far I tried to init
> the setup 2 times but both failed after the replication running for some
> time. what can
On 12/08/2011 10:40 PM, CS DBA wrote:
There are lots of ETL tools available, and there's always the
roll-your-own queue-based trigger replication system option. Of
course, both options would probably cost more than buying EDB's
already built and tested version...
interesting idea, any specific
On 08/11/2011 08:09 PM, Craig Ringer wrote:
On 11/08/2011 10:57 PM, CS DBA wrote:
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Se
On 11/08/2011 10:57 PM, CS DBA wrote:
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bund
On 08/11/2011 03:58 PM, Joshua D. Drake wrote:
I would imagine it would be pretty simple to fork the triggers that do
replication in Londiste or Slony (as long as everything else was
PostgreSQL) to be able to replicate from Oracle to PostgreSQL.
That's the approach taken by some of our in-hous
On 08/11/2011 07:57 AM, CS DBA wrote:
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bund
On 08/11/2011 08:41 AM, CS DBA wrote:
Hi All;
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
Thanks in advance...
SymmetricDS is capable of doing replication one DB to another, but I've
never used it so cannot spea
On Thu, Aug 11, 2011 at 3:41 PM, CS DBA wrote:
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
2ndQuadrant has various in-house tools for fast migration from Oracle
to PostgreSQL, but those aren't designed for long term
On 08/11/2011 08:41 AM, CS DBA wrote:
> Hi All;
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
>
>
> Thanks in advance...
>
I believe EnterpriseDB Advanced Server does it
(http://www.enterprisedb.com/)
--
Chris Ernst
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
Anyone know of tools / options that will allow Oracle to PostgreSQL
replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bundled.
Regards,
That was the first thi
On Thu, 2011-08-11 at 08:41 -0600, CS DBA wrote:
>
> Anyone know of tools / options that will allow Oracle to PostgreSQL
> replication? or at least a real time feed or dblink?
EnterpriseDB's Postgres Plus Advanced Server has a realtime replication
solution bundled.
Regards,
--
Devrim GÜNDÜZ
P
amjad usman wrote:
> now i want to copy the same data on the other machine for testing
> some queries.
>
> can anybody tell me how i can do this?
You have many options. You can review them in the documentation
here:
http://www.postgresql.org/docs/9.0/interactive/backup.html
> secondly, m
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
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
On Jan 25, 2011, at 7:04 AM, alys brett wrote:
> I am planning a system that will be hosted within a secure network with very
> limited access. All access to the database will be from within this network.
> I need to have a copy of the database available on a much less secure server,
> which wi
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
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
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
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
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
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
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
-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
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
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:
"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
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
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
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
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
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
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> First of all, I need Windows clients for offline use -- maybe cygwin will do.
Perhaps. Keep in mind the Bucardo daemon(s) can live anywhe
Hello Greg,
Thanks, that sounds really reasonable. I'll have to get really
familiar with it, though.
First of all, I need Windows clients for offline use -- maybe cygwin will do.
Second, I don't exactly know what is the effect of disabling triggers
and rules: will it affect transactions running in
-BEGIN PGP SIGNED MESSAGE-
Hash: RIPEMD160
> - Way of handling conflicting records
> e.g. client A goes offline, client B modifies master, client A
> modifies locally, and when goes online again cann
2009/6/11 Hans Roman :
> Hi guys, I wanna make replication between a MSQLServer 2k (master) to a
> PostgreSQL 8.3.7 (slave in a Centos box), Could you tell me what options i
> have? Any expierences?
>
> Regards.
>
> --
> Hans Roman
>
>
sure, you have Sequoia to do that, but ... beware! this tool i
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
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
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
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
http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html
- Original Message
From: Chris Browne <[EMAIL PROTECTED]>
To: pgsql-admin@postgresql.org
Sent: Wednesday, October 8, 2008 7:47:45 PM
Subject: Re: [ADMIN] replication with table add/removes..
[EMAIL PRO
On Wed, Oct 8, 2008 at 9:10 AM, Martin Badie <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I have a system that have constant table adds/removes are present. I want to
> make a replication between master and slaves but not sure which one is the
> best solution for that kind of a situation. Since I am new to
[EMAIL PROTECTED] (Martin Badie) writes:
> Hi, I have a system that have constant table adds/removes are
> present. I want to make a replication between master and slaves but
> not sure which one is the best solution for that kind of a
> situation. Since I am new to replication stuff on postgresql
> 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
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
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
Hello Walfred,
yes you can use slony, we use slony for huge data replication. One
solution of them is the backup of many masters to one slave.
It is in real time - and we're quite happy with the newest version
of slony.
Don't forget to not only add tables to your replication but to also
add sequ
Mary Anderson wrote:
Hi all,
I am new to postgresql and have been called upon to set up a
database to be used by two groups. One group (mine) is strictly a
UNIX shop. The other group (theirs) is strictly a Windows shop. What
is the best way to go.
First, does postgresql have replicati
I didnt meant for the version, what i meant was all on latest.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/25/07, Chris Browne <[EMAIL PROTECTED]> wrote:
[EMAIL PROTECTED] ("Shoaib Mir") writes:
> Slony can handle this all.
No it can't. It will not work with versions of PostgreSQL
On Mon, Jun 25, 2007 at 02:42:04PM -0400, Chris Browne wrote:
> No it can't. It will not work with versions of PostgreSQL earlier
> than 7.3.3, because it requires namespace functionality that did not
> stabilize until that point.
But if you're running on <7.3.3, you really, really need to upgrad
[EMAIL PROTECTED] ("Shoaib Mir") writes:
> Slony can handle this all.
No it can't. It will not work with versions of PostgreSQL earlier
than 7.3.3, because it requires namespace functionality that did not
stabilize until that point.
--
(reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc")
Slony can handle this all.
If you do not want to use Slony, you can write your own triggers using
dblink module to get the data across.
--
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 6/25/07, Mary Anderson <[EMAIL PROTECTED]> wrote:
Hi all,
I am new to postgresql and have been calle
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
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
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
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
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
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
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
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)
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
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
>
> I think I've narrowed it down to Slony and Mammoth.
> Any pro's or con's on one vs the other?
Slony is more complicated to setup.
Slony requires triggers and cron.
Slony is asynchronous
Slony is Open Source
If Slony breaks you can call Command Prompt
It used to be that Slony was timed replic
>
> Generally speaking I'd expect Mammoth to handle high loads a little
> better since it's a log shipper and not trigger based. So, if slony
> proves too slow for this situation, then I'd recommend asking the folks
> at Command Prompt for a demo of their system to see if it can.
http://www.com
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chris Browne wrote:
>[EMAIL PROTECTED] ("Joshua D. Drake") writes:
>
>>>You are looking for synchronous replication as opposed to async?
>>>
Currently i have Slony working, but am not satisfied with how it
accomplishes replication, or it's in
[EMAIL PROTECTED] ("Joshua D. Drake") writes:
>> You are looking for synchronous replication as opposed to async?
>>
>> >Currently i have Slony working, but am not satisfied with how it
>> >accomplishes replication, or it's interface, and am curious what
>> >others are using to accomplish replicat
> You are looking for synchronous replication as opposed to async?
>
> >Currently i have Slony working, but am not satisfied with how it
> >accomplishes replication, or it's interface, and am curious what
> >others are using to accomplish replication?
There is also Mammoth Replicator:
http://ww
Kirby Ubben wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We have installed a product called Quasar for accounting needs at our
company, which is back ended by PostgreSQL. It is a requirement that
the database is replicated, real time, to a secondary machine and
PostgreSQL database, in
On Fri, Oct 21, 2005 at 11:28:36AM -0500, Kirby Ubben wrote:
> Currently i have Slony working, but am not satisfied with how it
> accomplishes replication, or it's interface, and am curious what
> others are using to accomplish replication?
What do you find unsatisfactory (or, for that matter,
dis
Unfortunately, the only syncronous replication I know of is
http://pgfoundry.org/projects/pgcluster/, which is statement-based. That
means it's got some substantial drawbacks...
On Fri, Oct 21, 2005 at 11:28:36AM -0500, Kirby Ubben wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
>
>
>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
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
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
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
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
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
[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
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
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
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
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/
---(
Brad Nicholson wrote:
> It totally depends on your enviornment. We use Slony in a 24x7x365
> production enviornment. Usage requires that you know what your doing,
> and fair amount of care and planning when using it. But Slony was
> never designed with the intent of being a click and forget
Hannes Dorbath wrote:
Yes, it does in /some way/, but it's quite hackish and error prone.. :/
It's far from hackish, and only error prone if you don't follow best
practices (ie:fireing DDL changes through slonik without testing them on
_all_ nodes first).
If there is anything broken abo
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
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
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)
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
On Tue, 2005-03-29 at 18:12 -0600, Scott Marlowe wrote:
> On Tue, 2005-03-29 at 17:50, Joshua D. Drake wrote:
> > >
> > > I think I've narrowed it down to Slony and Mammoth.
> > > Any pro's or con's on one vs the other?
> >
> > Slony is more complicated to setup.
> > Slony requires triggers and c
>
> Generally speaking I'd expect Mammoth to handle high loads a little
> better since it's a log shipper and not trigger based. So, if slony
> proves too slow for this situation, then I'd recommend asking the folks
> at Command Prompt for a demo of their system to see if it can.
http://www.com
On Tue, 2005-03-29 at 17:50, Joshua D. Drake wrote:
> >
> > I think I've narrowed it down to Slony and Mammoth.
> > Any pro's or con's on one vs the other?
>
> Slony is more complicated to setup.
> Slony requires triggers and cron.
Triggers yes, cron no...
> It used to be that Slony was timed r
On Tue, 2005-03-29 at 17:34, David B wrote:
> Folks,
>
> I'm thinking of replication tools for high volume site.
> Postgres on dual Opteron box. 1/2 GB of data.
>
> Big overnight load of data.
> Some inserts during the data but mostly selects.
>
> I think I've narrowed it down to Slony and Mammo
David B wrote:
Folks,
I'm thinking of replication tools for high volume site.
Postgres on dual Opteron box. 1/2 GB of data.
Did you really mean 1/2 GB? Seems like a mighty small database.
Maybe 1/2 TB or if you were really wild and crazy 1/2 PB.
Sorry but I couldn't resist. I've funny fingered to
>
> I think I've narrowed it down to Slony and Mammoth.
> Any pro's or con's on one vs the other?
Slony is more complicated to setup.
Slony requires triggers and cron.
Slony is asynchronous
Slony is Open Source
If Slony breaks you can call Command Prompt
It used to be that Slony was timed replic
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
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
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
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
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
1 - 100 of 173 matches
Mail list logo
