From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 30702 invoked by alias); 17 Jul 2002 14:05:36 -0000 Mailing-List: contact rhdb-help@sources.redhat.com; run by ezmlm Precedence: bulk List-Subscribe: List-Post: List-Help: , Sender: rhdb-owner@sources.redhat.com Received: (qmail 30692 invoked from network); 17 Jul 2002 14:05:36 -0000 Received: from unknown (HELO touchme.toronto.redhat.com) (216.138.202.10) by sources.redhat.com with SMTP; 17 Jul 2002 14:05:36 -0000 Received: from toffee (unknown [172.16.14.249]) by touchme.toronto.redhat.com (Postfix) with SMTP id 71FAFB8049; Wed, 17 Jul 2002 10:05:35 -0400 (EDT) Message-ID: <00aa01c22d9b$6aaf9d70$f90e10ac@toronto.redhat.com> From: "Permaine Cheung" To: Cc: Subject: Re: About postgresql-dump Date: Wed, 17 Jul 2002 07:05:00 -0000 MIME-Version: 1.0 Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-SW-Source: 2002-q3/txt/msg00001.txt.bz2 Hi Zhengrong, The utility that you are looking for is pg_dump, you can find the location of that utility by issuing the following command: which pg_dump Since the postgresql version has been upgraded from 7.1 to 7.2 with the OS upgrade, you'll need to dump and restore the data by using pg_dump. There are man pages that describe the different options for pg_dump that you may find helpful. Cheers, Permaine > -------- Original Message -------- > Subject: About postgresql-dump > Date: Wed, 17 Jul 2002 17:27:45 +0900 (JST) > From: > To: rhdb@sources.redhat.com > > I upgraded RH7.2 to 73, but I forgot to dump database, so that I need > postgesql-dump to do it, I couldn't find that utility even if I installed > all packages of postgresql 7.2, including posthesql-server and so on. > Now my postgresql can't executed, I have to upgrade database offline, Doesn > anyone help me? > > Zhengrong