user authentication & database destroy failed !
От | Ralf Weidemann |
---|---|
Тема | user authentication & database destroy failed ! |
Дата | |
Msg-id | 13995.63101.977564.68071@onyx.nowhere.net обсуждение исходный текст |
Ответ на | User authentication failed ! (Ralf Weidemann <RalfW@Scalar.DE>) |
Список | pgsql-general |
Hi, I'm running a fresh build of pgsql 6.4.2 on LinuxPPC R4 (kernel 2.2pre4). Building went fine and I con- figured pgsql with: ./configure --prefix=/opt/wdb --enable-hba --enable-locale --with-tcl --with-perl --with-x But after some playing I discovered that I can't de- stroy any databases. ---- [wdba@onyx wdba]$ createdb test3 [wdba@onyx wdba]$ destroydb test3 ERROR: typeidTypeRelid: Invalid type - oid = 0 ERROR: typeidTypeRelid: Invalid type - oid = 0 destroydb: database destroy failed on test3. ---- Also user authentication failed. I'm not sure, maybe I did something wrong here ? ---- [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]$ ---- [Sorry if this already arrived the list, but since I didn't get it myself in the last 24h, I think something went wrong..] Thanks, Ralf
В списке pgsql-general по дате отправления: