From: Justin Clift <justin@postgresql.org>
To: Permaine Cheung <pcheung@redhat.com>
Cc: mikezang@yahoo.co.jp, rhdb@sources.redhat.com
Subject: Re: About postgresql-dump
Date: Wed, 17 Jul 2002 07:17:00 -0000 [thread overview]
Message-ID: <3D357C50.2977DB75@postgresql.org> (raw)
In-Reply-To: <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
next prev parent reply other threads:[~2002-07-17 14:17 UTC|newest]
Thread overview: 3+ messages / expand[flat|nested] mbox.gz Atom feed top
2002-07-17 7:05 Permaine Cheung
2002-07-17 7:17 ` Justin Clift [this message]
-- strict thread matches above, loose matches on Subject: below --
2002-07-17 1:27 mikezang
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=3D357C50.2977DB75@postgresql.org \
--to=justin@postgresql.org \
--cc=mikezang@yahoo.co.jp \
--cc=pcheung@redhat.com \
--cc=rhdb@sources.redhat.com \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).