From: | "Jason Tan Boon Teck" <tanboonteck(at)gmail(dot)com> |
---|---|
To: | "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: pg_restore and pgadmin3 |
Date: | 2007-09-11 04:01:01 |
Message-ID: | dd8f6c970709102101qcf00ebcl21ecf9ce8b5b1c75@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hi Andrej,
Thanks for the advice. I was using the backup files owned as postgres group.
Now that i've changed ownership to postgres as well, i can now restore.
Thanks again.
jason
On 9/9/07, Andrej Ricnik-Bay <andrej(dot)groups(at)gmail(dot)com> wrote:
>
> On 9/8/07, Jason Tan Boon Teck <tanboonteck(at)gmail(dot)com> wrote:
> > Hi,
> Hi
>
> > pg_restore -dmydb --disable-triggers mydb.backup
> >
> > i get
> >
> > pg_restore: [archiver] could not open input file: Permission denied.
> >
> > How do i restore the backup file correctly?
> By correcting the file permissions.
> Is that on a Linux/Unix box? If so, what does
> ls -l mydb.backup
> say?
>
>
> > Thanks
> Cheers,
> Andrej
> --
> Please don't top post, and don't use HTML e-Mail :} Make your quotes
> concise.
>
> http://www.american.edu/econ/notes/htmlmail.htm
>
--
Jason Tan Boon Teck
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2007-09-11 04:28:34 | Re: Returning multiple values from a function |
Previous Message | Keith Worthington | 2007-09-11 03:54:06 | Returning multiple values from a function |