From: | Jason Tishler <jason(at)tishler(dot)net> |
---|---|
To: | Felipe Nievinski <fnievinski2(at)terra(dot)com(dot)br> |
Cc: | pgsql-cygwin <pgsql-cygwin(at)postgresql(dot)org> |
Subject: | Re: plpgsql.dll path |
Date: | 2002-05-12 14:27:01 |
Message-ID: | 20020512142701.GC3144@tishler.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-cygwin |
Felipe,
On Thu, May 09, 2002 at 01:20:11PM -0200, Felipe Nievinski wrote:
> I'm using PostgreSQL v7.2.1-1 on top of MS-Windows98.
>
> When I type
> pg_restore -d geosist geosist-maio09.dmp
> I get the following error msg:
> pg_restore: [archiver (db)] could not execute query: ERROR:
> stat failed on file '/usr/lib/plpgsql.dll': No such file or
> directory
>
> [snip]
>
> Is there any additional info on this?
Note that I have never used pg_dump/pg_restore before, so I can be
*completely* off-base with the following. I also think that the above
may not be specifically a Cygwin PostgreSQL problem.
Are you upgrading from 7.1.x (or earlier) to 7.2.x? I ask this for the
following reasons:
$ tar -tjf postgresql-7.1.3-2.tar.bz2 | fgrep plpgsql.dll
usr/lib/plpgsql.dll
$ tar -tjf postgresql-7.2.1-1.tar.bz2 | fgrep plpgsql.dll
usr/lib/postgresql/plpgsql.dll
$ strings /usr/bin/pg_restore.exe | fgrep plpgsql.dll
Hence, the path to plpgsql.dll is *not* burned into pg_restore.exe. Is
it in geosist-maio09.dmp? Or, is this kind of info stored in some other
PostgreSQL file?
Can someone knowledgeable is this area please confirm or refute the
above?
> Thanks for the work on the cygwin port.
You are welcome.
Thanks,
Jason
From | Date | Subject | |
---|---|---|---|
Next Message | Barry Pederson | 2002-05-12 14:46:09 | Re: plpgsql.dll path |
Previous Message | David P. Caldwell | 2002-05-12 14:24:04 | Re: rename() vs. link(); building from source |