PDA

View Full Version : Postgresql 8.3 to 8.4



starf
01-19-2010, 06:50 AM
When i try to restore the DB in 8.4 i get error code 1 in pgadmin:


WARNING: errors ignored on restore: 1

pg_restore: restoring data for table "players"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2071; 0 16549 TABLE DATA players postgres
pg_restore: [archiver (db)] COPY failed: ERROR: invalid byte sequence for encoding "UTF8": 0xf6727065
HINT: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
CONTEXT: COPY players, line 6773

so the players table is not imported correctly

tried backing up and restoring the table players only and got this error:


C:\Program Files\PostgreSQL\8.4\bin\pg_restore.exe -h localhost -p 5432 -U postgres -d "hold" -a -t players -v "D:\playerstable.backup"
pg_restore: connecting to database for restore
pg_restore: restoring data for table "players"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 1935; 0 16549 TABLE DATA players postgres
pg_restore: [archiver (db)] could not execute query: ERROR: column "player_id" of relation "players" does not exist
Command was:
COPY players (player_id, site_id, playername, lastplayeddate, cashhands, tourneyhands, playertype_id) FROM stdin;
WARNING: errors ignored on restore: 1

Process returned exit code 1.


probably just going to stay 8.3, not worth the effort upgrading...

netsrak
01-19-2010, 07:56 AM
When you create a new database in 8.4 you need to use the same coding as the original database.
But i recommend you stay with 8.3 :)