7.1 -> 7.2 on Debian - Mailing list pgsql-novice

From ghaverla@freenet.edmonton.ab.ca
Subject 7.1 -> 7.2 on Debian
Date
Msg-id Pine.A41.3.95.1020312211015.58010A-100000@fn2.freenet.edmonton.ab.ca
Whole thread Raw
In response to Re: Using indexes and keys  ("Josh Berkus" <josh@agliodbs.com>)
Responses Re: 7.1 -> 7.2 on Debian
List pgsql-novice
Hi,

  About a week ago, I was out apt-get'ing things, and
various dependencies decided postgresql needed to get
upgraded.  Fine, I don't use it for much yet, but
had some data in it.  During the install, I got a
message saying I needed to do the dump/restore manually,
and it went along on its merry way.  Tonight, I went to
do the dump.  Debian has a shell script (supposedly)
all set up to do this, but somehow I don't think it worked.
If I run this custom script, I get some output to the screen
at the end which is postgresql related, but looks like
error messages from the log.  The dump is 218 bytes long.
If I try to run the 7.1 dumpall command manually, it tells
me the postmaster isn't running.  Which is correct, Debian
has locked out the postmaster since the database dump
needed to be done manually.

Can this dump really be only 218 bytes long?  Or should
a person uninstall 7.2, reinstall 7.1, dump the data,
uninstall 7.1, reinstall 7.2?

Gord

Matter Realisations     http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng. President
101  9504 182 St. NW    Edmonton, AB, CA  T5T 3A7
780/481-8019            ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (cell)


pgsql-novice by date:

Previous
From: Anshuman Kanwar
Date:
Subject: Database is shutting down
Next
From: Oliver Elphick
Date:
Subject: Re: 7.1 -> 7.2 on Debian