Setting up Postgresql on Linux

On 05/03/2004 15:58 phil campaigne wrote:

Thanks Tom,
I originally set installed Postgresql as rpm with the Red Hat 8
installation. I upgraded using source and it put things in different
directories. I think that this is the source of my problem.

However, I think the updated version of Postgresql is not teh one the
system is trying to use:

That says that when you say "psql", the system is trying to run the psql
from /usr/bin with the libpq.so from /usr/local/pgsql/lib.

Is there a way tell the system to run psql with the libpq.so from
/usr/local/pgsql/lib?
thanks,
Phil

IMO, your best bet is to the following (you'll need to root btw):

0) stop the postmaster if it's running

1) un-install the version of pg you just compiled (make uninstall)

2) install the postgresql-devel RPM (from memory, I think it's on binary
CD3)

3) use the output of pg_config --configure to get the options which the RH
version was compiled wit

4) run configure again with exactly those options then make, make install.

5) edit /etc/rc.d/init.d/postgresql and change pg version if needed (there
may be several places where it needs changing)

6) delete or rename /var/lib/pgsql/data

7) /sbin/service postgresql start

8) su postgres

9) create users...

-- 
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for 
Business             |
| Computer Consultants         | 
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

phil campaigne wrote:

Thanks Tom,
I originally set installed Postgresql as rpm with the Red Hat 8
installation. I upgraded using source and it put things in different
directories. I think that this is the source of my problem.

However, I think the updated version of Postgresql is not teh one the
system is trying to use:

That says that when you say "psql", the system is trying to run the psql
from /usr/bin with the libpq.so from /usr/local/pgsql/lib.

Give /usr/local/pgsql/lib precedence in the /etc/ld.so.conf