From: | Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: problems transfering databases |
Date: | 2001-08-23 08:18:31 |
Message-ID: | 3B84BC55.59059436@etk.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hello Tom,
thanks for the answer. This is the procedure, how we tried to transfer the
data from one machine to another.
My collegue has used the pg_dumpall command, in the following way:
pg_dumpall > backups/2001-06-04db.out
Since it is a simple test database, the 2001-06-04db.out file was around
40kB, so he has sent it to me via email.
I tried to load the data from the file in two different ways:
psql -f 2001-08-21db.out
cat 2001-06-04db.out | psql
but got the error like stated before. I've tried to do this on Solaris and
Linux (I've set postgreSQL up on my Linux box for testing purposes), but
the same error pops up.
Could it have something to do with the versions of the databases, and how
it was installed? The version I use is
psql (PostgreSQL) 7.1.2 (the output of psql -V command), but I'm not sure
what version did my collegue use (I'll find that out, but I think it is
7.x.x).
Regards,
Miroslav
Tom Lane wrote:
> Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> writes:
> > 'sql:2001-08-21db.out:5: ERROR: copy: line 1, Bad abstime external
> > representation '\N
> > psql:2001-08-21db.out:5: PQendcopy: resetting connection
>
> Given the weird line-wrapping of the message, I'm going to bet that the
> problem is that newlines in the dump file have gotten converted to DOS
> format (ie, \n became \r\n), and COPY is unhappy because it sees the \r
> as part of the data. When it echoes the data it didn't like, the
> presence of the \r messes up the format of the error message.
>
> Not sure *how* that happened in a Linux-to-Solaris transfer, though;
> what tool did you use to transfer the dump file?
>
> regards, tom lane
--
Miroslav Koncar
Software Engineer
Ericsson Nikola Tesla
ETK/D/R
Tel: +385 1 365 3479
Fax: +385 1 365 3548
mailto:miroslav(dot)koncar(at)etk(dot)ericsson(dot)se
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Davis | 2001-08-23 08:18:56 | Re: add, subtract bool type |
Previous Message | will trillich | 2001-08-23 08:18:02 | Re: multiple table indexes |
From | Date | Subject | |
---|---|---|---|
Next Message | Hiroshi Inoue | 2001-08-23 08:34:56 | Re: ODBC include files |
Previous Message | Hiroshi Inoue | 2001-08-23 03:59:30 | Re: odbc + unix sockets |