pg_dumps

Hi,

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

[admin(at)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(at)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(at)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(at)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