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 [EMAIL PROTECTED] -----Original Message----- From: Markus Bertheau [mailto:[EMAIL PROTECTED] Sent: Wed 2/13/2008 8:57 AM To: Tena Sakai Cc: Peter Childs; pgsql-admin@postgresql.org Subject: Re: [ADMIN] 8.3.0 upgrade, confused by documentation 2008/2/13, Tena Sakai <[EMAIL PROTECTED]>: > 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
