Thread: pg_dump problem

pg_dump problem

From
"Bob Nix"
Date:

I am trying to get pg_dump to work.  I suspect that I am doing something wrong - Here's my command, and the resulting message.

"postgres" owns the database and the tables; all tables were created under "postgres".
"postgres" has no password.

The database is named "demo".

=== my command ====
$ pg_dump -U postgres demo > demo.dump

=== resulting message ===
pg_dump: [archiver (db)] connection to database "demo" failed: FATAL:  IDENT authentication failed for user "postgres"

Bob Nix, Technical Analyst
IntraNexus, Inc.
bnix@intranexus.com
336-282-4415   Fax: 509-355-2669

Re: pg_dump problem

From
Paul Thomas
Date:
On 22/07/2003 16:30 Bob Nix wrote:
> I am trying to get pg_dump to work.  I suspect that I am doing something
> wrong - Here's my command, and the resulting message.
>
> "postgres" owns the database and the tables; all tables were created
> under "postgres".
> "postgres" has no password.
>
> The database is named "demo".
>
> === my command ====
> $ pg_dump -U postgres demo > demo.dump
>
> === resulting message ===
> pg_dump: [archiver (db)] connection to database "demo" failed: FATAL:
> IDENT authentication failed for user "postgres"

su to postgres from root should work but can be a PITA. I always create a
super user for a standard unix user (i.e. me on my development box) and
use that to create/own the databases. So the only time I actually need to
su postgres is during installation/setup.

HTH

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+