Re: About postgresql-dump

[Justin Clift <justin at postgresql dot org>]

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: <mikezang@yahoo.co.jp>
> > 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