PostgreSQL version 9.4Both server is centos 6.6
Thank you for sharing the information. Yes, I have test the sample case on same two CentOS machines.
Dump file is attached . which I am facing error to restore
I have tried to restore your Dump file on my machine and couldn't able to reproduce the error you are getting.
-bash-4.2$ gunzip < /tmp/bus_stop_42.dump.gz | PGPASSWORD='edb' psql -U postgres -h localhost demo
SET
SET
SET
SET
SET
SET
SET
ERROR: relation "public.bus_stop" does not exist
ERROR: relation "public.bus_stop" does not exist
ERROR: relation "public.bus_stop" does not exist
ERROR: relation "public.bus_stop" does not exist
ERROR: sequence "bus_stop_bus_stop_id_seq" does not exist
ERROR: table "bus_stop" does not exist
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE SEQUENCE
ALTER TABLE
ALTER SEQUENCE
ALTER TABLE
COPY 531
setval
--------
550
(1 row)
ALTER TABLE
ERROR: relation "point_type" does not exist
ERROR: relation "org_chart" does not exist
-bash-4.2$
Its a blind guess, Did .gz file copied from other Operating system to source machine ?
--Raghav
