[postgis-users] error executing psql -d mydb -f postgis.sql

[Paul Ramsey]

Do the postgres steps as the 'postgres' user, for maximum cleanliness.
The 'postgres' user is the pgsql equivalent of root.

Tyler Mitchell wrote:
> 
> I'm not sure I follow exactly, but I've had lots of grief running
> postgis.sql in the past...but now I understand enough to get it working
> fine!  So be encouraged.  The biggest mistake I was making, or the thing I
> found helped the most was being logged in as the same user for all steps:
> -createdb
> -createlang
> -and the psql -f postgis.sql step too.
> I'm usually doing it as root, but I don't think you need to.  Give it a
> try: create a new db, etc. and see if it works for you.
> 
> Tyler
> 
> 
>                       root <porfidia at anpa.it>
>                       Sent by:                                To:       postgis-users at postgis.refractions.net
>                       postgis-users-admin at postgis.refr        cc:
>                       actions.net                             Fax to:
>                                                               Subject:  [postgis-users] error executing psql -d mydb -f
>                                                                postgis.sql
>                       08/01/2002 08:04 AM
>                       Please respond to postgis-users
> 
> 
> 
> Hi all
> I'm newby of the list and postgis too
> I installed Postgis on postgresql 7.2.1 (default installation from
> tarball) and Red Hat7.2 and all worked fine till the command psql.......
> 
> It gives me this error
> I took postgis.sql file from
> /usr/local/pgsql/share/contrib/postgis.sql   and
> in /usr/local/pgsql/bin I made ./psql -d mydb -f
> /usr/local/share/contrib/postgis.sql  as postgres user
> BEGIN
> psql:/usr/local/pgsql/share/contrib/postgis.sql:772: ERROR:  argument
> type geometry does not exist
> psql:/usr/local/pgsql/share/contrib/postgis.sql:775: NOTICE:  current
> transaction is aborted, queries ignored until end of transaction block
> *ABORT STATE*
> .
> .
> .
> .
> and  at the end
> psql:/usr/local/pgsql/share/contrib/postgis.sql:1026: NOTICE:  current
> transaction is aborted, queries ignored until end of transaction block
> *ABORT STATE*
> COMMIT
> thus I checked all permissions and  chown to postgres user
> I tried 0.7.1 dist and cvs snapshot dist but nothing change
> Anybody can help me
> Am i wrong
> Am I right
> oohh my god what have I done?
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

-- 
      __
     /
     | Paul Ramsey
     | Refractions Research
     | Email: pramsey at refractions.net
     | Phone: (250) 885-0632
     \_