| Lists: | pgsql-bugs |
|---|
| From: | "AbdulShukoor Mohammed" <mashukoor(at)OXFORDEA(dot)COM> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | DATA RESTORE PGADMINIII |
| Date: | 2016-04-21 13:28:01 |
| Message-ID: | 50F88BDA2EA46648827F8B9625EFDCE4667528@mail.OXFORDEA.COM |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
Getting following error while restoring DATA from PGSQL folder:
C:\Program Files\PostgreSQL\9.5\pgsql\bin\pg_restore.exe --host
localhost --port 5432 --username "postgres" --dbname "servicedesk"
--role "postgres" --no-password --format directory --verbose
"C:\Program Files\PostgreSQL\9.5\pgsql"
pg_restore: [directory archiver] could not open input file "C:\Program
Files\PostgreSQL\9.5\pgsql/toc.dat": No such file or directory
Process returned exit code 1.
Regards,
AbdulShukoor Mohammed
GM-IT | www.oxfordea.com <http://www.oxfordea.com/>
Mobile: +966 (0) 554431667
eMail <mailto:mashukoors(at)gmail(dot)com> | LinkedIn
<https://sa.linkedin.com/pub/abdulshukoor-mohammed/2b/a92/974>
| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: DATA RESTORE PGADMINIII |
| Date: | 2016-04-21 21:18:32 |
| Message-ID: | 571943A8.2040903@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | Postg토토SQL : Postg토토SQL 메일 링리스트 : 2016-04-21 이후 PGSQL-BUGS 21:18 |
On 4/21/2016 6:28 AM, AbdulShukoor Mohammed wrote:
>
> Getting following error while restoring DATA from PGSQL folder:
>
> */C:\Program Files\PostgreSQL\9.5\pgsql\bin\pg_restore.exe --host
> localhost --port 5432 --username "postgres" --dbname "servicedesk"
> --role "postgres" --no-password --format directory --verbose
> "C:\Program Files\PostgreSQL\9.5\pgsql"/*
>
> */pg_restore: [directory archiver] could not open input file
> "C:\Program Files\PostgreSQL\9.5\pgsql/toc.dat": No such file or
> directory/*
>
> *//*
>
where was your backup stored by pg_dump? "--format directory" doesn't
get used much (I prefer --format compressed), but it generates a whole
series of dat files in a given directory. the backup CERTAINLY
shouldn't have been stored anywhere in the \Program Files\Postgresql
directory
--
john r pierce, recycling bits in santa cruz