Re: Upgrade Problem: 7.4.3 -> 8.1.2

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade Problem: 7.4.3 -> 8.1.2
Date: 2006-01-19 23:18:19
Message-ID: Pine.LNX.4.63.0601191514020.20481@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 19 Jan 2006, Joshua D. Drake wrote:

> What happens when you psql -U postgres template1 ?

A-ha!

Welcome to psql 8.1.2 (server 7.4.3), 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 7.4,
but your psql client is major version 8.1. Some backslash commands,
such as \d, might not work properly.

Now, it's accessing data in /usr/local/pgsql/data. So, it's now necessary
to stop the old server and start the new one. I thought that I had done that,
but obviously not.

Your patience, Josh and Doug, is very much appreciated. I'm learning what I
should probably have learned several years ago, and these messages will be
kept for future reference. What's the next step?

Rich

--
Richard B. Shepard, Ph.D. | Author of "Quantifying Environmental
Applied Ecosystem Services, Inc. (TM) | Impact Assessments Using Fuzzy Logic"
<http://www.appl-ecosys.com> Voice: 503-667-4517 Fax: 503-667-8863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-01-19 23:20:07 Re: No heap lookups on index
Previous Message Joshua D. Drake 2006-01-19 23:09:30 Re: Upgrade Problem: 7.4.3 -> 8.1.2