| From: | "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com> |
|---|---|
| To: | "'PostgreSQL-general'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Really Dumb Question...(Dumping db) |
| Date: | 2001-03-21 16:09:32 |
| Message-ID: | 200103211610.f2LGApt03553@mail.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
3/20/2001 11:23:19 AM, Joseph Koenig <joe(at)jwebmedia(dot)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(at)mlhs(dot)org
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Poul L. Christiansen | 2001-03-21 16:20:01 | Re: Cold Fusion/ODBC |
| Previous Message | Michelle Murrain | 2001-03-21 16:08:08 | Cold Fusion/ODBC |