pg_dump/pg_restore question
От | Worik |
---|---|
Тема | pg_dump/pg_restore question |
Дата | |
Msg-id | 41295D87.6080806@noggon.com обсуждение исходный текст |
Ответы |
Re: pg_dump/pg_restore question
|
Список | 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
В списке pgsql-sql по дате отправления: