Postgres questions

From: Trenta sis <trenta(dot)sis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres questions
Date: 2011-05-23 22:10:08
Message-ID: BANLkTi=+9Ge38pP=VoEqwtxYrvh6ugEE5w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have Debian Lenny server with Postgres 8.3 that is workin correctly, but I
have some questions about this installation.

This server is working whitout any problem but it is a little critical and I
need to know how can I do...

- I need to connect from postgres to other database (linked server) no
postgres (for example with jdbc or odbc). I have tried to work with dbi-link
with sql, it seems to work but with poor performance and whit other database
different mssql is not working. What possible options exsits with 8.3? and
with other versions?

- This server has some critical applications and I need high availability,
but I'm not sure about possible options for this versions or similar. I have
thought about active/active, active/passive or active/read-only but I'm not
sure what are real options, and what could be a possible environment for
this situation

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-05-24 00:53:20 Re: Postgres questions
Previous Message rudi 2011-05-23 20:53:10 Re: strange behaviour in 9.0.2 / ERROR: 22003: value out of range: overflow