PostgreSQL Discussion - Re: Access Problem After Version Upgrade -- FIXED

Author

Re: Access Problem After Version Upgrade -- FIXED

Rich Shepard

2006-01-26, 4:57 pm

On Thu, 26 Jan 2006, Rich Shepard wrote:
[color=darkred]

Thanks to Jim I found that libpq.so.3 were in the old directory. As soon as
I moved them to /usr/lib (with libpq.so.4), SQL-Ledger allowed me to log in.

All of this reminds me of the time, about 8 years ago, when postgres would
install in one directory, but Red Hat's rpms put it in another directory.
That caused all sorts of problems until I started building from source and
ignoring the packages.

Here, it was the move from /usr/local/pgsql to /var/lib/pgsql that caused
me all this grief.

A huge "thank you" to all of you -- and especially Jim.

Rich

--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Joshua D. Drake

2006-01-26, 4:57 pm

> Here, it was the move from /usr/local/pgsql to /var/lib/pgsql that caused
> me all this grief.
>
> A huge "thank you" to all of you -- and especially Jim.

Although I am glad you were able to get up and running, typically you
don't want to "move" libs like that. Instead update your /etc/ld.so.conf
and run ldconfig.

Sincerely,

Joshua D. Drake

>
> Rich
>

--
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Sponsored Links