That usually denotes a locked file not closed. Usually resolves if you reboot your whole server or the postgresql service. We describe the issue here: http://www.postgresonline.com/journal/archives/203-postgresql90-yum.html (though this article is a bit dated) except If you get a: FATAL: could not open relation mapping file "global/pg_filenode.map": Permission denied When you attempt to connect to psql. Most likely the problem is caused by a locked file from left over. You could go thru the effort of shutting down things looking, for what went wrong, but you are an Almost idiot with little patience for these things. just do a: reboot and all should be fine. Leo and Regina http://www.postgis.us http://www.paragoncorporation.com http://www.postgresonline.com http://www.bostongis.com
_____ From: [email protected] [mailto:[email protected]] On Behalf Of Tung Thanh Sent: Wednesday, August 14, 2013 3:37 PM To: [email protected] Subject: [postgis-users] error with global/pg_filenode.map Dear List I am installing software name geo-node, on the way of installation I have some errors with postgresql/postgis and psycopg2 I have also removed and re-install postgresql and python-psycopg2 many time but It doesn't work the problem when I installed by using command as bellow $sydi add-apt-repository xxxx $sudo apt-get update $sudo apt-get install geonode and the errors occurred: Traceback (most recent call last): File "/var/lib/geonode/bin/django- admin.py", line 5, in <module> management.execute_from_ command_line() File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/__init__.py", line 443, in execute_from_command_line utility.execute() File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/__init__.py", line 382, in execute self.fetch_command(subcommand) .run_from_argv(self.argv) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 196, in run_from_argv self.execute(*args, **options.__dict__) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 232, in execute output = self.handle(*args, **options) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 371, in handle return self.handle_noargs(**options) File "/var/lib/geonode/lib/python2. 6/site-packages/south/ management/commands/syncdb.py" , line 90, in handle_noargs syncdb.Command().execute(** options) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 232, in execute output = self.handle(*args, **options) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 371, in handle return self.handle_noargs(**options) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/commands/syncdb.py" , line 57, in handle_noargs cursor = connection.cursor() File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ backends/__init__.py", line 308, in cursor cursor = util.CursorWrapper(self._ cursor(), self) File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ backends/postgresql_psycopg2/ base.py", line 177, in _cursor self.connection = Database.connect(**conn_ params) File "/usr/local/lib/python2.6/ dist-packages/psycopg2/__init_ _.py", line 179, in connect connection_factory=connection_ factory, async=async) psycopg2.OperationalError: FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory Traceback (most recent call last): File "/var/lib/geonode/bin/django- admin.py", line 5, in <module> management.execute_from_ command_line() File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/__init__.py", line 443, in execute_from_command_line utility.execute() File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/__init__.py", line 382, in execute self.fetch_command(subcommand) .run_from_argv(self.argv) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 196, in run_from_argv self.execute(*args, **options.__dict__) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/base.py", line 232, in execute output = self.handle(*args, **options) File "/var/lib/geonode/lib/python2. 6/site-packages/django/core/ management/commands/loaddata. py", line 71, in handle cursor = connection.cursor() File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ backends/__init__.py", line 308, in cursor cursor = util.CursorWrapper(self._ cursor(), self) File "/var/lib/geonode/lib/python2. 6/site-packages/django/db/ backends/postgresql_psycopg2/ base.py", line 177, in _cursor self.connection = Database.connect(**conn_ params) File "/usr/local/lib/python2.6/ dist-packages/psycopg2/__init_ _.py", line 179, in connect connection_factory=connection_ factory, async=async) psycopg2.OperationalError: FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory FATAL: could not open relation mapping file "global/pg_filenode.map": No such file or directory / Site default disabled. To activate the new configuration, you need to run: service apache2 reload Considering dependency proxy for proxy_http: Module proxy already enabled Module proxy_http already enabled Enabling site geonode. To activate the new configuration, you need to run: service apache2 reload * Restarting web server apache2 ... waiting [ OK ] * Stopping Tomcat servlet engine tomcat6 [ OK ] * Starting Tomcat servlet engine tomcat6 [ OK ] * Restarting web server apache2 ... waiting . Any ideas to fix Many thanks @QT
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
