Nee, habe da nichts geändert
Ich habe den Debug-Level mal auf 5 gestellt und
jetzt zeigt er auch wirklich ALLES im logfile an.
Aber ich glaube, das sieht alles ganz normal auf,
er diconnected halt nach ner sekunde???
Ich verstehe das echt nicht, ich hab nichts
geändert.
Soll ich das Logfile mal Posten?
hat aber für jeden Login gleich 500 neue Zeilen…
Ich versuch mal die relevanten Stellen rauszufinden:
DATENBANK-START
DEBUG: -----------------------------------------
DEBUG: postmaster: PostmasterMain: initial environ dump:
DEBUG: -----------------------------------------
DEBUG: PGDATA=/var/postgresql/data
DEBUG: PATH=/usr/bin:/bin:/usr/sbin:/sbin:/usr/X11R6/bin:/usr/local/bin
DEBUG: SHELL=/bin/sh
DEBUG: USER=_postgresql
DEBUG: PGSYSCONFDIR=/etc/postgresql
DEBUG: HOME=/var/postgresql
DEBUG: LOGNAME=_postgresql
DEBUG: LC_COLLATE=C
DEBUG: LC_CTYPE=C
DEBUG: LC_MESSAGES=C
DEBUG: LC_MONETARY=C
DEBUG: LC_NUMERIC=C
DEBUG: LC_TIME=C
DEBUG: -----------------------------------------
DEBUG: invoking IpcMemoryCreate(size=9519104)
DEBUG: max_safe_fds = 111, usable_fds = 121, already_open = 7
LOG: database system was shut down at 2006-03-30 11:14:51 UTC
LOG: checkpoint record is at 0/A80B2C
LOG: redo record is at 0/A80B2C; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 961; next OID: 17236
LOG: database system is ready
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
DEBUG: reaping dead processes
LOG: received SIGHUP, reloading configuration files
EINLOGGEN ÜBER PHPPGADMIN
DEBUG: forked new backend, pid=25299 socket=8
LOG: connection received: host=127.0.0.1 port=11978
DEBUG: received password packet
LOG: connection authorized: user=yves database=template1
DEBUG: postmaster child[25299]: starting with (
DEBUG: postgres
DEBUG: -v196608
DEBUG: -p
DEBUG: template1
DEBUG: )
DEBUG: InitPostgres
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 961/1/0, nestlvl: 1, children: <>
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 961/1/0, nestlvl: 1, children: <>
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 962/1/0, nestlvl: 1, children: <>
LOG: statement: set datestyle=‘ISO’
DEBUG: parse tree:
DETAIL: {QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :rowMarks <> :targetList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
:setOperations <> :resultRelations <>}
DEBUG: rewritten parse tree:
DETAIL: ({QUERY :commandType 5 :querySource 0 :canSetTag true :utilityStmt ?
:resultRelation 0 :into <> :hasAggs false :hasSubLinks false :rtable <>
:jointree <> :rowMarks <> :targetList <> :groupClause <> :havingQual <>
:distinctClause <> :sortClause <> :limitOffset <> :limitCount <>
:setOperations <> :resultRelations <>})
DEBUG: ProcessUtility
DEBUG: CommitTransactionCommand
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 962/1/0, nestlvl: 1, children: <>
DEBUG: StartTransactionCommand
DEBUG: StartTransaction
DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 963/1/0, nestlvl: 1, children: <>
LOG: statement: SELECT pdb.datname AS datname, pu.usename AS datowner, pg_encoding_to_char(encoding) AS datencoding,
(SELECT description FROM pg_description pd WHERE pdb.oid=pd.objoid) AS datcomment,
(SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pdb.dattablespace) AS tablespace
FROM pg_database pdb, pg_user pu
WHERE pdb.datdba = pu.usesysid
AND NOT pdb.datistemplate
ORDER BY pdb.datname
DAS ENDE
DEBUG: CommitTransactionCommand
DEBUG: CommitTransaction
DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 964/1/0, nestlvl: 1, children: <>
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
LOG: disconnection: session time: 0:00:01.55 user=yves database=template1 host=127.0.0.1 port=11978
DEBUG: exit(0)
DEBUG: reaping dead processes
DEBUG: server process (PID 25299) exited with exit code 0