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.
I've got replication setup (streaming replication) between two 9.2.2 clusters.
Everything went just fine on that, and it's working as expected.
Now, obviously, I'll know if my primary goes down. I just monitor him as usual.
How do I tell whether the standby has gone out of sync for whatever re
Hi
I have a replicated slave copy of my database. Our 6 year old - non modular
web app does not have the connection selector for our PHP scripts, so PHP
opens SQL queries to the default (last connection) made by the scripts. So
if i open a connection to the slave somewhere, it would become the lat
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
Hi,
I started replicating my Postgres9.1.3 server on Friday, and it seems to be
working well.
The master server database is quite large (somewhere in the order of 85GB) so
the rsync to copy the base_backup took a while to complete.
However, looking at the log files and 'ps' I'm wondering if the
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
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 I do to fix this? The log on the standby
is shown below:
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
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...
--
-
Kevin Kempter - Constent State
A PostgreSQL Professional Services Company
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
Hello everybody,
I am new to PostgreSQL. i am using version 9.
I have installed it on two machines.
I have put data about 450 digital documents in one machine.
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?
secondly, my Post
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
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 central location, I want to replicate
from all masters to a central sla
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
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 will allow access for web applications. This copy of the
data
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
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
-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
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
Hi,
I am struck with a problm could anyone help me out here plz..
I have a problem while replicating my database in same machine via PgAdmin
on Windows, When I try to initiate a new Slony cluster in the PgAdmin
interface, the status-bar says "Slony-I creation scripts not available; only
joining p
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
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
-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
Dear Gurus,
I need some solution for a transaction-based system that may have
offline clients. Something like CVS in version management, but
SQL-based.
I need this because we have a team of 6 people, concurrently updating
shared XML files and such. When I leave the corporate network I can
keep up
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
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
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
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
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
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 am truly lost but I know that Slony is not
> 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,
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
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
Hi all,
We intend to establish a central back-up for our system. It can be though as
many machines (masters) linked to one Slave. The communication may be one
directional (master -> slave) and would appreciate to have it almost in
realtime.
The data flux on the system is not very high in terms of
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
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 replication and can i get it wi
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..
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 in every
Every table that create must added by 1 Field ( ex : clusteri
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
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
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'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
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
>
> 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
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 case of failure of the
-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
>
>
>
-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 case of failure of th
>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
1 - 100 of 233 matches
Mail list logo
