Postgres Pro
Downloads
Home   >   mailing lists

Re: psycopg2 Operational Error - Mailing list psycopg

From Harald Armin Massa
Subject Re: psycopg2 Operational Error
Date
Msg-id AANLkTikm6mQAGBCz1uvh5p812FXgOdttSGLii0bfoisW@mail.gmail.com
Whole thread Raw
In response to psycopg2 Operational Error  (ganesh gajre <ganeshgajre@gmail.com>)
Responses Re: psycopg2 Operational Error  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
List psycopg
Tree view

When I tried to create connection with my database under  Postgres 8.4,  it create the connection. But failed to load database through script.

It's gives me error as follow:

psycopg2.OperationalError: could not access file "/usr/lib/postgresql/8.3/lib/plpgsql.so": No such file or directory

I am quite sure that psycopg2 is passing on the error PostgreSQL server is giving. 

And I gutess "load database through script" refers to "Ganesh has a database dump which he is trying to upload via python + psycopg2"

So, please look at your datbase dump. Is somewhere within that dump something along "create procedural language plpgsql ...... plpgsql.so" ??? THAT is source of the error.

Best wishes

Harald

 
--
Harald Armin Massa     www.2ndQuadrant.com
PostgreSQL  Training, Services  and Support

psycopg by date:

Previous
From: ganesh gajre
Date:
Subject: psycopg2 Operational Error
Next
From: Karsten Hilbert
Date:
Subject: Re: psycopg2 Operational Error