Pomoc - Szukaj - Użytkownicy - Kalendarz
Pełna wersja: Potrzebuje loga
Forum PHP.pl > Forum > Bazy danych > PostgreSQL
szajba7
24.03.2007, 17:48:47
Witam !
Wiem ze to dziwny request, ale potrzebuje jakiegos log'a z postgres'a. Nie mam obecnie mozliwosci zainstalowania bazy, a log jest mi potrzebny do zrobienia zadania a'la 'napisz program analizujacy log pgsql'a'. Napisanie programu to pikus, najciezsze okazalo sie zdobycie takiego log'a biggrin.gif
Bardzo prosilbym w miare mozliwosci o umieszczenie jakiegos kawalka (nie musi to byc jakis debug5 tongue.gif) i mam nadzieje ze nikt mnie nie pobije za takie cos... Pozdrawiam !
jezoo
26.03.2007, 08:47:31
prosze Ciebie bardzo, jak bedziesz mial malo to pisz smile.gif
Cytat(PGSQL_log)
2007-03-26 08:28:47 CEST LOG: transaction ID wrap limit is 2147484146, limited by database "postgres"
2007-03-26 08:29:47 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:30:52 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:31:02 CEST NOTICE: CREATE TABLE will create implicit sequence "teksty_id_seq" for serial column "teksty.id"
2007-03-26 08:31:02 CEST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "teksty_pkey" for table "teksty"
2007-03-26 08:31:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:32:52 CEST NOTICE: CREATE TABLE will create implicit sequence "uzytkownicy_id_seq" for serial column "uzytkownicy.id"
2007-03-26 08:32:52 CEST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "uzytkownicy_pkey" for table "uzytkownicy"
2007-03-26 08:32:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:33:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:34:42 CEST NOTICE: CREATE TABLE will create implicit sequence "menu_id_seq" for serial column "menu.id"
2007-03-26 08:34:42 CEST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "menu_pkey" for table "menu"
2007-03-26 08:34:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:35:52 CEST NOTICE: CREATE TABLE will create implicit sequence "submenu_id_seq" for serial column "submenu.id"2007-03-26 08:35:52 CEST NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "submenu_pkey" for table "submenu"
2007-03-26 08:35:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:36:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:37:28 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 08:37:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:38:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:39:48 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 08:39:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:40:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:41:49 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 08:41:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:42:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:43:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:44:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:45:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:46:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:47:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:48:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:49:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:50:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:51:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:52:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:53:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:54:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:55:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 08:56:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 08:57:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 08:58:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 08:59:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:00:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:01:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:02:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:03:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:04:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:05:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:06:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:07:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:08:20 CEST ERROR: syntax error at or near "'select menu.id, submenu.id, menu.kategorie, submenu.podkategorie, submenu.link from menu, submenu;'" at character 37
2007-03-26 09:08:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:09:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:10:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:11:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:12:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:13:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:14:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:15:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:16:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:17:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:18:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:19:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:20:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:21:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:22:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:23:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:24:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:25:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:26:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:27:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:28:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:29:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:30:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:31:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:32:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:33:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:34:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 09:35:53 CEST LOG: autovacuum: processing database "template1"
2007-03-26 09:36:53 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 09:37:53 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 09:38:53 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 10:02:01 CEST LOG: incomplete startup packet
2007-03-26 10:32:01 CEST LOG: autovacuum: processing database "template1"
2007-03-26 10:32:15 CEST ERROR: no language specified
2007-03-26 10:32:35 CEST ERROR: syntax error at or near "kategoria" at character 38
2007-03-26 10:32:48 CEST ERROR: syntax error at or near "int" at character 44
2007-03-26 10:33:01 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 10:34:01 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 10:34:28 CEST ERROR: column menu.kategorie does not exist
2007-03-26 10:34:28 CEST CONTEXT: SQL function "menu"
2007-03-26 10:35:01 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 10:35:10 CEST ERROR: return type mismatch in function declared to return character
2007-03-26 10:35:10 CEST DETAIL: Final SELECT must return exactly one column.
2007-03-26 10:35:10 CEST CONTEXT: SQL function "menu"
2007-03-26 10:35:44 CEST ERROR: syntax error at or near ";" at character 35
2007-03-26 10:36:01 CEST LOG: autovacuum: processing database "template1"
2007-03-26 10:36:27 CEST ERROR: syntax error at or near "r" at character 1
2007-03-26 10:37:01 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 10:37:45 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 10:38:01 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 10:38:23 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 10:39:01 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 10:39:06 CEST ERROR: syntax error at or near "," at character 35
2007-03-26 10:40:01 CEST LOG: autovacuum: processing database "template1"
2007-03-26 10:41:01 CEST LOG: autovacuum: processing database "postgres"
2007-03-26 10:42:01 CEST LOG: autovacuum: processing database "hurtownia"
2007-03-26 10:42:17 CEST ERROR: syntax error at or near "," at character 33
2007-03-26 10:42:26 CEST ERROR: syntax error at or near "," at character 34
2007-03-26 10:42:34 CEST ERROR: syntax error at or near "," at character 34
2007-03-26 10:42:40 CEST ERROR: return type mismatch in function declared to return character
2007-03-26 10:42:40 CEST DETAIL: Final SELECT must return exactly one column.
2007-03-26 10:42:40 CEST CONTEXT: SQL function "cc"
2007-03-26 10:43:01 CEST LOG: autovacuum: processing database "fpon"
2007-03-26 10:43:14 CEST ERROR: syntax error at or near ";" at character 18
2007-03-26 10:44:01 CEST LOG: autovacuum: processing database "template1"
2007-03-26 10:45:01 CEST LOG: autovacuum: processing database "postgres"
To jest wersja lo-fi głównej zawartości. Aby zobaczyć pełną wersję z większą zawartością, obrazkami i formatowaniem proszę kliknij tutaj.
Invision Power Board © 2001-2025 Invision Power Services, Inc.