Re: [GENERAL] PQputline error with pg_restore

2006-02-09 Thread Tom Lane
Jennifer I Drake/O/VCU <[EMAIL PROTECTED]> writes: > ERROR: copy: line 178286, overflow on numeric ABS(value) >= 10^3 for field > with precision 5 scale 3 It would seem that you've got an incorrect (too large) value in a numeric field in the dumped data. It's not clear how you got into this stat

Re: [GENERAL] PQputline error with pg_restore

2006-02-09 Thread Jennifer I Drake/O/VCU
The postmaster stderr was being sent to /dev/null, so I changed that and was able to generate a log file.  Unfortunately, I'm not sure what the output in the log file means - I don't have a lot of experience with this sort of thing and would greatly appreciate any help.  Here's the info from the lo

Re: [GENERAL] PQputline error with pg_restore

2006-02-09 Thread Tom Lane
Jennifer Drake <[EMAIL PROTECTED]> writes: > I am running PostgreSQL 7.3.2 on Mandrake 9.1 You should really update to something more current than 7.3.2 :-( > pg_restore: [archiver(db)] error returned by PQputline > pg_restore: *** aborted because of error The first thing to do is get more info

[GENERAL] PQputline error with pg_restore

2006-02-09 Thread Jennifer Drake
Hello, I am running PostgreSQL 7.3.2 on Mandrake 9.1 I created a database archive using pg_dump (pg_dump -Ft -v -R oral > dbarchive200106.tar). When I try to restore this database with pg_restore on a new system (pg_restore -d oral -R -v dbarchive200106.tar), I get the following error: pg_