OK, so apparently the solution is to upgrade. My OS is currently RedHat
6.2. I'm a little leary of upgrading Linux at this point. Is there a
way to run Postgresql 7 under RedHat 6.2 or do I have to upgrade?
Wayne Johnson wrote:
>
> According to the Postgresql manual, a user can alter their own
> password. When I try:
> alter user "test" with password "zzzz";
> Where test is the user id signed in with, I get the error:
> ERROR: pg_shadow: Permission denied.
>
> What am I overlooking?
>
> Tia,
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster