pg_dumps

Hi,

I was wondering how to use pg_dump, been having problems no matter what I use for options.

[admin@holt /root]$ pg_dump -h 127.0.0.1 -p 5432 admin -f holt_admin_db.dump

Connection to database 'admin' failed.

FATAL 1:  Database "admin" does not exist in the system catalog.

[admin@holt /root]$ pg_dump -h 127.0.0.1 -p 5432 ADMIN -f holt_admin_db.dump

Connection to database 'ADMIN' failed.

FATAL 1:  Database "ADMIN" does not exist in the system catalog.

[admin@holt /root]$ pg_dump -h 127.0.0.1 -p 5432 template0 -f holt_admin_db.dump

Connection to database 'template0' failed.

FATAL 1:  Database "template0" is not currently accepting connections

[admin@holt /root]$ pg_dump -h 127.0.0.1 -p 5432 template1 -f holt_admin_db.dump

getAggregates(): SELECT failed.  Explanation from backend: 'ERROR:  Attribute 'aggtransfn1' not found

I am the “admin” unix user and connect as pgsql user admin…

admin=> \c

You are now connected to database admin as user admin.

admin=> \l

  List of databases

 Database  |  Owner  

-----------+----------

 admin     | postgres

 template0 | postgres

 template1 | postgres

 test      | postgres

I have tried pg_dumpall as well w/ no luck.

Please help me understand what I am doing wrong!

Any help is appreciated.

TIA!

SP