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
