I have already done that and found something strange:
On the PC where the backup was done with pg_dump, all locale settings of
Postgres were English/United States. (LC_COLLATE, LC_CTYPE, LC_MONETARY,
LC_NUMERIC in postgresql.conf)
> OS and OS version?
Windows Server 2012R2
> Postgres version?
Version 9.2.1 (same version used on all machines)
> What was the pg_dump command used?
pg_dump -p 6789 -EUTF8 -f myFile.sql my_Database
On the first PC on which I tried to load the backup file with psql, all
locale settings if Postgres were German_Germany. Everything is ok, the
SQL file with '.' as decimal point was accepted without a problem
> OS and OS version?
Windows 7 Enterprise SP 1
> Postgres version?
Version 9.2.1 (same version used on all machines)
> How was it loaded via psql?
psql -p 6789 -U postgres my_Database < myFile.sql
> Was the psql on the same machine and from the same version of Postgres?
Same version, but on different machines.
On the second PC (Virtual Machine) I had the SAME settings in
postgresql.conf (German_Germany)
> OS and OS version?
Windows 7 Ultimate SP 1
> Postgres version?
Version 9.2.1 (same version used on all machines)
> How was it loaded via psql?
psql -p 6789 -U postgres my_Database < myFile.sql
> Did you use the psql on the VM or did you use the psql on the host?
psql on the VM
> Was the Postgres/psql on the host the same as the VM?
Same Version (9.2.1)
> What are you using for virtualization?
VM Ware Player 6.0.2
> What is host OS?
Windows 7 Enterprise SP 1 (see above)
Again, thank you for the support.
Regards,
Eric Svenson
