Обсуждение: Setting up Postgresql on Linux

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

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


>
>
> Is there a way tell the system to run psql with the libpq.so from
> /usr/local/pgsql/lib?
> thanks,
> Phil
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)