Thread: pgAdmin Admin Tools Install

pgAdmin Admin Tools Install

From
hunkybill@gmail.com
Date:
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.

Thanks

Dave


Re: pgAdmin Admin Tools Install

From
Dave Page
Date:


On 17/1/06 18:49, "hunkybill@gmail.com" <hunkybill@gmail.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