problems transfering databases

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

Responses

Browse pgsql-general by date

  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

Browse pgsql-odbc by date

  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.