Hi.
Jason Tishler wrote:
...
>> Are you upgrading from 7.1.x (or earlier) to 7.2.x?
Yes, I am.
...
>> 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?
>>
Barry Pederson wrote:
> The path to a dll for a procedural language is stored in the
> database.
...
> The path to the libraries does seem to have changed between 7.1 and
> 7.2 - and it's not a cygwin thing, the same deal happened to me on a
> FreeBSD box.
Thanks for the clarification.
I've dumped the database in a plain text file, corrected by hand the
path to plpgsql.dll and then restored it in a new db. My db now is
using the file at /usr/lib/postgresql/
Thank you again.
Regards,
Felipe N.
