Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id C71D49F98C8 for ; Sat, 3 Nov 2007 20:39:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31811-02 for ; Sat, 3 Nov 2007 20:39:03 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.179]) by postgresql.org (Postfix) with ESMTP id CD66F9F98C5 for ; Sat, 3 Nov 2007 20:39:02 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id m38so1669751waf for ; Sat, 03 Nov 2007 16:39:01 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=NlWDmQ/TRTVF8oE9hD8ZnhYZzKOam3rDlbyX4Be0Gfg=; b=M1immAqXux6HO8NN8KuY2WGa/VjiJnYM3uA+SRoV1u2+hJLDKDMvBDHBd2VEOR5KNdymaCbztM3YJCjaGNQu4RMhQFeukyNT5DDZc7PDYnGbUumEfBkwQsg+z3pHrNAJtlpKUhNRY4k+XlZbXSt74ckKFLhTSR0iNPmRIfy3R4U= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=OXrWVg/5y0XcY+P+Q9TGLE8ZZxH3YfB0r3STFoYDEMEprgh75gJZtISG3RkgTvbHQz2Hgwka3/C1YalbfIGIChtenttE9s7sIk0HnZh+TmwhuT+3AZmFJ/0zsQAnmAHSHhH671rlK9ce7Z/lLh1/PwyB+QjM4vxW46r0ZLXIv6k= Received: by 10.114.175.16 with SMTP id x16mr3501415wae.1194133141126; Sat, 03 Nov 2007 16:39:01 -0700 (PDT) Received: by 10.114.197.19 with HTTP; Sat, 3 Nov 2007 16:39:01 -0700 (PDT) Message-ID: <4544e0330711031639m1da04081j5d86ef21ff32270@mail.gmail.com> Date: Sat, 3 Nov 2007 18:39:01 -0500 From: "Peter Koczan" To: "Suresh Gupta VG" Subject: Re: Postgresql pg_dumpall Cc: "pgsql-admin@postgresql.org" In-Reply-To: <3D5445983859B84B92669C0D883EA6FB0AF4AD16@ZENMAILHQ1.ind.zensar.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_25075_8746190.1194133141121" References: <3D5445983859B84B92669C0D883EA6FB0AF4AD16@ZENMAILHQ1.ind.zensar.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200711/39 X-Sequence-Number: 27282 ------=_Part_25075_8746190.1194133141121 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_25075_8746190.1194133141121 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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
------=_Part_25075_8746190.1194133141121--