X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 9507C9DC819 for ; Thu, 15 Dec 2005 09:31:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 03257-02 for ; Thu, 15 Dec 2005 09:31:54 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.kivi.com.tr (mail.kivi.com.tr [213.143.254.37]) by postgresql.org (Postfix) with ESMTP id CD6579DC807 for ; Thu, 15 Dec 2005 09:31:48 -0400 (AST) Received: from pgbuildfarm.gunduz.org (unknown [212.174.30.202]) by mail.kivi.com.tr (Postfix) with ESMTP id 8B3DD8000F; Thu, 15 Dec 2005 15:31:33 +0200 (EET) Subject: Re: backup From: Devrim GUNDUZ To: Muhammad Farid Cc: "pgsql-admin@postgresql.org" In-Reply-To: <4a9605050512141700m4b7c9fbbn957aa286cf347323@mail.gmail.com> References: <4a9605050512141700m4b7c9fbbn957aa286cf347323@mail.gmail.com> Content-Type: text/plain Organization: Command Prompt Inc. Date: Thu, 15 Dec 2005 15:37:36 +0200 Message-Id: <1134653856.14515.2.camel@pgbuildfarm.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.2.3 (2.2.3-2.fc4) Content-Transfer-Encoding: 7bit X-Kivi-MailScanner-Information: Please contact the ISP for more information X-Kivi-MailScanner: Found to be clean X-Kivi-MailScanner-SpamCheck: not spam, SpamAssassin (score=1.842, required 6, autolearn=disabled, FORGED_RCVD_HELO 0.05, RCVD_IN_NJABL_DUL 1.66, RCVD_IN_SORBS_DUL 0.14) X-Kivi-MailScanner-SpamScore: 1 X-Kivi-MailScanner-From: devrim@commandprompt.com X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.024 required=5 tests=[AWL=0.024] X-Spam-Score: 0.024 X-Spam-Level: X-Archive-Number: 200512/149 X-Sequence-Number: 19869 Hi, On Thu, 2005-12-15 at 09:00 +0800, Muhammad Farid wrote: > I have installed Suse Linux Opeb Excchange server and its running > using postgresql-7.2.2-35. And my problem here is i cant log in to the > database itself using command pgsql < db name > . What kind of an error message you get? > And also please teach me what is the command to manually backup the > database in postgresql ? Use pg_dump. BTW... Your PostgreSQL version is outdated and is not supported by community (I'm not sure whether SuSE supports it or not). You should update to a newer version. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: PL/php, plPerlNG - http://www.commandprompt.com/