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