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

["Nick Rathke" <render@qwest.net>]

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.........

---

• To: "Nick Rathke" <render@qwest.net>
• Subject: Re: Postgesql 7.0.2 on Redaht 7.0 is running!!!!!
• From: "Paul Aviles" <paul.aviles@palei.com>
• Date: Thu, 14 Dec 2000 10:23:04 -0500
• Delivered-To: render@mail-slkc.uswest.net
• References: <3A351871.EDCFC701@qwest.net>

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
>
>
>

---