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

2016-03-04 Thread Rader, David
Wow -- you have an old db version there! When doing a little research, I found that back in 2005 you actually had the same basic issue - that the way you were using the "lo" contrib module in 7.x and 8.0 was not supported in 8.1 anymore: http://www.postgresql.org/message-id/439ffa3f.c5f7.004...@nsa

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

2016-03-03 Thread John R Pierce
On 3/3/2016 3:53 AM, Premsun Choltanwanich wrote: I have no source code for this contrib/lo and dll/function seem already be stored with my 8.0.13 installation package. upon looking at the current docs again in the light of day, I see that there *IS* a contrib/lo module in all recent version

Re: [GENERAL] Re: 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 5:52 PM, Premsun Choltanwanich wrote: And, almost tables are transferred to new server except tables which contain lo data (all those tables are missing from the database) after running pg_dump and psql following as per your suggestion. The attachment is a log file created after