Re: dump using copy failed

On Fri, Jun 26, 2015 at 3:01 PM, Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
wrote:

>
> PostgreSQL version 9.4
>
> Both 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