Re: Postgres questions

Dbi link was configured with instruction form dbi-link. Where I can find
this scripts:
Can you connect to Cache from a stand-alone Perl script using Perl DBI?

If so, can you connect to Cache from a PL/Perlu script using Perl DBI?

Is MS-SQL performance OK when connecting from a stand-alone Perl script
outside the database using Perl DBI?

Is MS-SQL performance OK when connecting from a custom test plperlu script
using Perl DBI?

Queries in mssql are sql select from talbe on mssql with about 400.000 rows.

About replication now I can't upgrade to 9.0 with 8.3 what possible options
exists, if is active/passive and is not real ha also it can be OK

Thanks

2011/5/24 Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>

> On 05/24/2011 05:15 PM, Trenta sis wrote:
>
> That I need is to connect to another databse (Cache Intersystems) to use
>> select from Postgres. I have tried to configure dbilink but is not
>> working with this database, with sql server seems to work but with poor
>> peroformance.
>>
>
> You really need to be specific about things like "not working" and "poor
> performance". Nobody can help you if that's all you say, you need to give
> error messages, versions, commands, configurations, etc. You haven't shown
> any queries, any EXPLAIN ANALYZE output, any schema, any timing data, or
> pretty much anything else that'd allow anyone to help you. It might be worth
> remedying that. See:
>
> In addition to that, some obvious things to test and report back on
> include:
>
> Can you connect to Cache from a stand-alone Perl script using Perl DBI?
>
> If so, can you connect to Cache from a PL/Perlu script using Perl DBI?
>
> Is MS-SQL performance OK when connecting from a stand-alone Perl script
> outside the database using Perl DBI?
>
> Is MS-SQL performance OK when connecting from a custom test plperlu script
> using Perl DBI?
>
> What do you expect performance to be like? Why? What kind of queries are
> you executing? Which ones perform badly?
>
> /- What kind of guarantees do I need about data loss windows at failover
>>
>> time? Can I afford to lose the last <x> transactions / seconds worth
>> of transactions? Or must absolutely every transaction be retained
>> at all costs?/
>> A windows data loss could be some secodn/minutes but if is not very
>> complex no data loss will be excellent.
>>
>
> It sounds like your requirements can probably be satisfied by PostgreSQL
> 9.0's built-in replication combined with the use of repmgr and heartbeat.
>
> For anything like this, though, I STRONGLY suggest that you hire a
> consultant who has done what you need before and has learned the traps and
> pitfalls. See:
>
> http://www.postgresql.org/support/professional_support
>
> I don't do PostgreSQL support commercially and am not experienced with
> failover/HA setups, so I can't help you much there and suggest you find
> someone who _really_ knows what they are doing. Getting HA right is *hard*.
>
> --
> Craig Ringer
>