Skip site navigation (1) Skip section navigation (2)

Psql errors

From: Carol Walter <walterc(at)indiana(dot)edu>
To: pgsql-admin(at)postgresql(dot)org
Subject: Psql errors
Date: 2008-12-22 14:43:54
Message-ID: A7382EC8-8011-486C-9B2F-5F360267E853@indiana.edu (view raw or flat)
Thread:
Lists: pgsql-admin
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



Responses

pgsql-admin by date

Next:From: Carol WalterDate: 2008-12-22 15:34:47
Subject: Re: Psql errors
Previous:From: Alvaro HerreraDate: 2008-12-22 14:00:06
Subject: Re: [ADMIN] rebellious pg stats collector (reopened case)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group