http://stackoverflow.com/questions/4833282/get-postgis-version
El 4 de octubre de 2011 16:04, Diego Uribe Gamez < [email protected]> escribió: > ni idea? lo estoy instalando desde los repositorios de debian > > postgis - geographic > objects support for PostgreSQL -- common files > > Aunque cuando hago el comando "psql" me sale: > > postgres@servidor:~$ psql > psql (8.4.8) > > El 4 de octubre de 2011 13:01, Gustavo Garay <[email protected]> escribió: > > ahi esta buscando postgis, que versión tenes instalado o tenes instalado ? >> >> saludos >> >> >> >> El 4 de octubre de 2011 14:53, Diego Uribe Gamez < >> [email protected]> escribió: >> >> Ya arregle esa parte y me dejo autenticar, lo que hice fue especificar >>> localhost en settings.py "'HOST': 'localhost'," pero sigo con problemas y es >>> que me saca un nuevo error, creo que es el ultimo o eso espero: >>> >>> django.core.exceptions.ImproperlyConfigured: Cannot determine PostGIS >>> version for database "olwidget_dev". GeoDjango requires at least PostGIS >>> version 1.3. Was the database created from a spatial database template? >>> >>> El 4 de octubre de 2011 12:46, Gustavo Garay <[email protected]>escribió: >>> >>> esta tratando de conectarte como socket de unix no via tcp >>>> este es el error que arroja >>>> >>>> >>>> psycopg2.OperationalError: FATAL: la autentificaci?n Ident fall? para >>>> el usuario <<postgres>> >>>> >>>> >>>> tenes que ver si tenes configurado para uso de ident en pg_hba.conf >>>> >>>> local all postgres ident >>>> # TYPE DATABASE USER CIDR-ADDRESS METHOD >>>> # "local" is for Unix domain socket connections only >>>> local all all ident >>>> >>>> algo asi tiene que tener tu archivos >>>> >>>> >>>> saludos >>>> >>>> >>>> El 4 de octubre de 2011 14:34, Diego Uribe Gamez < >>>> [email protected]> escribió: >>>> >>>> si logre hacer lo que me comentaste, pero nada ya ahora creo que el >>>>> problema esta en django? aunque la verdad no se? >>>>> >>>>> El problema: >>>>> >>>>> --------------------------------------------------------------------------------------------------- >>>>> Traceback (most recent call last): >>>>> File "manage.py", line 11, in <module> >>>>> execute_manager(settings) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py", >>>>> line 438, in execute_manager >>>>> utility.execute() >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py", >>>>> line 379, in execute >>>>> self.fetch_command(subcommand).run_from_argv(self.argv) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py", >>>>> line 261, in fetch_command >>>>> klass = load_command_class(app_name, subcommand) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/__init__.py", >>>>> line 67, in load_command_class >>>>> module = import_module('%s.management.commands.%s' % (app_name, >>>>> name)) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/utils/importlib.py", line >>>>> 35, >>>>> in import_module >>>>> __import__(name) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/commands/syncdb.py", >>>>> line 7, in <module> >>>>> from django.core.management.sql import custom_sql_for_model, >>>>> emit_post_sync_signal >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/core/management/sql.py", >>>>> line >>>>> 6, in <module> >>>>> from django.db import models >>>>> File "/usr/local/lib/python2.6/dist-packages/django/db/__init__.py", >>>>> line 78, in <module> >>>>> connection = connections[DEFAULT_DB_ALIAS] >>>>> File "/usr/local/lib/python2.6/dist-packages/django/db/utils.py", >>>>> line 94, in __getitem__ >>>>> conn = backend.DatabaseWrapper(db, alias) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/base.py", >>>>> line 11, in __init__ >>>>> self.ops = PostGISOperations(self) >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", >>>>> line 91, in __init__ >>>>> vtup = self.postgis_version_tuple() >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", >>>>> line 445, in postgis_version_tuple >>>>> version = self.postgis_lib_version() >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", >>>>> line 425, in postgis_lib_version >>>>> return self._get_postgis_func('postgis_lib_version') >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/contrib/gis/db/backends/postgis/operations.py", >>>>> line 406, in _get_postgis_func >>>>> cursor = self.connection._cursor() >>>>> File >>>>> "/usr/local/lib/python2.6/dist-packages/django/db/backends/postgresql_psycopg2/base.py", >>>>> line 140, in _cursor >>>>> self.connection = Database.connect(**conn_params) >>>>> >>>>> psycopg2.OperationalError: FATAL: la autentificaci?n Ident fall? para >>>>> el usuario <<postgres>> >>>>> >>>>> --------------------------------------------------------------------------------------------------- >>>>> >>>>> La ultima solución anterior: >>>>> >>>>> ---------------------------------------------------------------------------------------------------- >>>>> postgres@servidor:~$ psql >>>>> psql (8.4.8) >>>>> Digite «help» para obtener ayuda. >>>>> >>>>> postgres=# \password postgres >>>>> Ingrese la nueva contraseña: >>>>> Ingrésela nuevamente: >>>>> postgres=# help >>>>> Está usando psql, la interfaz de línea de órdenes de PostgreSQL. >>>>> Digite: \copyright para ver los términos de distribución >>>>> \h para ayuda de órdenes SQL >>>>> \? para ayuda de órdenes psql >>>>> \g o punto y coma («;») para ejecutar la consulta >>>>> \q para salir >>>>> postgres=# \q >>>>> postgres@servidor:~$ exit >>>>> >>>>> --------------------------------------------------------------------------------------------------- >>>>> >>>>> El 4 de octubre de 2011 12:12, Gustavo Garay <[email protected]>escribió: >>>>> >>>>> si pero ahi vos cambiaste de la cuenta del servicio, no del usuario de >>>>>> la base de datos >>>>>> >>>>>> estando como usuario postgres >>>>>> >>>>>> proba algo asi >>>>>> >>>>>> psql >>>>>> >>>>>> y te vas a conectar en modo consola en la base >>>>>> >>>>>> \password postgres <enter> >>>>>> >>>>>> >>>>>> y va pedir el nuevo >>>>>> >>>>>> saludos >>>>>> >>>>>> >>>>>> El 4 de octubre de 2011 13:56, Diego Uribe Gamez < >>>>>> [email protected]> escribió: >>>>>> >>>>>>> No logro entrar a la base de datos, no se que hacer, ya intente >>>>>>> cambiar la contraseña del usuario en Linux Debia y nada? >>>>>>> >>>>>>> root@servidor:/var/django/test_project# su postgres -c passwd >>>>>>> Cambiando la contraseña de postgres. >>>>>>> (actual) contraseña de UNIX: >>>>>>> Introduzca la nueva contraseña de UNIX: >>>>>>> Vuelva a escribir la nueva contraseña de UNIX: >>>>>>> passwd: contraseña actualizada correctamente >>>>>>> root@servidor:/var/django/test_project# psql -U postgres -W >>>>>>> Contraseña para usuario postgres: >>>>>>> psql: FATAL: la autentificaci?n Ident fall? para el usuario >>>>>>> <<postgres>> >>>>>>> >>>>>>> Ayuda por favor. >>>>>>> >>>>>>> Gracias. >>>>>>> -- >>>>>>> *Diego Alonso Uribe Gamez* >>>>>>> ------------------------------ >>>>>>> >>>>>>> *Desarrollador web* >>>>>>> >>>>>>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG> >>>>>>> >>>>>>> Google+: http://gplus.to/diegoug >>>>>>> ------------------------------ >>>>>>> >>>>>>> >>>>>>> >>>>>>> _______________________________________________ >>>>>>> Python-es mailing list >>>>>>> [email protected] >>>>>>> http://mail.python.org/mailman/listinfo/python-es >>>>>>> FAQ: http://python-es-faq.wikidot.com/ >>>>>>> >>>>>>> >>>>>> >>>>>> _______________________________________________ >>>>>> Python-es mailing list >>>>>> [email protected] >>>>>> http://mail.python.org/mailman/listinfo/python-es >>>>>> FAQ: http://python-es-faq.wikidot.com/ >>>>>> >>>>>> >>>>> >>>>> >>>>> -- >>>>> *Diego Alonso Uribe Gamez* >>>>> ------------------------------ >>>>> >>>>> *Desarrollador web* >>>>> >>>>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG> >>>>> >>>>> Google+: http://gplus.to/diegoug >>>>> ------------------------------ >>>>> >>>>> >>>>> >>>>> _______________________________________________ >>>>> Python-es mailing list >>>>> [email protected] >>>>> http://mail.python.org/mailman/listinfo/python-es >>>>> FAQ: http://python-es-faq.wikidot.com/ >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Python-es mailing list >>>> [email protected] >>>> http://mail.python.org/mailman/listinfo/python-es >>>> FAQ: http://python-es-faq.wikidot.com/ >>>> >>>> >>> >>> >>> -- >>> *Diego Alonso Uribe Gamez* >>> ------------------------------ >>> >>> *Desarrollador web* >>> >>> Twitter: @DiegoUG <http://www.twitter.com/DiegoUG> >>> >>> Google+: http://gplus.to/diegoug >>> ------------------------------ >>> >>> >>> >>> _______________________________________________ >>> Python-es mailing list >>> [email protected] >>> http://mail.python.org/mailman/listinfo/python-es >>> FAQ: http://python-es-faq.wikidot.com/ >>> >>> >> >> _______________________________________________ >> Python-es mailing list >> [email protected] >> http://mail.python.org/mailman/listinfo/python-es >> FAQ: http://python-es-faq.wikidot.com/ >> >> > > > -- > *Diego Alonso Uribe Gamez* > ------------------------------ > > *Desarrollador web* > > Twitter: @DiegoUG <http://www.twitter.com/DiegoUG> > > Google+: http://gplus.to/diegoug > ------------------------------ > > > > _______________________________________________ > Python-es mailing list > [email protected] > http://mail.python.org/mailman/listinfo/python-es > FAQ: http://python-es-faq.wikidot.com/ > >
_______________________________________________ Python-es mailing list [email protected] http://mail.python.org/mailman/listinfo/python-es FAQ: http://python-es-faq.wikidot.com/
