This is the mail archive of the
rhdb@sources.redhat.com
mailing list for the RHDB project.
Re: About postgresql-dump
- From: Justin Clift <justin at postgresql dot org>
- To: Permaine Cheung <pcheung at redhat dot com>
- Cc: mikezang at yahoo dot co dot jp, rhdb at sources dot redhat dot com
- Date: Thu, 18 Jul 2002 00:16:48 +1000
- Subject: Re: About postgresql-dump
- References: <00aa01c22d9b$6aaf9d70$f90e10ac@toronto.redhat.com>
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