Freinds
I am new to this list, and this is my first message.
I hope this is the correct forum, and the question not too stupid/simple.
I have a database on a debian stable system...
dpkg -l postgresql
[snip]
ii postgresql 7.2.1-2woody5 Object-relational SQL database, descended fr
When I dump a database (as from the man page for pg_restore) pg_dump mydb > mydb.out
OK. Get an SQL dump in mydb.out
Create a new database....
creatdb myotherdb
Load the dump....
psql -d myotherdb -f mydb.out
psql:mydb.out:4: \connect: FATAL 1: IDENT authentication failed for user "postgres"
I have tried adding the line host all 127.0.0.1 255.255.255.255 trust
to pg_hba.conf but it makes no difference.
Almost correct. You're not actually connecting over IP at all, you'll be using unix-sockets. Try a line something like:
local all all trust
Or, since you're on 7.2 probably
local all trust
HTH -- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
