[ADMIN] How to remove index from memory ?

2011-08-12 Thread A J
Hello I am running a test to find the impact of corrupt indexes on queries. I corrupted the index file but observed that the queries continued to perform without issues. It was only on restart of the database that postgres realized that the indexes are corrupt and my queries started failing (wit

Re: [ADMIN] replication from Oracle to PostgreSQL?

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

Re: [ADMIN] How to remove index from memory ?

2011-08-12 Thread Kevin Grittner
A J wrote: > I am running a test to find the impact of corrupt indexes on > queries. I corrupted the index file but observed that the queries > continued to perform without issues. It was only on restart of the > database that postgres realized that the indexes are corrupt and > my queries start

[ADMIN] pgpool replication mode

2011-08-12 Thread s...@bestmx.ru
hi. excuse me for offtopic -- pgpool maillist is almost dead i want pgpool in replication mode to interrupt service in case of any backend failure. is it possible? -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/

[ADMIN] lo_import/lo_export in other table

2011-08-12 Thread Nelson Gonzaga
Hi all, How can I modify (or create other one) lo_import to save data in my table (not in pg_largeobject). Because I'm making an app that create a table with my fields and a bytea field, but .net doesn't read that field like lo_export.   Any ideas?   tks in advance,

Re: [ADMIN] replication from Oracle to PostgreSQL?

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