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

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.

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

rom 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 c

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

Hi Joon, I have no source code for this contrib/lo and dll/function seem already be stored with my 8.0.13 installation package. Any suggestion? Regards, NETsolutions Asia Limited http://www.nsasia.co.th >>> John R Pierce 2016-03-03 09:05 >>> On 3/2/2016 5:52 PM, Premsun C

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

tions Asia Limited http://www.nsasia.co.th >>> John R Pierce 2016-03-04 01:37 >>> 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 t

[GENERAL] Slow Query problem

Dear All, I am currently using PostgreSQL database version 8.0.13.  My problem relates to a slow result when a query using a defined view joins to another table for a result. Background:  I have 7 tables of invoice transactions.  The tables are slightly different in that they record different dat

[GENERAL] PostgreSQL does not support updateable cursors

Dear All,   I got error message 'ERROR: column "ctid" does not exist; Error while executing the query'  when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.   I found some information o

[GENERAL] How to secure PostgreSQL Data for distribute?

Dear All,   I need to distribute my application that use PostgreSQL as database to my customer. But I still have some questions in my mind on database security. I understand that everybody  who get my application database will be have a full control permission on my database in case that Pos

[GENERAL] How to delete Large Object from Database?

Dear All,   I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine for me to get and put Large Object  from and to database. However I found something that may not correct when I try to backup my data. It seem that I cannot delete Large Object from database. It seem the thing I ca

Re: [GENERAL] How to delete Large Object from Database?

The lib I use is call lo_in and lo_out for manage BLOB. I understand that lo_unlink be related with lo_import and lo_export so I don't think that it work.   >>> Douglas McNaught <[EMAIL PROTECTED]> 07-Oct-05 20:13:36 pm >>>Moises Alberto Lindo Gutarra <[EMAIL PROTECTED]> writes:> try:   delete fr

Re: [GENERAL] How to delete Large Object from Database?

t;>try:   delete from pg_catalog.pg_largeobject;from your database.2005/10/6, Premsun Choltanwanich <[EMAIL PROTECTED]>:> Dear All,>> I use '$libdir/lo' for manage my PostgreSQL Large Object. It work fine for> me to get and put Large Object  from and to database. However I

Re: [GENERAL] How to delete Large Object from Database?

Excuse me, How? I try to find the way but not found.>>> Douglas McNaught <[EMAIL PROTECTED]> 10-Oct-05 20:07:57 pm >>>"Premsun Choltanwanich" <[EMAIL PROTECTED]> writes:> The lib I use is call lo_in and lo_out for manage BLOB.> I understand that lo_

[GENERAL] Header meaning for pg_dump

Dear All,   I had open the backup file of PostgreSQL created by pg_dump command. I found that pg_dump make a comment line as header for each module it backup. I try to understand the meaning of value contained on header for my sample header   TOC entry 1427 (class 1259 OID 1216127)-- Depend

Re: [GENERAL] Header meaning for pg_dump

  >>> Richard Huxton 11/6/2006 15:41 >>>Premsun Choltanwanich wrote:> Dear All,>  > I had open the backup file of PostgreSQL created by pg_dump command. I found > that pg_dump make a comment line as header for each module it backup. I try to > understand the meaning of

[GENERAL] Does it has a way to compact the database size?

Dear All,   I use PostgreSQL 8.0.3 for store my data started on Sep'06. Today, I use database_size('name') function for checking my database size and found that it's about 1209715345.   I think that something maybe wrong on my database because I backup my database everyday and the backup size is

Re: [GENERAL] Does it has a way to compact the database size?

Does it has a way to schedule the process for make sure that i'm running VACUUM often enough? How? (ie. create some script on PostgreSQL from running VACUUM FULL on 3.00 AM for first date of every month.)     >>> Richard Huxton 3/6/2007 16:50 >>>Premsun Choltanwanich wrot

[GENERAL] How to make lo_import and lo_export to use file on client local machine?

I try to use lo_import and lo_export for manage large object on PostgreSQL. I found that all files must be process on server with these commands. Could I make lo_import and lo_export to use file on client local machine? And How? Or Is it has other ways to manage large object that process is betwe

Re: [GENERAL] How to make lo_import and lo_export to use file

I'm new for PostgreSQL. How can I check that what thing I use? >>> Tom Lane <[EMAIL PROTECTED]> 19/11/2004 10:02:44 pm >>> "Premsun Choltanwanich" <[EMAIL PROTECTED]> writes: > Could I make lo_import and lo_export to use file on client local >

[GENERAL] How can I recovery old Data from files and folders on windows?

I got some problem on PostgreSQL 8 for windows so I uninstall and reinstall it again. Before I uninstall PostgreSQL 8 I already backup all files and folders (copy all to other place). The problem is how can I restore by use files and folders that I already backup. If I try to restore by put all of

Re: [GENERAL] How can I recovery old Data from files and

you want. Kind regards Markus > -Urspr?ngliche Nachricht- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im Auftrag von > Premsun Choltanwanich > Gesendet: Dienstag, 7. Dezember 2004 10:49 > An: [EMAIL PROTECTED] > Betreff: [GENERAL] How can I recovery old

[GENERAL] lo function changed in PostgreSQL 8.1.1

Dear All,   I use '$libdir/lo' for manage my Large Object for PostgreSQL 8.0.4 . Now I try to up my PostgreSQL to new version as 8.1.1 but I think I got some error about lo (Large Object).   lo (Large Object) function that normally shown in function list now disappear.  I'm sure that I already ch

[GENERAL] lo function changed in PostgreSQL 8.1.1 (ask again)

From contrib/lo I found that it has something  difference between old and new version of PostgreSQL.  And I'm sure that I already tick on Large Object (lo) option when I install.   How can I manage on difference function?       :::New Version::: DOMAIN lo AS pg_catalog.oid;   FUNCTION lo_oid(lo)