Forum OpenACS Q&A: Re: Problem with Postgres v7.2.3 restore of .dmp
So when I retried the restore I typed the following :
createdb -T template0 dbname
and then ran the restore as before.
All now hunky-dorie.
I think my problem stemmed from the fact that I have password authentication set up in postgres. I think that some of the DML statements in the dump were trying to do something to pre-existing functions in template1 owned by another user.
I post this in case it helps someone sometime!