Re: How can I use large object on PostgreSQL Linux
Dear Michael Fuhr,
The word you said is correct on most information. I will give you
more information.
<Q> I'd guess that you haven't installed some third-party modules that
you need on the Linux box, or that you've installed them in the wrong
place.
<A> I don't make sure about third-party information cause all of module
I use for Windows Version is install already on the time I install
PostgreSQL RC1 on Windows.
<Q> What version of PostgreSQL are you running on the Linux box and how
did you install it?
<A1> PostgreSQL 8.0.1 on i686-pc-linux-gnu, complied by GCC gcc (GCC)
3.3.3 (SuSE Linux)
<A2> gmake On SuSE 9.0 (follow the instruction.)
Michael Fuhr <mike@fuhr.org> 07-Feb-05 1:56:23 PM >>>
On Mon, Feb 07, 2005 at 11:40:41AM +0700, Premsun Choltanwanich wrote:
I found that at least Large Object that now failed and no data can
be
imported to Linux version. The problem I found was shown like:
ERROR: could not access file "$libdir/lo": No such file or
directory
ERROR: could not access file "$libdir/dbsize": No such file or
directory
ERROR: could not access file "$libdir/admin": No such file or
directory
I'd guess that you haven't installed some third-party modules that
you need on the Linux box, or that you've installed them in the
wrong place. lo and dbsize look like modules from the contrib
directory in the PostgreSQL source code (or available via a separate
package, if you're using prebuilt packages); I don't know what admin
is.
What version of PostgreSQL are you running on the Linux box and how
did you install it?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Thank You Michael Fuhr ,
Now, I already installed the contrib/lo and contrib/dbsize modules from
source as your suggestion.
From my first information, I got 3 errors /lo, /dbsize and /admin. That
mean now only /admin that I cannot found anywhere.
I still try to find it. If anybody know more information about /admin
(in Windows is admin.dll) please tell me.
Michael Fuhr <mike@fuhr.org> 08-Feb-05 11:07:10 AM >>>
On Mon, Feb 07, 2005 at 02:33:24PM +0700, Premsun Choltanwanich wrote:
I'd guess that you haven't installed some third-party modules that
you need on the Linux box, or that you've installed them in the
wrong
place.
I don't make sure about third-party information cause all of module
I use for Windows Version is install already on the time I install
PostgreSQL RC1 on Windows.
If you built PostgreSQL from source then you can install the
contrib/lo and contrib/dbsize modules from source as well. For
more information see contrib/README, contrib/lo/README.lo, and
contrib/dbsize/README.dbsize.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Import Notes
Resolved by subject fallback
On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:
From my first information, I got 3 errors /lo, /dbsize and /admin. That
mean now only /admin that I cannot found anywhere.I still try to find it. If anybody know more information about /admin
(in Windows is admin.dll) please tell me.
I wonder if admin is pgadmin-tools.
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin-tools/
What does the query below show on the Windows box? If it shows the same
functions listed in pgadmin-tools/support/admin.sql.in then you might
need to install pgadmin-tools to make the systems identical (although
you might not actually need pgadmin-tools for its functionality).
SELECT proname, oidvectortypes(proargtypes) AS argtypes
FROM pg_proc
WHERE probin LIKE '%admin%';
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
I don't sure. However It maybe possibled cause I use PostgreSQL 8 RC1
with pgAdmin.
Michael Fuhr <mike@fuhr.org> 09-Feb-05 11:22 AM >>>
On Tue, Feb 08, 2005 at 02:55:01PM +0700, Premsun Choltanwanich wrote:
From my first information, I got 3 errors /lo, /dbsize and /admin.
That
mean now only /admin that I cannot found anywhere.
I still try to find it. If anybody know more information about
/admin
(in Windows is admin.dll) please tell me.
I wonder if admin is pgadmin-tools.
http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/pgadmin-tools/
What does the query below show on the Windows box? If it shows the
same
functions listed in pgadmin-tools/support/admin.sql.in then you might
need to install pgadmin-tools to make the systems identical (although
you might not actually need pgadmin-tools for its functionality).
SELECT proname, oidvectortypes(proargtypes) AS argtypes
FROM pg_proc
WHERE probin LIKE '%admin%';
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
Import Notes
Resolved by subject fallback
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org on behalf of Michael Fuhr
Sent: Wed 2/9/2005 4:22 AM
To: Premsun Choltanwanich
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How can I use large object on PostgreSQL Linux
I wonder if admin is pgadmin-tools.
Yes, it is.
Regards, Dave
Import Notes
Resolved by subject fallback
Dave Page wrote:
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org on behalf of Michael Fuhr
Sent: Wed 2/9/2005 4:22 AM
To: Premsun Choltanwanich
Cc: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] How can I use large object on PostgreSQL LinuxI wonder if admin is pgadmin-tools.
Yes, it is.
We really should try to get this stuff into contrib where it belongs.
These are functions to support maintenance, and not everybody likes
ls/cat/kill as admin tools.
Regards,
Andreas