From: | Dennis Gearon <gearond(at)sbcglobal(dot)net> |
---|---|
To: | Alban Hertroys <haramrae(at)gmail(dot)com> |
Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: problem with recreating database with export |
Date: | 2012-09-27 15:48:47 |
Message-ID: | 1348760927.10217.YahooMailRC@web181001.mail.ne1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 <haramrae(at)gmail(dot)com>
To: Dennis Gearon <gearond(at)sbcglobal(dot)net>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>; pgsql-general(at)postgresql(dot)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 <gearond(at)sbcglobal(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Chris Curvey | 2012-09-27 17:44:05 | Re: unc paths, like and backslashes on 8.4 |
Previous Message | Alban Hertroys | 2012-09-27 15:13:15 | Re: problem with recreating database with export |