Re: plpgsql.dll path

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