Re: DATA RESTORE PGADMINIII

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