Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Greg Stark
On Mon, Oct 5, 2009 at 7:34 AM, Martijn van Oosterhout wrote: > That said, why are you doint this anyway. A better solution may be to > install a trusted language (like plperlu or plpython) and do the system > call from there. > If you just want system(3) you might as well use plsh... -- greg

Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Adrian Klaver
On Monday 05 October 2009 10:36:04 am Chun-fan Ivan Liao wrote: > Thank you, Oosterhout and Lane. > > The code is not written by me. The previous DB admin is not reachable. > I was just the present-stage DB (newbie) admin, and I never touched > PostgreSQL before :( > > On Mon, Oct 5, 2009 at 10

Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Chun-fan Ivan Liao
Thank you, Oosterhout and Lane. The code is not written by me. The previous DB admin is not reachable. I was just the present-stage DB (newbie) admin, and I never touched PostgreSQL before :( On Mon, Oct 5, 2009 at 10:34 PM, Martijn van Oosterhout wrote: > > On Mon, Oct 05, 2009 at 06:07:44P

Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Tom Lane
Chun-fan Ivan Liao writes: > STATEMENT: CREATE FUNCTION "system"(cstring) RETURNS integer > AS '/lib/libc.so.7', 'system' > LANGUAGE c STRICT; This hack doesn't work any more --- not that it was ever considered supported or recommended. If you really need such a thing, I

Re: [GENERAL] Errors regarding transporting database using pg_dump

2009-10-05 Thread Martijn van Oosterhout
On Mon, Oct 05, 2009 at 06:07:44PM +0800, Chun-fan Ivan Liao wrote: > I used pg_dump to dump the old database out and psql to store the database > into the new server, but the following two errors occurred: > > ERROR: incompatible library "/lib/libc.so.6": missing magic block > HINT: Extension l