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) [EMAIL PROTECTED] 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.
