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