DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error

Started by Aurangzeb M. Aghaover 23 years ago2 messagesgeneral
Jump to latest
#1Aurangzeb M. Agha
aagha@bigfoot.com

I'm having an issue moving my DB from from Win (Cygwin) to Linux 7.2. If
I go from Linux to Cygwin, no probs, everything works fine, creates a new
database beautifully.

However, if I take the exact same DB (which contains data) and try the
following on Linux:

%> psql -d cmsdb -f cmsdb.sql

I get the following:

psql:cmsdb.sql:12: ERROR: parser: parse error at or near
"9223372036854775807"
psql:cmsdb.sql:27: NOTICE: CREATE TABLE/PRIMARY KEY will create implicit
index 'ratingcontentandtype_pkey' for table 'rating'

Any table with a serial decleration has this problem, and the serial
tables don't get built. I wondered if this was due to a MAXINT issue on
Linux, so I wrote a small C program wher I found out that the MAXINT and
LONG are both: 2147483647 -- The catch is that the same is true on my Win
box.

What's going on here, and what can I do to get around this problem?

We're on Postgres 7.1.

Thx,
Aurangzeb

--
aagha <at> bigfoot <dot> com

#2Shridhar Daithankar
shridhar_daithankar@persistent.co.in
In reply to: Aurangzeb M. Agha (#1)
Re: DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error

On 1 Nov 2002 at 8:33, aagha@bigfoot.com wrote:

I'm having an issue moving my DB from from Win (Cygwin) to Linux 7.2. If
I go from Linux to Cygwin, no probs, everything works fine, creates a new
database beautifully.

However, if I take the exact same DB (which contains data) and try the
following on Linux:

%> psql -d cmsdb -f cmsdb.sql

I get the following:

psql:cmsdb.sql:12: ERROR: parser: parse error at or near
"9223372036854775807"

Is that last field in that line? You are running into \r\n problem. Try some
simple scripts or dos2unix etc to convert the dump to unix style. There was a
sed one liner posted on the list few days back..

Bye
Shridhar

--
Williams and Holland's Law: If enough data is collected, anything may be proven
by statistical methods.