Search Postgresql Archives

Re: replication only

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



In response to Jef Peeraer <jef.peeraer@xxxxxxxxxx>:
> 
> On Tue, 5 Aug 2008, Bill Moran wrote:
> 
> > In response to Jef Peeraer <jef.peeraer@xxxxxxxxxx>:
> > > 
> > > i read about the replication possibilities with postgresql. If i just need 
> > > some replication ( without failover stuff ) to 1 standby server, what 
> > > would be the best option to go with.
> > 
> > Your description of you requirements is very lacking, so much so that
> > any attempt at suggesting a "best" option would be pointless.
> > 
> > Provide some more information on your requirements and people will be
> > able to answer intelligently.
> my apology, i tried to be brief.
> i've got a main database, where all transactions end up. Daily we make a 
> backup (pg_dumpall) and restore the first database in a sort of backup 
> database. This backup database is mainly used to do reporting. 
> To automate this process for the backup database and to minimize the 
> out-of-sync state, i should like to use replication. 
> The second backup database is only used as read-only,
> except for some third party software that writes to 1 table.

You'd probably be best with Slony, just don't replicate that 1 table
that you'll need to write to.

-- 
Bill Moran
Collaborative Fusion Inc.
http://people.collaborativefusion.com/~wmoran/

wmoran@xxxxxxxxxxxxxxxxxxxxxxx
Phone: 412-422-3463x4023


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux