From: Richard Huxton <dev@archonet.com>
To: worik@noggon.com
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump/pg_restore question
Date: Mon, 23 Aug 2004 08:56:51 +0100
Message-ID: <4129A343.5020702@archonet.com> (raw)
In-Reply-To: <41295D87.6080806@noggon.com>
References: <41295D87.6080806@noggon.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: dev@archonet.com, worik@noggon.com
Subject: Re: pg_dump/pg_restore question
In-Reply-To: <4129A343.5020702@archonet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox