TOra + PostgreSQL?

Clay · n00b Joined: 22 May 2002 Posts: 23

I know TOra supports PostgreSQL, I've used it on Windows... anyway, when I emerge it, it throws some "no connection provider" error.

How can I get it connect to a pgsql server? Do I need to install the Oracle client to get it to do what I want?

DooBeDooBeDo · Apprentice Joined: 21 Aug 2002 Posts: 217 Location: UK

Do you have 'postgres' in your USE var?

Clay · n00b Joined: 22 May 2002 Posts: 23

yep... it's in /etc/make.conf

Clay · n00b Joined: 22 May 2002 Posts: 23

for some reason, the postgres portion of the ebuil was commented out... i removed the comment, but it still didn't compile with any support...

rizzo · Posted: Wed Dec 25, 2002 5:54 am Post subject:

TOra ebuild author here.

It is commented out because, as you discovered, it does nothing. TOra derives mysql and postgres support from Qt. So I imagine you compiled Qt without postgres support. Ensure (again) that "postgres" is in your USE var, then re-compile qt. You may need to re-compile tora afterwards, I'm not certain.

Clay · n00b Joined: 22 May 2002 Posts: 23

rizzo · Posted: Thu Dec 26, 2002 4:14 am Post subject:

uraes · Posted: Thu May 29, 2003 5:45 am Post subject: But what about Oracle

I added "oci8" to my USE var, recompiled qt but it didn't add Oracle provider to TOra. What next?

Urmas

rizzo · Posted: Thu May 29, 2003 3:30 pm Post subject:

Did you recompile TOra? You need to do that if you didn't have oci8 support in the previous compile.

Make sure your $ORACLE_* environment vars are set correctly as well.