Forums PostgreSQL.fr

bonjour à tous
Nous possédons la versio 8.3 de postgres;
Hier le service informatique à modifié les droits sur le répertoire 8.3 (erreur involontaire) les services sont donc devenus  inacessibles.
Les droits initiaux ont été réaffectés d'après le service info mais cela ne change rien
Comment faire pour réactiver les services?
Merci à tous

ps: liste ci-dessous du pg-log d'hier

ERROR:  unrecognized configuration parameter "application_name"
STATEMENT:  SET application_name='Quantum GIS'
NOTICE:  there is no transaction in progress
NOTICE:  there is no transaction in progress
ERROR:  unrecognized configuration parameter "application_name"
STATEMENT:  SET application_name='Quantum GIS'
NOTICE:  there is no transaction in progress
NOTICE:  there is no transaction in progress
ERROR:  insert or update on table "obstacles_ce" violates foreign key constraint "pk_reglement_eau"
DETAIL:  Key (idouvrage)=(0) is not present in table "reglement_eau".
STATEMENT:  BEGIN;INSERT INTO "spt"."environnement"."obstacles_ce" ("idouvrage", "SP_GEOMETRY") VALUES (0, GeomFromWKB(E'\\001\\001\\000\\000\\000\\050\\227\\352\\356\\025\\240\\034A\\175E\\134\\300\\334\\363YA', -1))
FATAL:  unrecognized configuration parameter "application_name"
FATAL:  unrecognized configuration parameter "application_name"
ERROR:  unrecognized configuration parameter "application_name"
STATEMENT:  SET application_name='Quantum GIS'
NOTICE:  there is no transaction in progress
ERROR:  relation "geography_columns" does not exist
STATEMENT:  select f_table_name,f_table_schema,f_geography_column,upper(type),pg_class.relkind from geography_columns,pg_class,pg_namespace where relname=f_table_name and f_table_schema=nspname and pg_namespace.oid=pg_class.relnamespace and has_schema_privilege(pg_namespace.nspname,'usage') and has_table_privilege('"'||pg_namespace.nspname||'"."'||pg_class.relname||'"','select') order by f_table_schema,f_table_name,f_geography_column
WARNING:  there is no transaction in progress
ERROR:  unrecognized configuration parameter "application_name"
STATEMENT:  SET application_name='Quantum GIS'
NOTICE:  there is no transaction in progress
ERROR:  column "SP_GEOMETRY" does not exist at character 46
STATEMENT:  select distinct case when upper(geometrytype("SP_GEOMETRY")) IN ('POINT','MULTIPOINT') THEN 'POINT' when upper(geometrytype("SP_GEOMETRY")) IN ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when upper(geometrytype("SP_GEOMETRY")) IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON' end from "public"."territoire_smgv"
ERROR:  column "SP_GEOMETRY" does not exist at character 46
STATEMENT:  select distinct case when upper(geometrytype("SP_GEOMETRY")) IN ('POINT','MULTIPOINT') THEN 'POINT' when upper(geometrytype("SP_GEOMETRY")) IN ('LINESTRING','MULTILINESTRING') THEN 'LINESTRING' when upper(geometrytype("SP_GEOMETRY")) IN ('POLYGON','MULTIPOLYGON') THEN 'POLYGON' end from "risque"."essai_azi"
ERROR:  unrecognized configuration parameter "application_name"
STATEMENT:  SET application_name='Quantum GIS'
NOTICE:  there is no transaction in progress
NOTICE:  there is no transaction in progress
LOG:  could not open temporary statistics file "global/pgstat.tmp": Permission non accordée
LOG:  could not open temporary statistics file "global/pgstat.tmp": Permission non accordée
FATAL:  could not open file "global/pg_database": Permission non accordée
LOG:  autovacuum launcher process (PID 4270) exited with exit code 1
LOG:  terminating any other active server processes
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
WARNING:  terminating connection because of crash of another server process
DETAIL:  The postmaster has commanded this server process to roll back the current transaction and exit, because another server process exited abnormally and possibly corrupted shared memory.
HINT:  In a moment you should be able to reconnect to the database and repeat your command.
LOG:  could not open temporary statistics file "global/pgstat.tmp": Permission non accordée
LOG:  all server processes terminated; reinitializing
LOG:  could not open file "postmaster.pid": Permission non accordée
PANIC:  could not open control file "global/pg_control": Permission non accordée