Search Postgresql Archives

Re: Fwd: Fwd: Problem with pg_dump and decimal mark

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

 



Hi Adrian,

so finally I have a workaround which is ok for me. When I seperate the tables and the data (using the -a and -s switch from pg_dump) into 2 sql backup files, everything works ok on the problem-VM.

I try to investigate further in the coming weeks, I´m on holiday next week.

Regards and thanks for your support,
Eric

2014-12-10 15:27 GMT+01:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 12/10/2014 01:32 AM, Eric Svenson wrote:
So, one more success...

I have taken a part of the backup SQL file which fills the table

COPY dev_my_settings (.....) from stdin;
12345  text   text   0   123.345345

This file ALONE works! (without changing ANYTHING!)

Hmm, almost like the encoding/locale is changing in the complete file.


So if I run the first (huge) SQL file and then the second, which fills
the dev_my_settings table, everything is ok.

FYI if you do a pg_dump using the custom format(-Fc) you have more control over the restore. You can run pg_restore -l against the dump file to get a Table of Contents(TOC), which you can edit by commenting out items you do not want to restore and then feed back to pg_restore via -L. You also have the option to 'restore' all or part of the custom file to a text file using the -f option. The details can be found here:

http://www.postgresql.org/docs/9.3/interactive/app-pgrestore.html


2014-12-10 10:23 GMT+01:00 Eric Svenson <esvenson74@xxxxxxxxxxxxxx


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx

[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