[ADMIN] pg_dumps

[Pichelman, Scott]

Hi,   I was wondering how to use pg_dump, been having problems no matter what I use for options.   [EMAIL PROTECTED] /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.   [EMAIL PROTECTED] /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.   [EMAIL PROTECTED] /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   [EMAIL PROTECTED] /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