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

[Paul Ramsey]

Yes. The postgis.sql script for example adds types, which is a
'superuser only' process, and the postgres user is guaranteed to be able
to do that.

Tyler Mitchell wrote:
> 
> Mr. P wrote:
> >Do the postgres steps as the 'postgres' user, for maximum cleanliness.
> >The 'postgres' user is the pgsql equivalent of root.
> 
> So you would do all the steps I mentioned as the postgres user?
> 
> >>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.
> >>
> 
> 
>                       Paul Ramsey
>                       <pramsey at refractions.net>               To:       postgis-users at postgis.refractions.net
>                       Sent by:                                cc:
>                       postgis-users-admin at postgis.refr        Fax to:
>                       actions.net                             Subject:  Re: [postgis-users] error executing psql -d mydb
>                                                                -f postgis.sql
> 
>                       08/01/2002 08:22 AM
>                       Please respond to postgis-users
> 
> 
> 
> 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
>      \_
> 
> _______________________________________________
> 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
     \_