From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 9275 invoked by alias); 17 Jul 2002 14:17:01 -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 9131 invoked from network); 17 Jul 2002 14:16:59 -0000 Received: from unknown (HELO smtp3.ihug.com.au) (203.109.250.76) by sources.redhat.com with SMTP; 17 Jul 2002 14:16:59 -0000 Received: from p618-tnt1.mel.ihug.com.au (postgresql.org) [203.173.162.110] by smtp3.ihug.com.au with esmtp (Exim 3.22 #1 (Debian)) id 17Upbn-0006Ll-00; Thu, 18 Jul 2002 00:16:53 +1000 Message-ID: <3D357C50.2977DB75@postgresql.org> Date: Wed, 17 Jul 2002 07:17:00 -0000 From: Justin Clift X-Accept-Language: en MIME-Version: 1.0 To: Permaine Cheung CC: mikezang@yahoo.co.jp, rhdb@sources.redhat.com Subject: Re: About postgresql-dump References: <00aa01c22d9b$6aaf9d70$f90e10ac@toronto.redhat.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-SW-Source: 2002-q3/txt/msg00002.txt.bz2 Hi Permaine, Although pg_dump is the generic database dumping utility, you really need to use pg_dumpall when doing a complete database migration. pg_dumpall also dumps out the user and group information for the database(s) which pg_dump by itself doesn't. Hope that's useful. :-) Regards and best wishes, Justin Clift Permaine Cheung wrote: > > 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 -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi