[Live-demo] Re: [OSGeo] #438: Postgres 8.3 install script

[OSGeo]

#438: Postgres 8.3 install script
------------------------+---------------------------------------------------
  Reporter:  darkblueb  |       Owner:  live-demo at lists.osgeo.org
      Type:  defect     |      Status:  new                      
  Priority:  blocker    |   Component:  LiveDVD                  
Resolution:             |    Keywords:                           
------------------------+---------------------------------------------------
Comment (by wildintellect):

 Replying to [comment:2 darkblueb]:
 > cameronshorter fixed the bug with USER=user
 >
 > but now need to set a password/ right after the create user
 >
 > so, put this in a text file anywhere
 >
 > alter role "user" with password 'user'
 >
 > then add to the script  sudo -u postgres pqsl -f /path/to/file

 You shouldn't need to set a password, by default postgres uses ident
 authentication for localhost connections (aka system users). I tested the
 script and it worked for me, but I can see how if the USER variable wasn't
 set right it would cause and issue.

-- 
Ticket URL: <http://trac.osgeo.org/osgeo/ticket/438#comment:4>
OSGeo <http://www.osgeo.org/>
OSGeo committee and general foundation issue tracker.