pg_restore authentication failure

Started by Zeno Davatzover 23 years ago2 messagesgeneral
Jump to latest
#1Zeno Davatz
zdavatz@ywesee.com

Hi List

I done a pg_dumpall and now would like to load the data back into my new
database. I am doing:

psql -e nachahmer < /home/ywesee/pgsql/pgsqldump.sql

And get:
ERROR: Language plpgsql already exists
\connect: FATAL 1: IDENT authentication failed for user "nachahmer"

at the end of the message. Do you have any idea what could be wrong?

My pg_hba.conf is:
local all trust
host all 127.0.0.1 255.255.255.255 trust

Thanks for your help.
Zeno

#2Patrick Welche
prlw1@newn.cam.ac.uk
In reply to: Zeno Davatz (#1)
Re: pg_restore authentication failure

On Wed, Oct 02, 2002 at 04:35:28PM +0200, Zeno Davatz wrote:

Hi List

I done a pg_dumpall and now would like to load the data back into my new
database. I am doing:

psql -e nachahmer < /home/ywesee/pgsql/pgsqldump.sql

And get:
ERROR: Language plpgsql already exists
\connect: FATAL 1: IDENT authentication failed for user "nachahmer"

at the end of the message. Do you have any idea what could be wrong?

My pg_hba.conf is:
local all trust
host all 127.0.0.1 255.255.255.255 trust

I think there is a new USER column in pg_hba.conf.
cf src/backend/libpq/pg_hba.conf.sample

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
local all all trust
host all all 127.0.0.1 255.255.255.255 trust

Cheers,

Patrick