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 26B519DC812 for ; Thu, 15 Dec 2005 12:52:57 -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 43088-01 for ; Thu, 15 Dec 2005 12:52:56 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 43B359DC807 for ; Thu, 15 Dec 2005 12:52:55 -0400 (AST) Received: from pop0.greatbasin.net (pop0.greatbasin.net [207.228.35.2]) by svr4.postgresql.org (Postfix) with ESMTP id D9BD45AF04F for ; Thu, 15 Dec 2005 16:52:54 +0000 (GMT) Received: from [172.16.1.124] (rno-dsl0b-131.gbis.net [216.82.145.131]) by pop0.greatbasin.net (8.12.10/8.12.10) with ESMTP id jBFGqgkP028942; Thu, 15 Dec 2005 08:52:42 -0800 In-Reply-To: <1134653856.14515.2.camel@pgbuildfarm.gunduz.org> References: <4a9605050512141700m4b7c9fbbn957aa286cf347323@mail.gmail.com> <1134653856.14515.2.camel@pgbuildfarm.gunduz.org> Mime-Version: 1.0 (Apple Message framework v623) Content-Type: text/plain; charset=US-ASCII; format=flowed Message-Id: <36cbf801a4622fe3a39da70efdd96146@wellsgaming.com> Content-Transfer-Encoding: 7bit Cc: Muhammad Farid From: Dianne Yumul Subject: Re: backup Date: Thu, 15 Dec 2005 08:52:42 -0800 To: pgsql-admin@postgresql.org X-Mailer: Apple Mail (2.623) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200512/152 X-Sequence-Number: 19872 >> database itself using command pgsql < db name > . It should be psql (not pgsql), at least on versions greater than 7.3. And I agree, postgresql 7.2.2 is pretty outdated. hope this helps. On Dec 15, 2005, at 5:37 AM, Devrim GUNDUZ wrote: > 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/ > > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >