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

[Tyler Mitchell]

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