Message-ID: <4129A343.5020702@archonet.com>
Date: Mon, 23 Aug 2004 08:56:51 +0100
From: Richard Huxton <dev@archonet.com>
User-Agent: Mozilla Thunderbird 0.7 (X11/20040615)
MIME-Version: 1.0
To: worik@noggon.com
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump/pg_restore question
References: <41295D87.6080806@noggon.com>
In-Reply-To: <41295D87.6080806@noggon.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

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