* Re: About postgresql-dump
@ 2002-07-17 7:05 Permaine Cheung
2002-07-17 7:17 ` Justin Clift
0 siblings, 1 reply; 3+ messages in thread
From: Permaine Cheung @ 2002-07-17 7:05 UTC (permalink / raw)
To: mikezang; +Cc: rhdb
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
^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: About postgresql-dump
2002-07-17 7:05 About postgresql-dump Permaine Cheung
@ 2002-07-17 7:17 ` Justin Clift
0 siblings, 0 replies; 3+ messages in thread
From: Justin Clift @ 2002-07-17 7:17 UTC (permalink / raw)
To: Permaine Cheung; +Cc: mikezang, rhdb
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
^ permalink raw reply [flat|nested] 3+ messages in thread
* About postgresql-dump
@ 2002-07-17 1:27 mikezang
0 siblings, 0 replies; 3+ messages in thread
From: mikezang @ 2002-07-17 1:27 UTC (permalink / raw)
To: rhdb
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
--------------
RCX Controlled LEGO Train Projects
http://legochina.virtualave.net
__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/
^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2002-07-17 14:17 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2002-07-17 7:05 About postgresql-dump Permaine Cheung
2002-07-17 7:17 ` Justin Clift
-- strict thread matches above, loose matches on Subject: below --
2002-07-17 1:27 mikezang
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).