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

Re: Psql errors

From: Carol Walter <walterc(at)indiana(dot)edu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Psql errors
Date: 2008-12-22 15:34:47
Message-ID: (view raw or whole thread)
Lists: pgsql-admin

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, but that  
didn't work.


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

In response to

pgsql-admin by date

Next:From: Magnus HaganderDate: 2008-12-22 16:24:31
Subject: Re: publishing changelogs on pgweb
Previous:From: Carol WalterDate: 2008-12-22 14:43:54
Subject: Psql errors

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