postgresql - Restoring database according to Postgres Guide -


i trying follow postgres guide, think there issues following restore command.

pg_restore --verbose --clean --no-acl --no-owner -h localhost example.dump 

it's missing target database isn't it?

however running following command introduces lot of errors,

pg_restore --verbose --clean --no-acl --no-owner -h localhost -d pgguide example.dump 

even though command above works, think data restored incomplete. realised in user schema, can't see first_name or last_name shown in postgres guide.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -