Search Postgresql Archives

Re: Syntax error when restoring database from dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



My mistake. Sorry for the noise.

Regards, Clodoaldo

2008/4/12, Clodoaldo <clodoaldo.pinto.neto@xxxxxxxxx>:
> I dumped the db with:
>  pg_dump -C -f dbname.dump
>
>  $ uname -a
>  Linux myhost.mydomain.net 2.6.22.14-72.fc6 #1 SMP Wed Nov 21 14:10:25
>  EST 2007 x86_64 x86_64 x86_64 GNU/Linux
>
>  Postgresql 8.2.7
>
>  And restored in another machine:
>  $ uname -a
>  Linux dkt 2.6.24.4-64.fc8 #1 SMP Sat Mar 29 09:54:46 EDT 2008 i686
>  athlon i386 GNU/Linux
>
>  psql -e -a -f dbname.dump
>
>  Then this error message:
>  --
>  -- PostgreSQL database dump complete
>  --
>  psql:dbname.dump:58464: ERROR:  syntax error at or near "rustyzs"
>  LINE 1: rustyzs Rafael Rodrigues 25260 rafaelcosta_arq@xxxxxxxxxxx 2...
>
>  This is where the error is:
>
>  zezetecoteco    Jose Eduardo de Arruda  3972    je.arruda@xxxxxxxxxxx
>   21622370678     51      200.147.105.26  2007-05-13 18:21:32.52224
>  2+00   ;\\007\\337\\302\\330\\343Q\\000\\221\\343\\030n\\344\\312\\016\\205\\025y\\214\\377
>    2990    t       f       0
>  rustyzs Rafael Rodrigues        25260   rafaelcosta_arq@xxxxxxxxxxx
>   22819672809     622     201.1.6.164     2007-06-25 17:43:19.066936+00
>   5\\032\\306\\313\\374\\2664\\004\\222c\\377.W\\216Y\\245\\337\\006+\\222
>        9668    t       f       0
>  domingues       joão batista domingues  17503
>  domingues_domingues@xxxxxxxxxxx        00861372808     709
>  201.13.142.146  2007-07-01 18:09:17.644706+00
>  ,,\\252yS\\337\\211\\273\\034TJV9/\\303\\330[/o\\251    9094    t
>   f       0
>
>  I can't see what the error is. The source database is working
>  correctly and selecting the offending row raises no problem. I tried
>  dumping and downloading again but same error.
>
>  Regards, Clodoaldo
>

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux