Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread Craig Ringer
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

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread Greg Smith
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

Re: [ADMIN] PostgreSQL fails to bind IPv6 socket at startup on AIX platform

2011-08-11 Thread Steve Singer
On 11-08-11 02:24 PM, CS DBA wrote: Hi All; we're trying to get PostgreSQL configured on an AIX box (AIX version 5). After some digging & adding various paths to LD_LIBRARY_PATH (Thanks to help from Tom Lane) we were able to complete the source based build. However, when we try and start the

[ADMIN] streaming replication questions

2011-08-11 Thread Lonni J Friedman
I've got three Linux systems (each with Fedora15-x86_64 running PostgreSQL-9.0.4). I'm attempting to get a basic streaming replication setup going with one master & two standby servers. At this point, the replication portion appears to be working. I can run an 'update' statement on the master, a

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread Joshua D. Drake
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

[ADMIN] PostgreSQL fails to bind IPv6 socket at startup on AIX platform

2011-08-11 Thread CS DBA
Hi All; we're trying to get PostgreSQL configured on an AIX box (AIX version 5). After some digging & adding various paths to LD_LIBRARY_PATH (Thanks to help from Tom Lane) we were able to complete the source based build. However, when we try and start the db we get the following: $ pg_ctl s

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread M. D.
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

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread Simon Riggs
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

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread Chris Ernst
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

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread CS DBA
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

Re: [ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread 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, -- Devrim GÜNDÜZ P

[ADMIN] replication from Oracle to PostgreSQL?

2011-08-11 Thread CS DBA
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

[ADMIN] Master to Master replication options?

2011-08-11 Thread CS DBA
Hi All; I have a client that wants the following: - 2 masters (master to master replication) - multiple read only slaves off each master - the ability to failover in case of a master node failure to include re-directing the slaves off the failed master to now point to the remaining activ

Re: [ADMIN] Postgres service starts and then stops immediatly

2011-08-11 Thread Igor Neyman
From: Sofer, Yuval [mailto:yuval_so...@bmc.com] Sent: Thursday, August 11, 2011 6:01 AM To: pgsql-admin@postgresql.org Cc: Zucker, Yehudit Subject: Postgres service starts and then stops immediatly Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windo

Re: [ADMIN] initdb fails on AIX

2011-08-11 Thread Nicholson, Brad (Toronto, ON, CA)
> -Original Message- > From: pgsql-admin-ow...@postgresql.org [mailto:pgsql-admin- > ow...@postgresql.org] On Behalf Of Tom Lane > Sent: Wednesday, August 10, 2011 4:22 PM > To: CS DBA > Cc: PG Admin > Subject: Re: [ADMIN] initdb fails on AIX > > CS DBA writes: > > On 08/10/2011 01:16 PM,

Re: [ADMIN] Postgres service starts and then stops immediatly

2011-08-11 Thread Craig Ringer
On 11/08/2011 6:00 PM, Sofer, Yuval wrote: Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: "The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to

[ADMIN] Postgres service starts and then stops immediatly

2011-08-11 Thread Sofer, Yuval
Hi, -We are using Postgres 8.3.7 on Windows -We cannot start the Postgres service. The windows OS error message is: "The PostgreSQL Server 8.3 service on Local Computer started then stopped. Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts