Je ne me préoccupe que de PGadmin pour le moment.
ta base est créée, tu y accèdes, double clic sur la ligne postgresql... précédée de la croix rouge.
tu vas te retrouver ici :
jturlier a écrit :Il doit avoir une petite croix rouge, ce qui signifie qu'il nest pas connecté et qu'il n'attend qu'un double clic de ta part.
Le double clic devrait ouvrir la connexion.
maintenant, tu devrais trouver "bases de données(1)"
car il est probable que weatherPro t'en a d'ailleurs créé une.
Tu peux donc cliquer sur la petite croix à gauche pour développer son contenu.
N'as tu eu aucune info à l'install du pgm qd il a créé la base ?
Jean
Station : VP2 Pro Console Vue + anémomètre à Ultra-sons
Logiciels : Cumulus 1.9.4 + Cumulus2SQL
Serveur local : Apache + MySQL +PHP
PC : W10
Support Audio : FR
j 'ai potasser les docs et inspecté le CD d 'installation et je n 'ai rien trouvé ...
j 'ai fait un mail à la crosse afin de le leur demander ( à suivre ) ...
Bonjour,
fais moi parvenir la copie de ton fichier pg_hba.conf (dans le répertoire data de postgresql) ou si tu es en confiance, rajoute ou modifie, à la fin du fichier, ds la partie #IPV4 local connections, la ligne suivante :
host all all 127.0.0.1/32 trust
ou si la ligne 127.0.0.1 existe remplace md5 par trust ce qui permet de ne pas utiliser de mot de passe pour les connexions sans problème de sécurité.
Si tu es sur un réseau, il faut naturellement modifier aussi les adresses en 192.168.xxx
Maintenant tu as accès à ta base !
Il faut que tu double-cliques sur Lacrossws2550 pour l'ouvir,
malenimi a écrit :
En haut sur la ligne des icônes, la 6ème est une feuille et un crayon marquée SQL. Tu cliques, et là une nouvelle fenêtre s'ouvre :
Dans le cadre supérieur, tu fais un copié/collé du texte de création et ensuite tu cliques sur la flèche verte qui a un message "exécuter" quand on laisse la souris dessus.
Et là, aux erreurs de syntaxe près (à moins d'une veine insolente), ta vue sera créée.
Si tout se passe bien donc, tu pourras faire le tour du propriétaire et tu trouveras comme indiqué ds mon précédent post, tes tables, ta vue ...
Pour visualiser ta vue, il faudra lancer, toujours ds la même fenêtre SQL : select * from meteo; (pas de pb avec les majuscules/minuscules et si "meteo" est le nom de ta vue bien sûr.)
Quand on sera au bout de cette saga, celui qui voudra installer une WS2550 avec PGSQL ne devrait pas avoir de difficulté !!!
EXTRACT(EPOCH FROM a.savetime)as Tstamp,
a.weatherdata AS outdoor_temp, b.weatherdata AS outdoor_hum,
g.weatherdata AS indoor_temp, h.weatherdata AS indoor_hum, c.raincounter as rainfall,
c.counteramount, d.weatherdata AS airpressure, e.degree as winddirection,i.counteramount as SolarRad ,
e.fluctuation, f.weatherdata AS wind
FROM outside_temp a, outside_hum b,inside_temp g, inside_hum h, rainfall c,
airpressure d, winddirection e, windforce f,sunshine i
WHERE a.savetime = b.savetime AND a.savetime = c.savetime AND a.savetime = d.savetime
AND a.savetime = e.savetime AND a.savetime = f.savetime AND a.savetime = g.savetime AND a.savetime = h.savetime AND a.savetime = i.savetime and EXTRACT(EPOCH FROM savetime)
et voici le message que j 'obtiens dans le "panneaux sortie"
ERROR: syntax error at or near "EXTRACT"
LINE 10: EXTRACT(EPOCH FROM a.savetime)as Tstamp,
^
********** Erreur **********
ERROR: syntax error at or near "EXTRACT"
État SQL :42601
Caractère : 197
sur WaetherP. il y à une fonction "Maintenace de la Base de donnée" , voici ce qui s 'affiche lorsque tu la lance ( je ne sais pas si c 'est utile ???)
Michel
Maintenance de la base de données...
vacuuming "public.winddirection"
"winddirection": found 0 removable, 5198 nonremovable row versions in 39 pages
index "winddirection_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_winddirection" now contains 5198 row versions in 17 pages
"winddirection": moved 0 row versions, truncated 39 to 39 pages
analyzing "public.winddirection"
"winddirection": scanned 39 of 39 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "information_schema.sql_packages"
"sql_packages": found 0 removable, 10 nonremovable row versions in 1 pages
"sql_packages": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_10752"
"pg_toast_10752": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10752_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_packages"
"sql_packages": scanned 1 of 1 pages, containing 10 live rows and 0 dead rows; 10 rows in sample, 10 estimated total rows
vacuuming "information_schema.sql_parts"
"sql_parts": found 0 removable, 9 nonremovable row versions in 1 pages
"sql_parts": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_10757"
"pg_toast_10757": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10757_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_parts"
"sql_parts": scanned 1 of 1 pages, containing 9 live rows and 0 dead rows; 9 rows in sample, 9 estimated total rows
vacuuming "information_schema.sql_sizing"
"sql_sizing": found 0 removable, 23 nonremovable row versions in 1 pages
"sql_sizing": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_10762"
"pg_toast_10762": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10762_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_sizing"
"sql_sizing": scanned 1 of 1 pages, containing 23 live rows and 0 dead rows; 23 rows in sample, 23 estimated total rows
vacuuming "information_schema.sql_sizing_profiles"
"sql_sizing_profiles": found 0 removable, 0 nonremovable row versions in 0 pages
vacuuming "pg_toast.pg_toast_10767"
"pg_toast_10767": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10767_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_sizing_profiles"
"sql_sizing_profiles": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_authid"
"pg_authid": found 0 removable, 1 nonremovable row versions in 1 pages
index "pg_authid_rolname_index" now contains 1 row versions in 2 pages
index "pg_authid_oid_index" now contains 1 row versions in 2 pages
"pg_authid": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_1260"
"pg_toast_1260": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_1260_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_authid"
"pg_authid": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows
vacuuming "information_schema.sql_features"
"sql_features": found 0 removable, 439 nonremovable row versions in 6 pages
vacuuming "pg_toast.pg_toast_10737"
"pg_toast_10737": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10737_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_features"
"sql_features": scanned 6 of 6 pages, containing 439 live rows and 0 dead rows; 439 rows in sample, 439 estimated total rows
vacuuming "information_schema.sql_implementation_info"
"sql_implementation_info": found 0 removable, 12 nonremovable row versions in 1 pages
"sql_implementation_info": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_10742"
"pg_toast_10742": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10742_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_implementation_info"
"sql_implementation_info": scanned 1 of 1 pages, containing 12 live rows and 0 dead rows; 12 rows in sample, 12 estimated total rows
vacuuming "information_schema.sql_languages"
"sql_languages": found 0 removable, 4 nonremovable row versions in 1 pages
"sql_languages": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_10747"
"pg_toast_10747": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_10747_index" now contains 0 row versions in 1 pages
analyzing "information_schema.sql_languages"
"sql_languages": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows
vacuuming "pg_catalog.pg_statistic"
"pg_statistic": found 378 removable, 378 nonremovable row versions in 22 pages
index "pg_statistic_relid_att_index" now contains 378 row versions in 5 pages
"pg_statistic": moved 360 row versions, truncated 22 to 11 pages
index "pg_statistic_relid_att_index" now contains 378 row versions in 5 pages
vacuuming "pg_toast.pg_toast_2619"
"pg_toast_2619": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_2619_index" now contains 0 row versions in 1 pages
vacuuming "public.outside_temp"
"outside_temp": found 0 removable, 5198 nonremovable row versions in 34 pages
index "outside_temp_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_outside_temp" now contains 5198 row versions in 17 pages
"outside_temp": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.outside_temp"
"outside_temp": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "pg_catalog.pg_type"
"pg_type": found 0 removable, 268 nonremovable row versions in 6 pages
index "pg_type_oid_index" now contains 268 row versions in 2 pages
index "pg_type_typname_nsp_index" now contains 268 row versions in 6 pages
"pg_type": moved 0 row versions, truncated 6 to 6 pages
analyzing "pg_catalog.pg_type"
"pg_type": scanned 6 of 6 pages, containing 268 live rows and 0 dead rows; 268 rows in sample, 268 estimated total rows
vacuuming "pg_catalog.pg_attribute"
"pg_attribute": found 0 removable, 1920 nonremovable row versions in 34 pages
index "pg_attribute_relid_attnam_index" now contains 1920 row versions in 25 pages
index "pg_attribute_relid_attnum_index" now contains 1920 row versions in 8 pages
"pg_attribute": moved 0 row versions, truncated 34 to 34 pages
analyzing "pg_catalog.pg_attribute"
"pg_attribute": scanned 34 of 34 pages, containing 1920 live rows and 0 dead rows; 1920 rows in sample, 1920 estimated total rows
vacuuming "pg_catalog.pg_proc"
"pg_proc": found 0 removable, 1939 nonremovable row versions in 47 pages
index "pg_proc_oid_index" now contains 1939 row versions in 8 pages
index "pg_proc_proname_args_nsp_index" now contains 1939 row versions in 33 pages
"pg_proc": moved 0 row versions, truncated 47 to 47 pages
vacuuming "pg_toast.pg_toast_1255"
"pg_toast_1255": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_1255_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_proc"
"pg_proc": scanned 47 of 47 pages, containing 1939 live rows and 0 dead rows; 1939 rows in sample, 1939 estimated total rows
vacuuming "pg_catalog.pg_class"
"pg_class": found 113 removable, 282 nonremovable row versions in 9 pages
index "pg_class_oid_index" now contains 282 row versions in 2 pages
index "pg_class_relname_nsp_index" now contains 282 row versions in 9 pages
"pg_class": moved 94 row versions, truncated 9 to 7 pages
index "pg_class_oid_index" now contains 282 row versions in 2 pages
index "pg_class_relname_nsp_index" now contains 282 row versions in 9 pages
analyzing "pg_catalog.pg_class"
"pg_class": scanned 7 of 7 pages, containing 282 live rows and 0 dead rows; 282 rows in sample, 282 estimated total rows
vacuuming "pg_catalog.pg_autovacuum"
"pg_autovacuum": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_autovacuum_vacrelid_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_autovacuum"
"pg_autovacuum": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_attrdef"
"pg_attrdef": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_attrdef_adrelid_adnum_index" now contains 0 row versions in 1 pages
index "pg_attrdef_oid_index" now contains 0 row versions in 1 pages
vacuuming "pg_toast.pg_toast_2604"
"pg_toast_2604": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_2604_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_attrdef"
"pg_attrdef": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_constraint"
"pg_constraint": found 0 removable, 27 nonremovable row versions in 1 pages
index "pg_constraint_conname_nsp_index" now contains 27 row versions in 2 pages
index "pg_constraint_conrelid_index" now contains 27 row versions in 2 pages
index "pg_constraint_contypid_index" now contains 27 row versions in 2 pages
index "pg_constraint_oid_index" now contains 27 row versions in 2 pages
"pg_constraint": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_2606"
"pg_toast_2606": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_2606_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_constraint"
"pg_constraint": scanned 1 of 1 pages, containing 27 live rows and 0 dead rows; 27 rows in sample, 27 estimated total rows
vacuuming "pg_catalog.pg_inherits"
"pg_inherits": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_inherits_relid_seqno_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_inherits"
"pg_inherits": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_index"
"pg_index": found 0 removable, 128 nonremovable row versions in 2 pages
index "pg_index_indrelid_index" now contains 128 row versions in 2 pages
index "pg_index_indexrelid_index" now contains 128 row versions in 2 pages
"pg_index": moved 0 row versions, truncated 2 to 2 pages
analyzing "pg_catalog.pg_index"
"pg_index": scanned 2 of 2 pages, containing 128 live rows and 0 dead rows; 128 rows in sample, 128 estimated total rows
vacuuming "pg_catalog.pg_operator"
"pg_operator": found 0 removable, 666 nonremovable row versions in 14 pages
index "pg_operator_oid_index" now contains 666 row versions in 4 pages
index "pg_operator_oprname_l_r_n_index" now contains 666 row versions in 11 pages
"pg_operator": moved 0 row versions, truncated 14 to 14 pages
analyzing "pg_catalog.pg_operator"
"pg_operator": scanned 14 of 14 pages, containing 666 live rows and 0 dead rows; 666 rows in sample, 666 estimated total rows
vacuuming "pg_catalog.pg_opclass"
"pg_opclass": found 0 removable, 102 nonremovable row versions in 2 pages
index "pg_opclass_am_name_nsp_index" now contains 102 row versions in 4 pages
index "pg_opclass_oid_index" now contains 102 row versions in 2 pages
"pg_opclass": moved 0 row versions, truncated 2 to 2 pages
analyzing "pg_catalog.pg_opclass"
"pg_opclass": scanned 2 of 2 pages, containing 102 live rows and 0 dead rows; 102 rows in sample, 102 estimated total rows
vacuuming "pg_catalog.pg_am"
"pg_am": found 0 removable, 4 nonremovable row versions in 1 pages
index "pg_am_name_index" now contains 4 row versions in 2 pages
index "pg_am_oid_index" now contains 4 row versions in 2 pages
"pg_am": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_am"
"pg_am": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows
vacuuming "pg_catalog.pg_amop"
"pg_amop": found 0 removable, 445 nonremovable row versions in 3 pages
index "pg_amop_opc_strat_index" now contains 445 row versions in 4 pages
index "pg_amop_opr_opc_index" now contains 445 row versions in 4 pages
"pg_amop": moved 0 row versions, truncated 3 to 3 pages
analyzing "pg_catalog.pg_amop"
"pg_amop": scanned 3 of 3 pages, containing 445 live rows and 0 dead rows; 445 rows in sample, 445 estimated total rows
vacuuming "pg_catalog.pg_amproc"
"pg_amproc": found 0 removable, 224 nonremovable row versions in 2 pages
index "pg_amproc_opc_proc_index" now contains 224 row versions in 2 pages
"pg_amproc": moved 0 row versions, truncated 2 to 2 pages
analyzing "pg_catalog.pg_amproc"
"pg_amproc": scanned 2 of 2 pages, containing 224 live rows and 0 dead rows; 224 rows in sample, 224 estimated total rows
vacuuming "pg_catalog.pg_language"
"pg_language": found 0 removable, 4 nonremovable row versions in 1 pages
index "pg_language_name_index" now contains 4 row versions in 2 pages
index "pg_language_oid_index" now contains 4 row versions in 2 pages
"pg_language": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_language"
"pg_language": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows
vacuuming "pg_catalog.pg_largeobject"
"pg_largeobject": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_largeobject_loid_pn_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_largeobject"
"pg_largeobject": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_aggregate"
"pg_aggregate": found 0 removable, 114 nonremovable row versions in 1 pages
index "pg_aggregate_fnoid_index" now contains 114 row versions in 2 pages
"pg_aggregate": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_aggregate"
"pg_aggregate": scanned 1 of 1 pages, containing 114 live rows and 0 dead rows; 114 rows in sample, 114 estimated total rows
vacuuming "pg_catalog.pg_rewrite"
"pg_rewrite": found 0 removable, 74 nonremovable row versions in 9 pages
index "pg_rewrite_oid_index" now contains 74 row versions in 2 pages
index "pg_rewrite_rel_rulename_index" now contains 74 row versions in 2 pages
"pg_rewrite": moved 0 row versions, truncated 9 to 9 pages
vacuuming "pg_toast.pg_toast_2618"
"pg_toast_2618": found 0 removable, 80 nonremovable row versions in 18 pages
index "pg_toast_2618_index" now contains 80 row versions in 2 pages
"pg_toast_2618": moved 0 row versions, truncated 18 to 18 pages
analyzing "pg_catalog.pg_rewrite"
"pg_rewrite": scanned 9 of 9 pages, containing 74 live rows and 0 dead rows; 74 rows in sample, 74 estimated total rows
vacuuming "pg_catalog.pg_trigger"
"pg_trigger": found 0 removable, 3 nonremovable row versions in 1 pages
index "pg_trigger_tgconstrname_index" now contains 3 row versions in 2 pages
index "pg_trigger_tgconstrrelid_index" now contains 3 row versions in 2 pages
index "pg_trigger_tgrelid_tgname_index" now contains 3 row versions in 2 pages
index "pg_trigger_oid_index" now contains 3 row versions in 2 pages
"pg_trigger": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_trigger"
"pg_trigger": scanned 1 of 1 pages, containing 3 live rows and 0 dead rows; 3 rows in sample, 3 estimated total rows
vacuuming "pg_catalog.pg_listener"
"pg_listener": found 0 removable, 0 nonremovable row versions in 0 pages
analyzing "pg_catalog.pg_listener"
"pg_listener": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "pg_catalog.pg_description"
"pg_description": found 0 removable, 1757 nonremovable row versions in 17 pages
index "pg_description_o_c_o_index" now contains 1757 row versions in 9 pages
"pg_description": moved 0 row versions, truncated 17 to 17 pages
vacuuming "pg_toast.pg_toast_2609"
"pg_toast_2609": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_2609_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_description"
"pg_description": scanned 17 of 17 pages, containing 1757 live rows and 0 dead rows; 1757 rows in sample, 1757 estimated total rows
vacuuming "pg_catalog.pg_cast"
"pg_cast": found 0 removable, 256 nonremovable row versions in 2 pages
index "pg_cast_oid_index" now contains 256 row versions in 2 pages
index "pg_cast_source_target_index" now contains 256 row versions in 2 pages
"pg_cast": moved 0 row versions, truncated 2 to 2 pages
analyzing "pg_catalog.pg_cast"
"pg_cast": scanned 2 of 2 pages, containing 256 live rows and 0 dead rows; 256 rows in sample, 256 estimated total rows
vacuuming "pg_catalog.pg_namespace"
"pg_namespace": found 0 removable, 5 nonremovable row versions in 1 pages
index "pg_namespace_nspname_index" now contains 5 row versions in 2 pages
index "pg_namespace_oid_index" now contains 5 row versions in 2 pages
"pg_namespace": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_namespace"
"pg_namespace": scanned 1 of 1 pages, containing 5 live rows and 0 dead rows; 5 rows in sample, 5 estimated total rows
vacuuming "pg_catalog.pg_conversion"
"pg_conversion": found 0 removable, 124 nonremovable row versions in 2 pages
index "pg_conversion_default_index" now contains 124 row versions in 2 pages
index "pg_conversion_name_nsp_index" now contains 124 row versions in 4 pages
index "pg_conversion_oid_index" now contains 124 row versions in 2 pages
"pg_conversion": moved 0 row versions, truncated 2 to 2 pages
analyzing "pg_catalog.pg_conversion"
"pg_conversion": scanned 2 of 2 pages, containing 124 live rows and 0 dead rows; 124 rows in sample, 124 estimated total rows
vacuuming "pg_catalog.pg_depend"
"pg_depend": found 0 removable, 4440 nonremovable row versions in 37 pages
index "pg_depend_depender_index" now contains 4440 row versions in 20 pages
index "pg_depend_reference_index" now contains 4440 row versions in 20 pages
analyzing "pg_catalog.pg_depend"
"pg_depend": scanned 37 of 37 pages, containing 4440 live rows and 0 dead rows; 3000 rows in sample, 4440 estimated total rows
vacuuming "pg_catalog.pg_tablespace"
"pg_tablespace": found 0 removable, 2 nonremovable row versions in 1 pages
index "pg_tablespace_oid_index" now contains 2 row versions in 2 pages
index "pg_tablespace_spcname_index" now contains 2 row versions in 2 pages
"pg_tablespace": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_tablespace"
"pg_tablespace": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows
vacuuming "pg_catalog.pg_pltemplate"
"pg_pltemplate": found 0 removable, 6 nonremovable row versions in 1 pages
index "pg_pltemplate_name_index" now contains 6 row versions in 2 pages
"pg_pltemplate": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_pltemplate"
"pg_pltemplate": scanned 1 of 1 pages, containing 6 live rows and 0 dead rows; 6 rows in sample, 6 estimated total rows
vacuuming "pg_catalog.pg_shdepend"
"pg_shdepend": found 0 removable, 1 nonremovable row versions in 1 pages
index "pg_shdepend_depender_index" now contains 1 row versions in 2 pages
index "pg_shdepend_reference_index" now contains 1 row versions in 2 pages
"pg_shdepend": moved 0 row versions, truncated 1 to 1 pages
analyzing "pg_catalog.pg_shdepend"
"pg_shdepend": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows
vacuuming "pg_catalog.pg_shdescription"
"pg_shdescription": found 0 removable, 1 nonremovable row versions in 1 pages
index "pg_shdescription_o_c_index" now contains 1 row versions in 2 pages
"pg_shdescription": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_2396"
"pg_toast_2396": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_2396_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_shdescription"
"pg_shdescription": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows
vacuuming "pg_catalog.pg_database"
"pg_database": found 0 removable, 4 nonremovable row versions in 1 pages
index "pg_database_datname_index" now contains 4 row versions in 2 pages
index "pg_database_oid_index" now contains 4 row versions in 2 pages
"pg_database": moved 0 row versions, truncated 1 to 1 pages
vacuuming "pg_toast.pg_toast_1262"
"pg_toast_1262": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_toast_1262_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_database"
"pg_database": scanned 1 of 1 pages, containing 4 live rows and 0 dead rows; 4 rows in sample, 4 estimated total rows
vacuuming "pg_catalog.pg_auth_members"
"pg_auth_members": found 0 removable, 0 nonremovable row versions in 0 pages
index "pg_auth_members_role_member_index" now contains 0 row versions in 1 pages
index "pg_auth_members_member_role_index" now contains 0 row versions in 1 pages
analyzing "pg_catalog.pg_auth_members"
"pg_auth_members": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
vacuuming "public.outside_hum"
"outside_hum": found 0 removable, 5198 nonremovable row versions in 34 pages
index "outside_hum_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_outside_hum" now contains 5198 row versions in 17 pages
"outside_hum": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.outside_hum"
"outside_hum": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.windforce"
"windforce": found 0 removable, 5198 nonremovable row versions in 34 pages
index "windforce_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_windforce" now contains 5198 row versions in 17 pages
"windforce": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.windforce"
"windforce": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.rainfall"
"rainfall": found 0 removable, 5198 nonremovable row versions in 39 pages
index "rainfall_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_rainfall" now contains 5198 row versions in 17 pages
"rainfall": moved 0 row versions, truncated 39 to 39 pages
analyzing "public.rainfall"
"rainfall": scanned 39 of 39 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.sunshine"
"sunshine": found 0 removable, 5198 nonremovable row versions in 39 pages
index "sunshine_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_sunshine" now contains 5198 row versions in 17 pages
"sunshine": moved 0 row versions, truncated 39 to 39 pages
analyzing "public.sunshine"
"sunshine": scanned 39 of 39 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.inside_temp"
"inside_temp": found 0 removable, 5198 nonremovable row versions in 34 pages
index "inside_temp_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_inside_temp" now contains 5198 row versions in 17 pages
"inside_temp": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.inside_temp"
"inside_temp": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.inside_hum"
"inside_hum": found 0 removable, 5198 nonremovable row versions in 34 pages
index "inside_hum_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_inside_hum" now contains 5198 row versions in 17 pages
"inside_hum": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.inside_hum"
"inside_hum": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.airpressure"
"airpressure": found 0 removable, 5198 nonremovable row versions in 34 pages
index "airpressure_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_airpressure" now contains 5198 row versions in 17 pages
"airpressure": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.airpressure"
"airpressure": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp1"
"temp1": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp1_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp1" now contains 5198 row versions in 17 pages
"temp1": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp1"
"temp1": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum1"
"hum1": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum1_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum1" now contains 5198 row versions in 17 pages
"hum1": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum1"
"hum1": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp2"
"temp2": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp2_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp2" now contains 5198 row versions in 17 pages
"temp2": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp2"
"temp2": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum2"
"hum2": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum2_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum2" now contains 5198 row versions in 17 pages
"hum2": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum2"
"hum2": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp3"
"temp3": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp3_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp3" now contains 5198 row versions in 17 pages
"temp3": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp3"
"temp3": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum3"
"hum3": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum3_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum3" now contains 5198 row versions in 17 pages
"hum3": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum3"
"hum3": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp4"
"temp4": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp4_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp4" now contains 5198 row versions in 17 pages
"temp4": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp4"
"temp4": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum4"
"hum4": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum4_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum4" now contains 5198 row versions in 17 pages
"hum4": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum4"
"hum4": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp5"
"temp5": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp5_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp5" now contains 5198 row versions in 17 pages
"temp5": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp5"
"temp5": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum5"
"hum5": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum5_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum5" now contains 5198 row versions in 17 pages
"hum5": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum5"
"hum5": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp6"
"temp6": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp6_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp6" now contains 5198 row versions in 17 pages
"temp6": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp6"
"temp6": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum6"
"hum6": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum6_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum6" now contains 5198 row versions in 17 pages
"hum6": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum6"
"hum6": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp7"
"temp7": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp7_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp7" now contains 5198 row versions in 17 pages
"temp7": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp7"
"temp7": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum7"
"hum7": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum7_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum7" now contains 5198 row versions in 17 pages
"hum7": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum7"
"hum7": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.temp8"
"temp8": found 0 removable, 5198 nonremovable row versions in 34 pages
index "temp8_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_temp8" now contains 5198 row versions in 17 pages
"temp8": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.temp8"
"temp8": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.hum8"
"hum8": found 0 removable, 5198 nonremovable row versions in 34 pages
index "hum8_pkey" now contains 5198 row versions in 17 pages
index "index_savetime_hum8" now contains 5198 row versions in 17 pages
"hum8": moved 0 row versions, truncated 34 to 34 pages
analyzing "public.hum8"
"hum8": scanned 34 of 34 pages, containing 5198 live rows and 0 dead rows; 3000 rows in sample, 5198 estimated total rows
vacuuming "public.weatherwilli"
"weatherwilli": found 0 removable, 0 nonremovable row versions in 0 pages
index "weatherwilli_pkey" now contains 0 row versions in 1 pages
index "index_savetime_weatherwilli" now contains 0 row versions in 1 pages
analyzing "public.weatherwilli"
"weatherwilli": scanned 0 of 0 pages, containing 0 live rows and 0 dead rows; 0 rows in sample, 0 estimated total rows
free space map contains 1 pages in 2 relations
table "pg_class" was reindexed
table "winddirection" was reindexed
table "sql_packages" was reindexed
table "sql_parts" was reindexed
table "sql_sizing" was reindexed
table "sql_sizing_profiles" was reindexed
table "sql_features" was reindexed
table "sql_implementation_info" was reindexed
table "sql_languages" was reindexed
table "pg_statistic" was reindexed
table "outside_temp" was reindexed
table "pg_type" was reindexed
table "pg_attribute" was reindexed
table "pg_proc" was reindexed
table "pg_autovacuum" was reindexed
table "pg_attrdef" was reindexed
table "pg_constraint" was reindexed
table "pg_inherits" was reindexed
table "pg_index" was reindexed
table "pg_operator" was reindexed
table "pg_opclass" was reindexed
table "pg_am" was reindexed
table "pg_amop" was reindexed
table "pg_amproc" was reindexed
table "pg_language" was reindexed
table "pg_largeobject" was reindexed
table "pg_aggregate" was reindexed
table "pg_rewrite" was reindexed
table "pg_trigger" was reindexed
table "pg_description" was reindexed
table "pg_cast" was reindexed
table "pg_namespace" was reindexed
table "pg_conversion" was reindexed
table "pg_depend" was reindexed
table "outside_hum" was reindexed
table "windforce" was reindexed
table "rainfall" was reindexed
table "sunshine" was reindexed
table "inside_temp" was reindexed
table "inside_hum" was reindexed
table "airpressure" was reindexed
table "temp1" was reindexed
table "hum1" was reindexed
table "temp2" was reindexed
table "hum2" was reindexed
table "temp3" was reindexed
table "hum3" was reindexed
table "temp4" was reindexed
table "hum4" was reindexed
table "temp5" was reindexed
table "hum5" was reindexed
table "temp6" was reindexed
table "hum6" was reindexed
table "temp7" was reindexed
table "hum7" was reindexed
table "temp8" was reindexed
table "hum8" was reindexed
table "weatherwilli" was reindexed
EXTRACT(EPOCH FROM a.savetime)as Tstamp,
a.weatherdata AS outdoor_temp, b.weatherdata AS outdoor_hum,
g.weatherdata AS indoor_temp, h.weatherdata AS indoor_hum, c.raincounter as rainfall,
c.counteramount, d.weatherdata AS airpressure, e.degree as winddirection,i.counteramount as SolarRad ,
e.fluctuation, f.weatherdata AS wind
FROM outside_temp a, outside_hum b,inside_temp g, inside_hum h, rainfall c,
airpressure d, winddirection e, windforce f,sunshine i
WHERE a.savetime = b.savetime AND a.savetime = c.savetime AND a.savetime = d.savetime
AND a.savetime = e.savetime AND a.savetime = f.savetime AND a.savetime = g.savetime AND a.savetime = h.savetime AND a.savetime = i.savetime and EXTRACT(EPOCH FROM savetime)
Dernière modification par jturlier le dim. déc. 06, 2009 10:33 pm, modifié 2 fois.
La fonction de maintenance est utile qd tu as de grosses bases (> 500000 enregistrements, très fractionnés car souvent mis à jour, ou ds le cas de pb particulier. C'est une opératiion qui peut être faite une à 2 fois par an
ERROR: syntax error at or near "EXTRACT"
LINE 3: EXTRACT(EPOCH FROM a.savetime)as Tstamp,
^
********** Erreur **********
ERROR: syntax error at or near "EXTRACT"
État SQL :42601
Caractère : 23
celà evolue , non ?
michel
TEXTE
REATE VIEW Meteo as
EXTRACT(EPOCH FROM a.savetime)as Tstamp,
a.weatherdata AS outdoor_temp, b.weatherdata AS outdoor_hum,
g.weatherdata AS indoor_temp, h.weatherdata AS indoor_hum, c.raincounter as rainfall,
c.counteramount, d.weatherdata AS airpressure, e.degree as winddirection,i.counteramount as SolarRad ,
e.fluctuation, f.weatherdata AS wind
FROM outside_temp a, outside_hum b,inside_temp g, inside_hum h, rainfall c,
airpressure d, winddirection e, windforce f,sunshine i
WHERE a.savetime = b.savetime AND a.savetime = c.savetime AND a.savetime = d.savetime
AND a.savetime = e.savetime AND a.savetime = f.savetime AND a.savetime = g.savetime AND a.savetime = h.savetime AND a.savetime = i.savetime and EXTRACT(EPOCH FROM savetime)
