[GRASSLIST:121] GRASS/postgresql

[Michael Ash]

I am sorry that I have been such a source of annoying
inquiry today.

I found an answer to the GRASS/postgresql problem that I
just posted.  (The binary of 5.0.2 wants libpq.so.2 and my
system has libpq.so.3 but not libpq.so.2)

The solution is based on the archived email reprinted below.

1. I made sure that /etc/ld.so.conf includes the nonstandard
location of the pgsql libraries: /usr/local/pgsql/lib and
that I had run ldconfig after making the addition.

2. I created a symbolic link link of /usr/local/pgsql/lib/libpq.so.2 for /usr/local/pgsql/lib/libpq.so, i.e

ln -s /usr/local/pgsql/lib/libpq.so /usr/local/pgsql/lib/libpq.so.2

which seems to have done the trick.  (Please let me know if
there is anything dangerous about this "fix.")

Best,

Michael




    * To: grasslist at baylor.edu
    * Subject: [GRASSLIST:4846] odbc problem
    * From: "Miha STAUT" <mihastaut at hotmail.com>
    * Date: Sun, 27 Oct 2002 16:11:15 +0000
    * Sender: owner-GRASSLIST at baylor.edu

Hi everybody,

Thanks for replying me so numerously. When I executed the
"g.select.pg
database=database_name", I got the following message:

GRASS:~ > g.select.pg database=obc
g.select.pg: error while loading shared libraries: libpq.so:
cannot open
shared object file: No such file or directory

Even though I checked everywhere, I could not find the
missing library on my
computer. The description of the package
postgresql-libs-7.2.1-5.i386.rpm
states that it has it. ???

I found other libraries depending to the package in the
standard location
(/usr/lib). I solved the problem with duplicating libpq.so.2
and renaming it
to libpq.so. It worked.

Miha Staut

Michael Ash, Assistant Professor
  of Economics and Public Policy
Department of Economics and CPPA
University of Massachusetts
Amherst, MA 01003
Tel 413-545-6329 Fax 413-545-2921
Email mash at econs.umass.edu
http://people.umass.edu/maash