Re: About postgresql-dump

Re: About postgresql-dump

[Permaine Cheung]

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

Re: About postgresql-dump

[Justin Clift]

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

About postgresql-dump

[mikezang]

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/