Re: pg_dump/pg_restore question

Worik wrote:
> 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