Postgresql upgrade 7.1 -> 7.2 issue
I'm having problems upgrading from postgresql 7.1 to 7.2.
On attempting to start the postmaster I get:
# /etc/init.d/postgresql start
The database is in an older format that cannot be read by
version 7.2 of PostgreSQL.
The postinstallation script should attempt to upgrade the database
automatically. If it fails, it must be done by hand.
*** READ /usr/share/doc/postgresql/README.Debian.migration.gz FIRST! ***
The version 7.2 postmaster cannot be started until
this is done.
Reading that document says I should run:
postgresql-dump -t db.out -dcivlp $PGDATA/../data.save
Which produces:
Stopping and restarting the postmaster
/usr/lib/postgresql/dumpall/7.1/postmaster -D /var/lib/postgres/data -p
5431 -o -d0
Dumping the database to db.out
/usr/lib/postgresql/bin/pg_dumpall
connected to template1...
process_hba_record: invalid syntax in pg_hba.conf file
Missing or erroneous pg_hba.conf file, see postmaster log for details
psql: Missing or erroneous pg_hba.conf file, see postmaster log for details
Finding the default encoding
process_hba_record: invalid syntax in pg_hba.conf file
Missing or erroneous pg_hba.conf file, see postmaster log for details
psql: Missing or erroneous pg_hba.conf file, see postmaster log for details
Usage: pg_encoding [options] encoding_name | encoding_number
options: -b check if encoding is valid for backend
Killing the postmaster
Smart Shutdown request at Thu Mar 7 11:14:20 2002
This is the ASCII output of the dump for you to check:
-- postgresql-dump on Thu Mar 7 11:14:20 EST 2002 from version 7.1
--
-- pg_dumpall (7.2)
--
\connect template1
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = 'template0');
On the basis of this dump, is it OK to delete the old database? [y/n] n
Seeing as there is several gig of data in the old database, I'm no really
happy with that dump. Any ideas? Which pg_hba.conf file is the postmaster
trying to read?
Please CC responses, I'm not currently subscribed.
Andrew Clark
90East (Asia Pacific) Pty Ltd
Canberra, Australia
02 6272 3700 (switch)
02 6272 3010 (facsimile)
andrew.clark@sge.net
www.90East.com
**********************************************************************
Notice: This e-mail may contain personal information as defined in the
Privacy Act 1988, or confidential information. Please do not disclose
personal information in this e-mail, other than that of the sender, to
another party without the consent of the sender. If you are not the
intended recipient, or believe that you have received this e-mail in error,
please do not print, copy, retransmit, disseminate, or otherwise use the
information. Also, please notify the sender that you have received this
e-mail in error, and delete the copy you received. Thank you.
Reply to: