Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

pg_restore: Its not restoring my db

What does it mean I'm trying to restore my postgresql db and here is what I'm getting but I do not see it restore tables/data/

C:\Program Files\PostgreSQL\9.4\bin\pg_restore.exe --host 123-97.compute-1.amazonaws.com --port 5432 --username "username" --dbname "mydb" --no-password --section pre-data --section data --section post-data --schema public --verbose "C:\db\employee.backup"

pg_restore: connecting to database for restore pg_restore: implied data-only restore

Process returned exit code 0.

I'm using Windows 8.1

like image 564
Nick Kahn Avatar asked May 03 '16 23:05

Nick Kahn


1 Answers

I was getting this error while restoring schema backup with different name. When i restored the schema with same name it worked like a charm and then later I renamed it.

Alternative: do pg_restore from a carefully-restricted pg_dump dump and avoid --schema (and possibly even --table) options when using pg_restore.

like image 75
Arinjay Avatar answered Nov 18 '22 19:11

Arinjay