Re: Downlevel database

From: Gary Jackson <bargle(at)umiacs(dot)umd(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Downlevel database
Date: 2005-02-04 18:41:14
Message-ID: d960567fce91bc87ec14c235b9f594f7@umiacs.umd.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


On Feb 4, 2005, at 12:08 PM, Tom Lane wrote:
>
> No, no, and no. A 7.2.anything server would flat out refuse to start
> in
> a 7.3.* database (because it checks PG_VERSION). You might have been
> using 7.3 client-side code to talk to the 7.2 server, but that wouldn't
> cause this sort of failure.
>
> A possible quick-and-dirty solution is "VACUUM pg_database" (issued
> from
> any of the databases that you can get into). If that doesn't work then
> you've got serious problems :-(
>
> regards, tom lane
>

The 7.3 data directory was actually elsewhere -- duh on me. Thanks for
the help!

--
Gary Jackson
bargle(at)umiacs(dot)umd(dot)edu

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-02-04 20:47:20 log_duration
Previous Message Rick Apichairuk 2005-02-04 17:55:39 Re: [ADMIN] vacuum ran out of space and now i cant get back into db