Not needed if you are logged in as user postgres in your OS when you enter psql. At least, with the hba_conf file the way it is stock.
But a good point, though. I wonder if I would then have to know the DATABASE password for postgres if I wasn't user postgres in the OS? Dennis Gearon Never, ever approach a computer saying or even thinking "I will just do this quickly." ________________________________ From: Alban Hertroys <haram...@gmail.com> To: Dennis Gearon <gear...@sbcglobal.net> Cc: Adrian Klaver <adrian.kla...@gmail.com>; pgsql-general@postgresql.org Sent: Thu, September 27, 2012 8:13:17 AM Subject: Re: [GENERAL] problem with recreating database with export On 27 September 2012 16:55, Dennis Gearon <gear...@sbcglobal.net> wrote: > <note to future> > To anyone reading this in the future, if you have problems importing a plain > text database export, it is usually impossible to do: > psql -d some_dbase -f the_backup.sql. I don't know why. Looks like you forgot -U postgres -- If you can't see the forest for the trees, Cut the trees and you'll see there is no forest.
