From: | Todd Turner <tjturner(at)chpc(dot)utah(dot)edu> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | database copy and move |
Date: | 2000-05-03 16:32:57 |
Message-ID: | 391054B9.3DF7A929@chpc.utah.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Hello;
http://www.postgresql.org/doxlist.html noticed there isn't any info in
copy the postgres data - database directory and files and setting up the
same database on another machine. I've tried using createdb then
pgaccess to import tables. Using psql the tables are found but the data
isn't.
When importing a table I'm getting the error Error executing query.
Copy subreservation From "subreservation1'
PostgresSQL error message:
Error: CopyFrom: Fail to add null value in not null attribute username
PostgresSQL
status:PGRES_FATAL_ERR
OR
Also ERROR: Bad int8 external representation for another copy and
somtimes I'm getting you can not copy a duplicate value into a duplicate
key message.
I'd appreciate if someone could turn me on to why I'm getting these
messages and possibly how you can move a database to another machine.
tjt:
--
===========================================
Todd Turner - tjturner(at)chpc(dot)utah(dot)edu
(801 - 585-1266)
Center for High Performance Computing
University of Utah
===========================================
From | Date | Subject | |
---|---|---|---|
Next Message | bangh | 2000-05-03 17:23:40 | Re: database copy and move |
Previous Message | Matthew | 2000-05-03 16:17:24 | Removing NOT NULL Contraint |