Re: 8.3.0 upgrade, confused by documentation

Hello Markus,

Fantastic! I have a few more (manual and reference)
pages to read, but I am definitely warming up to the
challenge.

Many thanks for your (and others') reply and thoughts.

Regards,

Tena Sakai
tsakai(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Markus Bertheau [mailto:mbertheau(dot)pg(at)googlemail(dot)com]
Sent: Wed 2/13/2008 8:57 AM
To: Tena Sakai
Cc: Peter Childs; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] 8.3.0 upgrade, confused by documentation

2008/2/13, Tena Sakai <tsakai(at)gallo(dot)ucsf(dot)edu>:

> b) keep the 8.2.4 up and running, but via pg_hab.conf
> make sure nobody can use the database.

That's basically up to you, you can leave it open. The backup will be
consistent, but it won't contain any changes made to the database
after pg_dumpall has been started.

> c) as user postgres, while environmental variables
> PGHOST and PGPORT is set correctly, execute the
> unix command below:
> (path_to_8.3.0)/pg_dumpall > data_saved

> Where I am fuzzy is step c). Ie., can I execute 8.3.0
> program (pg_dumpall) without running 8.3.0 postgreSQL?
> And will it produce what I want?

Yes, you can. It will connect to the 8.2.4 version.

Markus