Compiling with Postgresql support

[Dwayne Miller]

Looks like also had the gnucash 1.8.1 rpm installed as well.  All of the 
files were in the /usr/local/lib/gnucash.

I removed the RPM version.

Now... when I try to save to 'postgres://localhost/dbname' a dialog pops 
up stating that the version is old, would I like to upgrade.  If I pick 
yes, then another dialog appears stating that an error occurred.

In the database, the only table created is the gncversion.  Nothing else 
is there. I've looked at the table-create.c (.sql) and it looks like the 
entire database should be created... I did not see how it was checking 
for the version during the create statements.  I'll keep digging...

D

Derek Atkins wrote:

>If you _just_ did ./configure --enable-sql then it would have
>installed into the default prefix of /usr/local, not /usr.
>That means you probably have a bunch of files in /usr/local/lib/gnucash/
>
>Look there..  Then decide where you want gnucash to live.
>
>-derek
>
>Dwayne Miller <dmiller at espgroup.net> writes:
>
>  
>
>>I have all of the files you mentioned in the
>>.../src/backend/postgres/.lib directory... but none of them in the
>>/usr/lib/gnucash directory.  I do have a /usr/lib/gnucash directory
>>with many libgnc... files though.  I did
>>
>>./configure --enable-sql
>>make
>>make install
>>
>>I did not capture a log of the make, but did not notice any errors as
>>it was going.  I'll try copying the files from the .lib directory into
>>the /usr/lib/gnucash location and see if that works.
>>
>>Tks,
>>D
>>
>>Matthew Vanecek wrote:
>>
>>    
>>
>>>-----BEGIN PGP SIGNED MESSAGE-----
>>>Hash: SHA1
>>>
>>>On Sat, 1 Mar 2003, Dwayne Miller wrote:
>>>
>>>
>>>      
>>>
>>>>I compiled with --enable-sql.... seems to have gone well.  But when
>>>>I try to save as 'postgres://localhost/dbname', I get all kinds of
>>>>errors about not being able to load the postgres backend.  How can
>>>>I tell if the postgres backend was successfully compiled?
>>>>
>>>>Tks,
>>>>D
>>>>
>>>>
>>>>        
>>>>
>>>Were any errors generated in the compile process?  How did you
>>>compile? Do you have all the necessary Postgresql components
>>>installed that are required for compiling applications? If it
>>>compiled and installed correctly, you should have (depending on the
>>>prefix you used):
>>>
>>>/usr/lib/gnucash/libgncmod-backend-postgres.la
>>>/usr/lib/gnucash/libgncmod-backend-postgres.so
>>>/usr/lib/gnucash/libgncmod-backend-postgres.so.0
>>>/usr/lib/gnucash/libgncmod-backend-postgres.so.0.0.0
>>>
>>>
>>>- -- 
>>>Matthew Vanecek
>>>perl -e 'print $i=pack(c5,(41*2),sqrt(7056),(unpack(c,H)-2),oct(115),10);'
>>>********************************************************************************
>>>For 93 million miles, there is nothing between the sun and my shadow except me.
>>>I'm always getting in the way of something...
>>>-----BEGIN PGP SIGNATURE-----
>>>Version: GnuPG v1.0.6 (GNU/Linux)
>>>Comment: For info see http://www.gnupg.org
>>>
>>>iD8DBQE+Yip7i/CNzDSN0RIRAirZAJ0UXsmgSc+hZGsQKi5UMN3nKwn3jQCfVOx5
>>>OfFcYE0w+DC4x2JZ6n5ywX0=
>>>=OXnG
>>>-----END PGP SIGNATURE-----
>>>
>>>_______________________________________________
>>>gnucash-user mailing list
>>>gnucash-user at lists.gnucash.org
>>>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>>
>>>      
>>>
>>_______________________________________________
>>gnucash-user mailing list
>>gnucash-user at lists.gnucash.org
>>https://lists.gnucash.org/mailman/listinfo/gnucash-user
>>    
>>
>
>  
>