Postgresql 8.2 Data dump to Postgresql 10
NickName:Rehmat Alam Ask DateTime:2020-04-02T12:37:44

Postgresql 8.2 Data dump to Postgresql 10

I have two servers

  1. Windows Xp (running Postgresql 8.2)
  2. Ubuntu TLS 18.o (running Postgresql 10)

I have a table which contains blob data of images and fingerprints in PostgreSQL 8.2. Application was built on VB6.

I migrated the database dump to PostgreSQL 10 but when the application is at the login screen it verifies from BlOB returned from the database, but the migrated data returned BLOB is not verifying with captured blob from the thumb machine digital persona. But if application is run with PostgreSQL 8.2 it connects but with migrated data to PostgreSQL 10 it doesn't.

Can anyone tell me what seems to be the problem here?

Copyright Notice：Content Author:「Rehmat Alam」，Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article：https://stackoverflow.com/questions/60984313/postgresql-8-2-data-dump-to-postgresql-10

Products recommended by Amazon
More >>>
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
SanDisk 128GB microSDXC-Card, Licensed for Nintendo-Switch - SDSQXAO-128G-GNCZN
 HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
HUANUO Dual Monitor Stand - Adjustable Spring Monitor Desk Mount Swivel Vesa Bracket with C Clamp, Grommet Mounting Base for 13 to 27 Inch Computer Screens - Each Arm Holds 4.4 to 14.3lbs
 AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
AMD Ryzen 5 5600X 6-core, 12-Thread Unlocked Desktop Processor with Wraith Stealth Cooler
 Timberland Men's 6-Inch Premium Waterproof Boot
Timberland Men's 6-Inch Premium Waterproof Boot
More about “Postgresql 8.2 Data dump to Postgresql 10” related questions
Postgresql 8.2 Data dump to Postgresql 10

I have two servers Windows Xp (running Postgresql 8.2) Ubuntu TLS 18.o (running Postgresql 10) I have a table which contains blob data of images and fingerprints in PostgreSQL 8.2. Application was

Show Detail
pg_dump from view has no data in postgresql 10

pg_dump --table=export_view --data-only --column-inserts mydb > export_view.sql pg_dump (PostgreSQL) 10.7 (Ubuntu 10.7-1.pgdg18.04+1) Export specific rows from a PostgreSQL table as INSERT SQL

Show Detail
uuid-ossp module for PostgreSQL 8.2 to generate UUID

I am trying to generate UUID in PostgreSQL 8.2. From the documentation I found uuid-ossp module can generate UUID but it supports only PostgreSQL 9+. Is there any way to use this uuid-ossp module in

Show Detail
How to find dead tuples (fragmentation) in PostgreSQL 8.2 ( for Greenplum)?

I want to find dead tuples and live tuples of tables in PostgreSQL 8.2. We have just started with Greenplum MPP Database system which is based on PostgreSQL 8.2. Because of default MVCC architect...

Show Detail
Connecting with PostgreSQL 8.2 using Java

When I'm connecting to my database (PostgreSQL 8.2) through JDBC it gives an error ClassNotFound and something related to drivers. How do I fix this?

Show Detail
Convert PostgreSQL SQL dump to PostgreSQL custom-format dump

My use case is the following: I have PostgreSQL dumps made with pg_dump -F p (plain-text SQL script file), which I have no control over how they're made I like pg_restore flexibility (--no-owner, ...

Show Detail
Dump postgresql without files data

We are saving in Postgresql 9.4 files in column bytea. Is it possible to dump database without data of such columns? or whiout specific table?

Show Detail
Easy way to view postgresql dump files?

I have a ton of postgresql dump files I need to peruse through for data. Do I have to install Postgresql and "recover" each one of them into new databases one by one? Or I'm hoping there's a postgr...

Show Detail
Data migration from PostgreSQL 9.2 to PostgreSQL 10

I want to migrate data from PostgreSQL 9.2 to PostgreSQL 10. Please, suggest the best way to data migration from old to new versions of PostgreSQL.

Show Detail
Not able to run block in PostgreSQL 8.2

I can't run this block in PostgreSQL 8.2. DECLARE curtime char; BEGIN curtime := 'now'; INSERT INTO logtable VALUES (logtxt, curtime); RETURN curtime; END; When I...

Show Detail