Hello to everyone, I'm new to postgres. I Have installed a new SuSE 9.2 on a pc. I also installed the Postgres which was on the suse-cd's. psql --version says: 7.4.7 PG_VERSION in /var/lib/psql/data says: 7.4 Here is an extract from my pg_hba.conf:
# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD #local all all trust # IPv4-style local connections: host all all 127.0.0.1 255.255.255.255 trust # IPv6-style local connections: host all all ::1 ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff trust #local all all ident sameuser local all all trust ~ ~ pg_hba.conf lines 44-64/64 (END) With this configuration my server starts without problems in runlevel 5. If i change the last line to: local all all password the server stops booting while writing "Starting postgres" to the console. Although the pc stops booting, the Databse Server starts, i can connect the pc via ssh, and open a psql-session. Also /var/log/postgresql says, the databse is ready. Nevertheless, the pc stops booting on the point "postgres is starting", and does not continue. For me this is very strange. Does anyone has an idea ? I think, a script or a service tries to connenct to database, but does not know the password. So it does not continue to boot. Thanks for your help. Bernd ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match