Re: pgAdmin Admin Tools Install

On 17/1/06 18:49, "hunkybill(at)gmail(dot)com" <hunkybill(at)gmail(dot)com> wrote:

> Hi,
>
> I have a FC4 server running PostgreSQL 8.1.0 with no apparent problems.
> I compiled from source and so far have experienced only minor issues
> related to dumping databases from 7.4.6 and trying to get them working
> on 8.1.0. My set returning functions were mangled and needed to be rebuilt.
>
> I have downloaded the Admin81 code base for pgAdmin and installed in
> /contrib as per the instructions, followed by make && make install. No
> errors occurred. I then took the admin81.sql.in script and attempted to
> run it from both the psql perspective on postgres and the pgAdmin
> connection to postgres database. I encountered errors, specifically...
>
> ERROR: could not access file "MODULE_PATHNAME": No such file or directory
>
> I am not sure how to proceed with solving this problem. Is there
> something I need to do different? I used my root account to make and
> install.

Hi Dave

When you ran 'make install' it should have built a 'real' admin81.sql script
form admin81.sql.in and installed it under $PGDIR/share/contrib (iirc). You
need to execute that, not the .in source file.

Regards, Dave