User authentication failed !

Поиск
Список
Период
Сортировка
От Ralf Weidemann
Тема User authentication failed !
Дата
Msg-id 13995.44907.419561.783764@onyx.nowhere.net
обсуждение исходный текст
Ответы user authentication & database destroy failed !  (Ralf Weidemann <Finc01@DX1.HRZ.Uni-Dortmund.DE>)
Список pgsql-general
Hi,

can someone please tell me what's wrong here ??

Thanks,
Ralf


[wdba@onyx pgdata]$ cat pg_hba.conf
local        all                                       trust
host         all     192.168.0.0     255.255.255.255   password  passwd

[wdba@onyx pgdata]$ ping onyx
PING onyx.nowhere.net (192.168.1.1): 56 data bytes
64 bytes from 192.168.1.1: icmp_seq=0 ttl=255 time=0.2 ms
 --- onyx.nowhere.net ping statistics ---
1 packets transmitted, 1 packets received, 0% packet loss
round-trip min/avg/max = 0.2/0.2/0.2 ms

[wdba@onyx pgdata]$ pg_passwd passwd
File "passwd" does not exist.  Create? (y/n): y
Username: wdba
New password:
Re-enter new password:

[wdba@onyx pgdata]$ /opt/wdb/bin/postmaster -i -D /opt/wdb/var/pgdata > /opt/wdb/var/logs/postmaster.log 2>&1 &
[1] 1417

[wdba@onyx pgdata]$ psql -h onyx -u
Username: wdba
Password:

Connection to database 'wdba' failed.
User authentication failed

[wdba@onyx pgdata]$ psql
Welcome to the POSTGRESQL interactive sql monitor:
  Please read the file COPYRIGHT for copyright terms of POSTGRESQL

   type \? for help on slash commands
   type \q to quit
   type \g or terminate with semicolon to execute query
 You are currently connected to the database: wdba

wdba=> \q

[wdba@onyx pgdata]$



В списке pgsql-general по дате отправления:

Предыдущее
От: "Ryan Schutt"
Дата:
Сообщение: Re: [GENERAL] PostgreSQL and mod_perl trouble (spinlock)
Следующее
От: Ralf Weidemann
Дата:
Сообщение: user authentication & database destroy failed !