Re: Have problems with 7.1 -> 7.2 upgrade

The first thing i notice is that the default port for postgres is wrong
unless you have changed it.

You have it looking -p 5431 instead of 5432.

As for the pg_hba.confcould you post it to the list so we can look at it.

Remove any security information that may be in the file about your system
:-)

Thanks

Darren Ferguson

> I'm having problems upgrading from 7.1 to 7.2. I'm using a Debian
> package, which says to run:
>
> su - postgres
> postgresql-dump -t db.out -dcivlp $PGDATA/../data.save
>
> When I run this, I get the following:
>
> $ postgresql-dump -t /billing/dump_database/db.out -dcivlp
> $PGDATA/../data.save
> Stopping and restarting the postmaster
> /usr/lib/postgresql/dumpall/7.1/postmaster -D /var/lib/postgres/data
> -p 5431 -o -d0
> /usr/lib/postgresql/dumpall/7.1/postmaster: PostmasterMain: initial
> environ dump:
> -----------------------------------------
> PWD=/var/lib/postgres
> PAGER=less
> HZ=100
> USER=postgres
> MAIL=/var/spool/mail/postgres
> BINDIR=/usr/lib/postgresql/dumpall/7.1
> EDITOR=vim
> LOGNAME=postgres
> SHLVL=2
> SHELL=/bin/sh
> PGLIB=/usr/lib/postgresql
> TERM=screen-w
> HOME=/var/lib/postgres
> PGDATA=/var/lib/postgres/data
> PATH=/usr/lib/postgresql/bin:/bin:/usr/bin
> PGDATESTYLE=EURO
> _=/usr/lib/postgresql/dumpall/7.1/postmaster
> -----------------------------------------
> invoking IpcMemoryCreate(size=534396928)
> FindExec: found "/usr/lib/postgresql/dumpall/7.1/postmaster" using
> argv[0] /usr/lib/postgresql/dumpall/7.1/postmaster: reaping dead
> processes... Dumping the database to /billing/dump_database/db.out
> /usr/lib/postgresql/bin/pg_dumpall
> connected to template1...
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> process_hba_record: invalid syntax in pg_hba.conf file
> Missing or erroneous pg_hba.conf file, see postmaster log for details
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling writing 5
> psql: Missing or erroneous pg_hba.conf file, see postmaster log for
> details Finding the default encoding
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling reading 5
> process_hba_record: invalid syntax in pg_hba.conf file
> Missing or erroneous pg_hba.conf file, see postmaster log for details
> /usr/lib/postgresql/dumpall/7.1/postmaster: ServerLoop:
> handling writing 5
> 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 10:36:06 2002
> This is the ASCII output of the dump for you to check:
>
> -- postgresql-dump on Thu Mar 7 10:36:06 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');
>
> /usr/lib/postgresql/dumpall/7.1/postmaster: reaping dead processes...
> On the basis of this dump, is it OK to delete the old database? [y/n] n
>
>
> My pg_hba.conf file is the stock one supplied with the package. Any
> ideas on how to fix this?
>
> Andrew Clark
> 90East (Asia Pacific) Pty Ltd
> Canberra, Australia
>
>
> 02 6272 3700 (switch)
> 02 6272 3010 (facsimile)
>
>
> andrew(dot)clark(at)sge(dot)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.
>
>
>
> -----BEGIN PGP PUBLIC KEY BLOCK-----
> Version: PGP 7.1
>
> mQGiBDwirksRBADcDwp1Ufx9DXVaZIIt36nOvQNl+0LhDQ/vDFIhAl6uzywXVEy/
> v5oITQcbSjwOHNzRCqdcln+1JPgAIf0uL1npk1cWiwwhTEZ7orGF+rxzAizjuwwz
> LXN81Vo/swHPe0EMHdmPJaCwgmIKzJxN5QEL7MdLKfW800NgruhfafqH9QCg/7Br
> 0CmVmnqHI77mvqMzD60M3XUD/1gUvQIjaBT35K32r8by5DaLtamiok9dvtq/rUQE
> 6yFQOiHrLWYkI1tStjiggc4ph+kEJOcuy/vLFIyrmXtaBRKLvf9G79S14nEjAoXJ
> Gbrkx5nD6V5sSzkWdWAvjs+by5WTmLx4EkKJn34Cb+zY7m/arb03EW+/X4y+jMFz
> RqxMBACFmagdfleGIQDWG8Nk7a31USDmuXyK33ex1x5MWGfx3Jl40mKMxRqEBG7Z
> Em+Tiw0t8BSk+9lJEXITAWYY/8sE9Tr12bAhDGwiCRHK4MilrRiHti87ooZ4Neaf
> 6beTTedgIaVrdEmCR7DPpNuyxYYWeVfKTSrz2R/MqgbPJx4UK7QuQW5kcmV3IEph
> bWVzIEZlbm4gQ2xhcmsgPGFuZHJldy5jbGFya0BzZ2UubmV0PokAWAQQEQIAGAUC
> PCKuSwgLAwkIBwIBCgIZAQUbAwAAAAAKCRBYTWlYuV6jywqgAKDg7t6dvJytVrtq
> Po95v/+jKqO32gCgylAJ9mW4ON+5OYoBM61uTR4GSdS5Ag0EPCKuSxAIAPZCV7cI
> fwgXcqK61qlC8wXo+VMROU+28W65Szgg2gGnVqMU6Y9AVfPQB8bLQ6mUrfdMZIZJ
> +AyDvWXpF9Sh01D49Vlf3HZSTz09jdvOmeFXklnN/biudE/F/Ha8g8VHMGHOfMlm
> /xX5u/2RXscBqtNbno2gpXI61Brwv0YAWCvl9Ij9WE5J280gtJ3kkQc2azNsOA1F
> HQ98iLMcfFstjvbzySPAQ/ClWxiNjrtVjLhdONM0/XwXV0OjHRhs3jMhLLUq/zzh
> sSlAGBGNfISnCnLWhsQDGcgHKXrKlQzZlp+r0ApQmwJG0wg9ZqRdQZ+cfL2JSyIZ
> Jrqrol7DVekyCzsAAgIIAMADIRLh9SEV25Kvec/MwMVcFXkSKgUOO8DnSTuf0mIP
> Trl6ikx0doCauSbMh/6ASUJIBNFfy+n56j7Zw7b4r91Mk4RFbe0noGjSeb5TKUD6
> imZCcfBYCfLuotCekEUAok7Ac+XWBO05HSKSFenDqZkk2UHqwqBTz2sSyKYqtmzl
> YURrXeCgOVYlQqbPLLdnSQkdwJ4go7fLjVPKQ8aaJw3AmxTdRpaD9x29DCMiKvxK
> ZHNLjS7+f+0VxRDgZLf2HorVMMAXt3apR9PmR4pquvk+oGRSSI6q2gx50MwJfzkl
> Sytjb/enSejEHOZZMT4dYpJjIFet+BXQmSIawwJXLgeJAEwEGBECAAwFAjwirksF
> GwwAAAAACgkQWE1pWLleo8v0RgCfZ3Xt43lblTCSw3e1JeWjfrltKZEAn1sNTNaS
> LNQgT7pD11ifhyFhhpuS
> =v+xm
> -----END PGP PUBLIC KEY BLOCK-----
>
>
>
>
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: Have you searched our list
> archives?
>
> http://archives.postgresql.org