Postgres Pro
Downloads
Home   >   mailing lists

Re: dump using copy failed - Mailing list pgsql-admin

From Raghavendra
Subject Re: dump using copy failed
Date
Msg-id CA+h6AhhYFKfqF-MHQCKaY8pudn9GfwgoehhO7xor1oLruRKQxg@mail.gmail.com
Whole thread Raw
In response to Re: dump using copy failed  (Ankur Kaushik <ankurkaushik@gmail.com>)
Responses Re: dump using copy failed
List pgsql-admin
Tree view
On Fri, Jun 26, 2015 at 3:01 PM, Ankur Kaushik <ankurkaushik@gmail.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

pgsql-admin by date:

Previous
From:
Date:
Subject: Re: select query of mysql to postgres
Next
From: Matheus de Oliveira
Date:
Subject: Re: select query of mysql to postgres