Hi Suresh, you should Cc: pgsql-admin@postgresql.org in case I don't know or someone else can help you sooner.
I am using on prod server with psql version : psql 7.4.2 > > In another test server the version of psql is : Portions Copyright (c) > 1996-2003, (could not get version) > You should figure out what version you're running. You can run psql --version in a terminal to figure that out. Make sure you're running the latest revision of whatever major version you choose (8.2.5, for instance). > I could run this command on test server but couldn't run on prod server. > May I have some help? Where commercelink is my database name. We use to > enter into database like this "psql commercelink". > pg_dumpall dumps an entire database cluster, not just a database. Either omit the database name or use pg_dump instead of pg_dumpall. Peter
