 | |
resend: Trouble with pg_dump in 7.3.4
comp.databases.postgresql.novice comp.databases.postgresql.novice
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
resend: Trouble with pg_dump in 7.3.4 -
07-14-2004
, 02:47 PM
|
I'm using the following to backup a table from a database pg_dump --table=tableName --clean --format p dbName The file produced has all lines preceded by a space. Only the COPY such as this ... COPY rr_config (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o) FROM stdin; 69 2 \N \N mydevice ahash 1 \N \N mydevice#10.86.209.205 \N \N \N 68 63 \. seems to care. I get these errors: ERROR: copy: line 2, Bad numeric input format ' ' lost synchronization with server, resetting connection manually removing the space before the "\." fixes the problem. Is there a workaround? Thanks, Frank |
#2
| |||
| |||
|
|
resend after joining list ... I'm using the following to backup a table from a database pg_dump --table=tableName --clean --format p dbName The file produced has all lines preceded by a space. Only the COPY such as this ... COPY rr_config (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o) FROM stdin; 69 2 \N \N mydevice ahash 1 \N \N mydevice#10.86.209.205 \N \N \N 68 63 \. seems to care. I get these errors: ERROR: copy: line 2, Bad numeric input format ' ' lost synchronization with server, resetting connection manually removing the space before the "\." fixes the problem. Is there a workaround? Thanks, Frank |
Bruce Momjian | http://candle.pha.pa.us
pgman (AT) candle (DOT) pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.