Re: [GENERAL] could not migrate 8.0.13 database with large object data to 9.5.1

2016-03-02 Thread John R Pierce
On 3/2/2016 12:29 AM, Magnus Hagander wrote: How large is the total database? The earliest versions of pg on Windows had bugs in pg_dump for files larger than 2GB. I don't recall exactly when they were fixed, but this was a long time ago.. Through if my memory is correct the actual bugs were in

Re: [GENERAL] could not migrate 8.0.13 database with large object data to 9.5.1

2016-03-02 Thread Magnus Hagander
On Mar 2, 2016 06:01, "John R Pierce" wrote: > > (thread moved from pg_bugs) > (upgrading a 8.0.13 database on Windows XP 32bit to 9.5.1 on Windows 8 64 bit.) > > > On 3/1/2016 8:05 PM, Premsun Choltanwanich wrote: >> >> Modified command by remove -Ft flag as per you suggestion: >> pg_dump -v

Re: [GENERAL] could not migrate 8.0.13 database with large object data to 9.5.1

2016-03-01 Thread John R Pierce
(thread moved from pg_bugs) (upgrading a 8.0.13 database on Windows XP 32bit to 9.5.1 on Windows 8 64 bit.) On 3/1/2016 8:05 PM, Premsun Choltanwanich wrote: Modified command by remove -Ft flag as per you suggestion: pg_dump -v -h 192.168.200.75 -U clubadmin -d clubprogram | psql -U cluba

[GENERAL] could not migrate 8.0.13 database with large object data to 9.5.1

2016-03-01 Thread Premsun Choltanwanich
Dear All, I have very old project database which also contain lo data (large object data managed by database's functions as lo(oid), lo_in(cstring), lo_oid(lo), lo_out(lo) and oid(lo) to manage ) running on PostgreSQL 8.0.13 and need to migrate it to most recently version as PostgreSQL 9.5.1.