[postgis-users] error with global/pg_filenode.map

[Paragon Corporation]

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: postgis-users-bounces at lists.osgeo.org
[mailto:postgis-users-bounces at lists.osgeo.org] On Behalf Of Tung Thanh
Sent: Wednesday, August 14, 2013 3:37 PM
To: postgis-users at lists.osgeo.org
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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20130814/ee8bbf03/attachment.html>