Bob Kruger wrote:
>
>I am prepping to upgrade from version 6.4.2 to 6.5.
>
>Could someone point me in the right direction for a method to preserve user
>names and passwords during the upgrade?
>
When you dump your databases prior to upgrade (a dump and reload is
required, and pg_upgrade cannot be used), make sure you use the -z
option to pg_dumpall. This preserves permissions. The user information
is in pg_shadow, which is preserved at the top of the dump.
--
Vote against SPAM: http://www.politik-digital.de/spam/
========================================
Oliver Elphick [EMAIL PROTECTED]
Isle of Wight http://www.lfix.co.uk/oliver
PGP key from public servers; key ID 32B8FAA1
========================================
"I beseech you therefore, brethren, by the mercies of
God, that ye present your bodies a living sacrifice,
holy, acceptable unto God, which is your reasonable
service." Romans 12:1
