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
ii postgresql 7.2.1-2woody5 Object-relational SQL database,
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....
Load the dump....
psql -d myotherdb -f mydb.out
psql:mydb.out:4: \connect: FATAL 1: IDENT authentication failed for
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?
pgsql-sql by date
|Next:||From: Greg Stark||Date: 2004-08-23 03:52:01|
|Subject: Re: sleep function|
|Previous:||From: Greg Stark||Date: 2004-08-22 19:58:23|
|Subject: Re: reply to setting|