From: Worik <worik@noggon.com>
To: pgsql-sql@postgresql.org
Subject: pg_dump/pg_restore question
Date: Mon, 23 Aug 2004 14:59:19 +1200
Message-ID: <41295D87.6080806@noggon.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: worik@noggon.com
Subject: Re: pg_dump/pg_restore question
In-Reply-To: <41295D87.6080806@noggon.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox