From: | Miroslav Koncar <miroslav(dot)koncar(at)etk(dot)ericsson(dot)se> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problems transfering databases |
Date: | 2001-08-22 13:20:04 |
Message-ID: | 3B83B183.386063CA@etk.ericsson.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hello,
I'm a newbie in the postgreSQL world, so if I'm asking what's rather
straightforward, I appologize.
This is what I'm trying to do: my collegue and I have set up three
postgreSQL databases; he has set it up on Linux RedHat 6.2, and I've
been working on RedHat 6.2 as well on Solaris 7. We are trying to
transfer all the data from his database to mine (my primary database is
on Solaris). So, we consulted the docs, and he has used the command:
pg_dumpall > backups/2001-06-04db.out
and sent me that file. But, when I try to load it to my database, I get
the error message:
obonjan[postgres-> ~/tmp]%psql -f 2001-08-21db.out
You are now connected to database template1.
SELECT
DELETE 0
DROP
'sql:2001-08-21db.out:5: ERROR: copy: line 1, Bad abstime external
representation '\N
psql:2001-08-21db.out:5: PQendcopy: resetting connection
I thougth, it might be something to do with Solaris, but on Linux, like
expected, the same error.
What amd I doing wrong? Please, contact me directly, since I'm not on
the mailing list.
Thanks,
Miroslav
From | Date | Subject | |
---|---|---|---|
Next Message | jose | 2001-08-22 13:21:49 | SELECT FOR UPDATE |
Previous Message | Bruce Momjian | 2001-08-22 13:08:51 | Re: maximum query length |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-08-22 13:59:22 | Re: ODBC connection stopped working. |
Previous Message | Neal Lindsay | 2001-08-22 09:50:12 | Re: ODBC connection stopped working. |