Skip site navigation (1) Skip section navigation (2)

Re: psycopg2 Operational Error

From: Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net>
To: psycopg(at)postgresql(dot)org
Subject: Re: psycopg2 Operational Error
Date: 2011-01-18 12:40:21
Message-ID: 20110118124021.GD2336@hermes.hilbert.loc (view raw or flat)
Thread:
Lists: psycopg
On Tue, Jan 18, 2011 at 01:35:22PM +0100, Harald Armin Massa wrote:

> > 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.

Quite apart from the fact that said "database dump" might
contain psql-specific commands which python+psycopg2 will be
quite confused about.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

In response to

Responses

psycopg by date

Next:From: ganesh gajreDate: 2011-01-18 13:24:43
Subject: Re: psycopg2 Operational Error
Previous:From: Harald Armin MassaDate: 2011-01-18 12:35:22
Subject: Re: psycopg2 Operational Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group