Re: Really Dumb Question...(Dumping db)

3/20/2001 11:23:19 AM, Joseph Koenig <joe@jwebmedia.com> wrote:

>Alright, Next question. I got the dump out (thanks for all the help).
>Now I can't get it back in on the other server! It keeps telling me
>permission denied to the file itself. I even tried chmod'ing it to 777
>and changing the ownership to postgres.postgres, su to postgres and it
>says "permission denied" when I try to:
>psql -e worldwide < worldwide.pgdump

You must supply a username that has permissions to perform creates and
inserts on the database:

% psql -U postgres -e worldwide < wordwide.pgdump

Brent

---
Brent R. Matzelle
Software Engineer
Information Services
Main Line Health Systems
Tel: 610-240-4566
Pager: 610-640-8437
matzelleb@mlhs.org