DB migration from Win (cygwin) to Linux (RH 7.2): 9223372036854775807 error
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
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.