Skip site navigation (1) Skip section navigation (2)

pg_dump/pg_restore question

From: Worik <worik(at)noggon(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: pg_dump/pg_restore question
Date: 2004-08-23 02:59:19
Message-ID: 41295D87.6080806@noggon.com (view raw or flat)
Thread:
Lists: pgsql-sql
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.

The only thing I can do is edit the dump file into the part that wants 
to connect as postgres and the part that wants to connect as worik and 
run them under their respective logins.

How can I set it up so I do not have to do that?

What documentation should I be reading?

Worik

Responses

pgsql-sql by date

Next:From: Greg StarkDate: 2004-08-23 03:52:01
Subject: Re: sleep function
Previous:From: Greg StarkDate: 2004-08-22 19:58:23
Subject: Re: reply to setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group