[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

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

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 cs_...@consistentstate.com writes: On

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

[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

[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

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

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

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 Data

Re: [ADMIN] replication from Oracle to PostgreSQL?

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

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

[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

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

[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,

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

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

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