Re: Upgrade Problem: 7.4.3 -> 8.1.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: Doug McNaught <doug(at)mcnaught(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade Problem: 7.4.3 -> 8.1.2
Date: 2006-01-19 23:22:10
Message-ID: 10528.1137712930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Rich Shepard <rshepard(at)appl-ecosys(dot)com> writes:
> psql -f /var/tmp/backup.sql
> I see:
> psql: FATAL: database "postgres" does not exist

This looks like you are trying to use an 8.1 psql to talk to a 7.4
postmaster. Database "postgres" should exist by default in an 8.1
installation but it would not in 7.4. Better check which postmaster
is really running.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2006-01-19 23:29:10 Re: out parameters and SETOF
Previous Message Tom Lane 2006-01-19 23:20:07 Re: No heap lookups on index