Re: Have problems with 7.1 -> 7.2 upgrade - Mailing list pgsql-general

Don't worry, fixed it...  Copied /etc/postgresql/pg_hba.conf.dpkg-old over
/etc/postgresql/pg_hba.conf and everything started working...  I'm a bit
confused as to why though, seeing as they both contain the same three
lines...

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.



-----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-----



|---------+---------------------------------->
|         |           Darren Ferguson        |
|         |           <darren@crystalballinc.|
|         |           com>                   |
|         |           Sent by:               |
|         |           pgsql-general-owner@pos|
|         |           tgresql.org            |
|         |                                  |
|         |                                  |
|         |           07/03/2002 11:18       |
|         |                                  |
|---------+---------------------------------->

>------------------------------------------------------------------------------------------------------------------------------|
  |
        | 
  |       To:       <andrew.clark@sge.net>
        | 
  |       cc:       <pgsql-general@postgresql.org>
        | 
  |       Subject:  Re: [GENERAL] 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.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.
>
>
>
> -----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




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org