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
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
.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With