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
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.
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
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
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
On Fri, Apr 6, 2012 at 2:56 AM, Rural Hunter ruralhun...@gmail.com 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
Simon Riggs si...@2ndquadrant.com writes:
On Fri, Apr 6, 2012 at 2:56 AM, Rural Hunter ruralhun...@gmail.com wrote:
2012-04-06 02:37:27 CST [@] PANIC: GIN metapage disappeared
Known bug, see
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 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
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
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
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
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
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
Data
On Thu, Aug 11, 2011 at 3:41 PM, CS DBA cs_...@consistentstate.com 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
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
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
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
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
amjad usman au_mar...@yahoo.com 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
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
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
On Wed, Feb 16, 2011 at 1:33 PM, Scott Marlowe scott.marl...@gmail.com wrote:
On Wed, Feb 16, 2011 at 12:45 PM, Armin Resch ar...@reschab.net 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
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
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 will
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
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 need a
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
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
Silvio Brandani silvio.brand...@tech.sdb.it 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
Hi,
24.Ağu.2010 tarihinde 16:46 saatinde, Silvio Brandani silvio.brand...@tech.sdb.i
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
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 need a
On Tue, Aug 24, 2010 at 10:38 AM, Joshua D. Drake j...@commandprompt.com
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
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
-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 schemas
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
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
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
mark.guadal...@gmail.com wrote:
We are currently using Slony for our client's database that has
Joshua D. Drake j...@commandprompt.com 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:
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
Palaniappan Thiyagarajan pthiyagara...@cashedge.com 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
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
Palaniappan Thiyagarajan
: [ADMIN] Replication solution
Palaniappan Thiyagarajan pthiyagara...@cashedge.com wrote:
I am looking for Postgres replication solution for 8.3.x DB.
https://projects.commandprompt.com/public/replicator
http://www.slony.info
http://www.bucardo.org
http://pgfoundry.org/projects/skytools
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 step
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
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
-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
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
-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 cannot
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
2009/6/11 Hans Roman hans.r...@gmail.com:
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!
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
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 a
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 must
read,
Hi,
Martin Spinassi martins.li...@gmail.com 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
On Thu, May 14, 2009 at 7:59 AM, Kenneth Marshall k...@rice.edu 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
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 PROTECTED] (Martin
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
[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
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
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,
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 available
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
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
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
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 called
[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))
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
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 :
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 =
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
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 per
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
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
expect?
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
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
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
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
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)
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
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
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.
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
-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
-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
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
We
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,
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
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:
[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 replication?
There
-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 interface, and am
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
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 don't
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
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'm
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
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
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 need
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
1 - 100 of 215 matches
Mail list logo