EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

pg_restore problem: extra data after last expected column  XML

Forum Index » Tuning and Migration Wizard
Author Message
Federico_Belotti

New member

Joined: 18 Jun 2010 10:41:25
Messages: 4
Offline

Dear All,

I've the same problem with postgreSQL 8.4. When I try to restore a .backup file created with pg_dump (by using the pg_restore procedure)
I get the error "Extra data after last expected column". I suspect that is a problem of encoding or delimiters. Can you help me?

here is the log:

2010-06-18 17:13:19 CEST ERROR: language "plpgsql" already exists
2010-06-18 17:13:19 CEST STATEMENT:
CREATE PROCEDURAL LANGUAGE plpgsql;
2010-06-18 17:24:26 CEST ERROR: extra data after last expected column
2010-06-18 17:24:26 CEST CONTEXT: COPY cart_accert, line 3084737: "\N N \N \N \N 0 785 \\N N \N \N \N41-21 100oRI\N \N 0 2952 MW67J@Y9[WER¶ 2000-01-25 2000-02-11 1..."
2010-06-18 17:24:26 CEST STATEMENT: COPY cart_accert (num_ese, ac_prn, ac_prezzo, ac_query, stampato, ac_out, ac_paga, ac_scad, ac_ripe, ac_code, ac_nt_code, ac_nt_fonte, ac_norma, ac_um, indotto, cod_ese, codificato, codice, data_open, data_upd, time_last, rowid, ora, userid, pb_code, ac_des, ac_val, ac_mem, ac_ese, ac_tipo, euro, rowid_master, ur_pb_id, data_richiesta, evidenza_referto, ritornato) FROM stdin;
2010-06-18 17:24:26 CEST LOG: could not send data to client: No connection could be made because the target machine actively refused it.

2010-06-18 17:24:26 CEST LOG: could not receive data from client: No connection could be made because the target machine actively refused it.

2010-06-18 17:24:26 CEST LOG: incomplete message from client



Many thanks,

Federico
Vibhor_K

Senior member
[Avatar]

Joined: 3 Jul 2009 09:46:15
Messages: 444
Offline

Please share following information:
1. Exact command of pg_dump and pg_restore.
2. Exact version of Source and Target database (using command: select version();)
3. Are those tables already exists in target database?

Also, please try to restore dump using -c switch of pg_restore command

Thanks & Regards,
Vibhor Kumar
Blog:http://vibhork.blogspot.com
[Email] [WWW]
 
Forum Index » Tuning and Migration Wizard
Go to:   
Powered by JForum 2.1.8 © JForum Team