Re: upgrading to postgresql 7.1

["Oliver Elphick" <olly@lfix.co.uk>]

Brian May wrote:
  >>>>>> "Zed" == Zed Pobre <zed@resonant.org> writes:
  >
  >    Zed>     su to postgres first, then recreate accounts for all the
  >    Zed> users that you had before (if someone knows a decent way to
  >    Zed> do this automatically, please let me know).  Set your
  >    Zed> pg_hba.conf to blind trust mode. 
  >
  >How do I do this? What is blind trust mode?
  >
  >I couldn't find any help for pg_hba.conf, as I don't know where to
  >look.

pg_hba.conf is self-documented.

"blind trust" is:

    local all trust

for UNIX socket access, or

    host 127.0.0.1 255.0.0.0 trust

for TCP/IP access from localhost.

"trust" authentication means that anyone is allowed to connect as any
PostgreSQL user without authentication or restriction.

-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47  6B 7E 39 CC 56 E4 C1 47
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "But where shall wisdom be found? And where is the
      place of understanding? It cannot be gotten for gold,
      neither shall silver be weighed for the price thereof.
      Whence then cometh wisdom? and where is the place of
      understanding? ...Behold the fear of the Lord, that is
      wisdom; and to depart from evil is understanding."    
                                         Job 12,15,20,28