Re: Psql errors

Hello,

This first problem is fixed. I didn't specify the server specifically
enough. As soon as I put the port number in, it started working.

I still don't have a solution to the second problem. I'm running on
Solaris 10. I tried adding the library path to ld.so.1, but that
didn't work.

Carol

On Dec 22, 2008, at 9:43 AM, Carol Walter wrote:

> Hello,
>
> I just installed Postgres 8.3.4. I have an instance of 8.2.4
> running on the same box. When I start psql I get errors as follows:
>
> Welcome to psql 8.3.4 (server 8.2.4), the PostgreSQL interactive
> terminal.
>
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
>
> WARNING: You are connected to a server with major version 8.2,
> but your psql client is major version 8.3. Some backslash commands,
> such as \d, might not work properly.
>
> template1=# \l
> ld.so.1: psql: fatal: relocation error: file /db02/postgres/bin/
> psql: symbol pg_valid_server_encoding_id: referenced symbol not found
> Killed
> -bash-3.00$
>
>
> There are two problems here that may or may not be related. One
> problem is that when I start psql using the binary I just loaded,
> the right version of psql starts but it is looking at the wrong
> database instance. Secondly, there is a library that in can't find.
>
> Please help with debugging these problems.
>
> Thank you very much,
> Carol
>
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin