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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2004-08-23 03:52:01 | Re: sleep function |
Previous Message | Greg Stark | 2004-08-22 19:58:23 | Re: reply to setting |