[postgis-users] Postgis: Error

[Majid Kazemi]

Hi:

Sorry for the delay. Here is text file of error I am receiving.

Thanks, Majid

BEGIN

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:57: NOTICE:  type "spheroid" is not yet defined

DETAIL:  Creating a shell type definition.

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:57: ERROR:  could not load library
"/opt/PostgreSQL/8.3/lib/postgresql/postgis-1.5.so": libgeos_c.so.1:
cannot open shared object file: No such file or directory

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:63: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:68: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:73: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:80: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:90: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:96: ERROR:  current transaction is aborted, commands ignored until end
of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:102: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:108: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:114: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:119: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:124: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:129: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:134: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:139: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:150: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:161: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:167: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:174: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:180: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:187: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:193: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:200: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:206: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

psql:/opt/PostgreSQL/8.3/share/postgresql/contrib/postgis-1.5/postgis.sq
l:213: ERROR:  current transaction is aborted, commands ignored until
end of transaction block

 

 

________________________________

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Emilie Laffray
Sent: March 5, 2010 11:39 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Postgis: Error

 

 

On 5 March 2010 16:34, Majid Kazemi <Majid.Kazemi at teranet.ca> wrote:

Thanks for response.

Here are the steps:

I have installed postgres 8.3.9 on Redhat 5. Server started
successfully. Postgres database was created. 

Since I need to create a spatial database, I have untar
postgis-1.5.0.tar.gz

cd postgis-1.5.0

./configure.

During the running the configure I run into a lot of issue for missing
libraries. 

I have downloaded and installed geos, Proj4.6 and GTK+2. It all seems
were okay. Then I run 

./configure again. 

The postgis installed successfully according to screen output.

Then, I have created another database.

Psql createlang plpgsql . I was logged in as postgres.

Then I followed the following steps:

Psql -d mydb -f postgis.sql   at this step I encountered these errors.

"Current transaction is aborted, command ignored until end of
transaction block". Rollback 

Please let me know if you need more information.

Thanks, Majid

 


Do you have the text of the error that is occurring?

Emilie Laffray

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100305/9d17793f/attachment.html>