[ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Mary Anderson
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

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Shoaib Mir
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

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Chris Browne
[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")

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Andrew Sullivan
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

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Shoaib Mir
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

Re: [ADMIN] replication between linxu postgresql and Windows postgresql

2007-06-25 Thread Adam Radlowski
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