Re: Upgrade issue (again).

At 04:50 PM 16-05-2001 -0400, Lamar Owen wrote:
>-----BEGIN PGP SIGNED MESSAGE-----
>Hash: SHA1
>
>I am loathe to even bring this up, but with two messages today about it, I
am 
>going to be short and sweet:
>
>We don't have a reasonable upgrade path.  ASCII dump->install 
>new->initdb->restore is not a reasonable upgrade.  It is confusing to the 
>newbie, and should be fixed.  We used to have an upgrade path in pg_upgrade 

>time, Bruce!). Furthermore, the dump/restore cycle is a pain in the neck
when 
>tables get larger than a few hundred megabytes.  It's worse when the newer 

I won't mind a better upgrade method. But so far I pipe the dump into gzip,
and the resulting file is of manageable size.

What I find annoying is that pg_dumpall doesn't support username and
password. So far I just do a pg_dump of the relevant databases, and
recreate the users manually when installing.

Also to reload the file I do:
zcat gzippedusernameandpassword.gz dbfile.gz | psql

That's a bit ugly :).

Cheerio,
Link.