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
> The restore left you with two empty tables. What happens if you log into
Postgres > via psql and then INSERT one set of values containing floats
into say, >dev_my_settings?
SUCCESS! This works OK!
INSERT INTO dev_my_settings(123, 'test', 'test', 'test', 123, 123.345);
Value 123.345 can be read
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!)
So if I run the first (huge) SQL file and then the second, which fills the
de
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/
Hi Adrian,
here are the results of today:
> How where the Postgres instances installed?
> From a package?
Yes. It is Version 9.2 for Windows, comment of the package is
"The PostgreSQL RDBMS, version 9.2, packaged by EnterpriseDB"
> Compiled and if so with what compiler and what settings?
No
Hi Adrian,
I try to get access to the non-VM machine, at the moment access is not
possible for me unfortunately.
You are right, there are more tables in the database which are restored
correctly but these tables do NOT contain float values. These two tables
are the only tables in the database whi
On 12/08/2014 06:53 AM, Eric Svenson wrote:
Hi Adrian,
I try to get access to the non-VM machine, at the moment access is not
possible for me unfortunately.
You are right, there are more tables in the database which are restored
correctly but these tables do NOT contain float values. These two
On 12/08/2014 06:53 AM, Eric Svenson wrote:
Hi Adrian,
I try to get access to the non-VM machine, at the moment access is not
possible for me unfortunately.
You are right, there are more tables in the database which are restored
correctly but these tables do NOT contain float values. These two
On 12/08/2014 12:21 AM, Eric Svenson wrote:
Hi Adrian,
here are the results of today:
> How where the Postgres instances installed?
> From a package?
Yes. It is Version 9.2 for Windows, comment of the package is
"The PostgreSQL RDBMS, version 9.2, packaged by EnterpriseDB"
> Compiled a
On 12/05/2014 01:13 AM, Eric Svenson wrote:
Hi Adrian,
Is the above how the message was actually presented or has a partialtranslation
taken >place? Just asking because it would seem to indicate
further confusion about the locale.
This is an exact copy of the screen contents, no translatio
Hi Adrian,
>Is the above how the message was actually presented or has a partial
translation taken >place? Just asking because it would seem to indicate
further confusion about the locale.
This is an exact copy of the screen contents, no translation by me has
taken place. Indeed strange, "ERROR"
On 12/04/2014 02:01 AM, Eric Svenson wrote:
So what if you load to the VM Postgres using the psql from the host?
I tried that: On the host I started psql with
psql -h 192.168.2.55 -U postgres -p 5432 my_Database < myFile.sql
I get the same error
ERROR: invalid input syntax for type double pre
> So what if you load to the VM Postgres using the psql from the host?
I tried that: On the host I started psql with
psql -h 192.168.2.55 -U postgres -p 5432 my_Database < myFile.sql
I get the same error
ERROR: invalid input syntax for type double precision "0.2"
KONTEXT: COPY dev_my_settings, l
On 12/03/2014 12:23 AM, Eric Svenson wrote:
Hi Adrian,
thank you for your support. Here are the informations you requested
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 S
Hi Adrian,
thank you for your support. Here are the informations you requested
> 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_NUME
On 11/29/2014 12:25 AM, Eric Svenson wrote:
Seems you have a locale mismatch issue. The dump is coming
from a locale
where a '.' is the decimal mark and is being restored to a
locale where
',' is the mark. Look at what the locales are
Seems you have a locale mismatch issue. The dump is coming from a locale
>>> where a '.' is the decimal mark and is being restored to a locale where
>>> ',' is the mark. Look at what the locales are the machines that work and
>>> the one that does not.
>>>
>>
>>
I have already done that and found s
On 11/28/2014 02:08 PM, Tom Lane wrote:
Adrian Klaver writes:
On 11/28/2014 05:35 AM, Eric Svenson wrote:
I have done a backup of a postgres database on a virtual machine
(Windows 8.1) using pg_dump.
On another (non-virtual) machine the restore (with psql) worked without
problems.
On the thi
Adrian Klaver writes:
> On 11/28/2014 05:35 AM, Eric Svenson wrote:
>> I have done a backup of a postgres database on a virtual machine
>> (Windows 8.1) using pg_dump.
>>
>> On another (non-virtual) machine the restore (with psql) worked without
>> problems.
>>
>> On the third virtual machine, h
On 11/28/2014 05:35 AM, Eric Svenson wrote:
Hello,
I have done a backup of a postgres database on a virtual machine
(Windows 8.1) using pg_dump.
On another (non-virtual) machine the restore (with psql) worked without
problems.
On the third virtual machine, however, the restore fails.
(ERROR:
Hello,
I have done a backup of a postgres database on a virtual machine (Windows
8.1) using pg_dump.
On another (non-virtual) machine the restore (with psql) worked without
problems.
On the third virtual machine, however, the restore fails.
(ERROR: invalid input syntax for type double precision
21 matches
Mail list logo
