[ic] Running Interchange 4.6.1 with Postgesql 7.0.2 on Redaht 7.0

[Nick Rathke]

This is a multi-part message in MIME format.
--------------797D85B322CC88EC2503BABB
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Here is what I did to make Interchange 4.6.1 work with  Postgresql 7.0.2
on Redhat 7.0

1)Build postgres7.0.2 from source with "./configure --with-odbc
--with-perl "

2)Set "POSTGRES_LIB" and  "POSTGRES_INCLUDE"  to point to
"/usr/local/pgsql/lib" and "/usr/local/pgsql/include"  in my .bashrc
2a)Add in all the postgres environment paths

3)Use CPAN to "get"  ( not install ) the following : DBD-Pg-0.95,
DBI-1.14, SQL-Statement-0.1016, Safe-Hole-0.07, and Storable-1.0.6
    note: There are other other packages that Interchange wants and I
just downloaded them the same way.  The above are for Postgresql use.

4)Run "perl Makefile.PL;make;make install " on all the above packages.
4a)Run "postmaster -d /usr/local/psql/data " ( set to your pgsql path )

5)Build Interchange from the source.
5a)I don't know if this matter too much,  but I setup Interchange with
the same user account as I did Postgresql.

6)Run  "./makecat"  from you local Interchange directory setting it to
run with Postgresql

7)Run "./interchange -r"  and it should load all that tables into the
database.

I have now don this on 4 servers and it seem to work every time.

Nick

P.S.

I will write better doc's if anyone wants me to.........


--------------797D85B322CC88EC2503BABB
Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Return-Path: <paul.aviles@palei.com>
Delivered-To: render@mail-slkc.uswest.net
Received: (qmail 92450 invoked by uid 0); 14 Dec 2000 15:20:03 -0000
Received: from mail9.uswest.net (204.147.80.27)
  by slkcpop1.slkc.uswest.net with SMTP; 14 Dec 2000 15:20:03 -0000
Received: (qmail 70423 invoked from network); 14 Dec 2000 15:20:02 -0000
Received: from athm-216-217-xxx-18.home.net (HELO paux003) (216.217.200.18)
  by mail9.uswest.net with SMTP; 14 Dec 2000 15:20:02 -0000
Received: (qmail 5956 invoked from network); 14 Dec 2000 16:19:05 -0000
Received: from unknown (HELO avilespa) (216.217.200.2)
  by 9.5.24.20 with SMTP; 14 Dec 2000 16:19:05 -0000
Date: Thu, 14 Dec 2000 10:23:04 -0500
Message-ID: <001f01c065e1$c0df98e0$03250509@shula.com>
From: "Paul Aviles" <paul.aviles@palei.com>
To: "Nick Rathke" <render@qwest.net>
References: <3A351871.EDCFC701@qwest.net>
Subject: Re: Postgesql 7.0.2 on Redaht 7.0 is running!!!!!
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Mozilla-Status2: 00000000

Nick, with your permission,  can I suggest to include your findings to IC? I
saw another entry for a guy with the same problems and your findings will
help a lot I think.
-pa


----- Original Message -----
From: Nick Rathke <render@qwest.net>
To: Paul Aviles <paul.aviles@palei.com>
Sent: Monday, December 11, 2000 1:09 PM
Subject: Postgesql 7.0.2 on Redaht 7.0 is running!!!!!


> Paul,
>
> Success... Here is what I did step by step.
>
> 1) Build postgres7.0.2 from source with options --with-odbc --with-perl
>
> 2) Set POSTGRES_LIB and POSTGRES_INCLUDE  to point to
> /usr/local/pgsql/lib and /usr/local/pgsql/include in my .bashrc
>
> 3) used cpan to get ( not install ) the following : DBD-Pg-0.95,
> DBI-1.14, SQL-Statement-0.1016, Safe-Hole-0.07, and Storable-1.0.6
>
> 4) run perl Makefile.PL;make;make install on all the above packages.
>
> 5) rebuilt interchange from the very beginning starting at ./configure
>
> 6) when I did ./makecat set it to run with postgres
>
> 7) When I ran ./interchange -r  it loaded all that tables into the
> database. ( something it had never done before )
>
>
> Now all I have to do is do all over on a different box and make sure it
> is repeatable. Let me know if I can help you figure your stuff out. Or
> need me to better document it.
>
>
> Nick
>
>
>



--------------797D85B322CC88EC2503BABB--