pg_upgrade loses all data

Started by Oliver Elphickover 26 years ago2 messages
#1Oliver Elphick
olly@lfix.co.uk

Release 6.5beta2

I've used pg_upgrade to import data from 6.4.2.

The tables are created correctly, as far as I can see, but the data gets
lost, so that no tuples are visible in any table I have yet looked at.
The data is actually present, because I can see it if I use `od -c' on
a table's file, but select * reports no rows.

Any clues, please?

NB: If this experience is repeated by others, anyone who had not backed up
his data separately would lose it all (if the tables are not repairable).

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"There is a way that seems right to a man, but in the
end it leads to death."
Proverbs 16:25

#2Bruce Momjian
maillist@candle.pha.pa.us
In reply to: Oliver Elphick (#1)
Re: [HACKERS] pg_upgrade loses all data

I have already noted in the Release notes and FAQ that pg_upgrade can
not be used in 6.5. Let me disable it now. I forgot to do that, and
your report confirms my fears.

Release 6.5beta2

I've used pg_upgrade to import data from 6.4.2.

The tables are created correctly, as far as I can see, but the data gets
lost, so that no tuples are visible in any table I have yet looked at.
The data is actually present, because I can see it if I use `od -c' on
a table's file, but select * reports no rows.

Any clues, please?

NB: If this experience is repeated by others, anyone who had not backed up
his data separately would lose it all (if the tables are not repairable).

--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"There is a way that seems right to a man, but in the
end it leads to death."
Proverbs 16:25

-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026