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"
11 matches
Mail list logo