Re: Postgresql

Raymond O'Donnell wrote:
> On 12/03/2009 19:56, Rich Shepard wrote:
>
>
>> will allow this. If the machine runs Microsoft, I've no idea at all
>>
>
> Start Menu
>   -> Administrative Tools
>     -> Computer Management
>       -> Local Users & Groups
>         -> Users
>
> ...then right-click on the user, and select "Set password".
>

or, at a Windows command line prompt,  (of course, replacing newpassword
with whatever random password you chose)

    C:\>  net user postgres newpassword

then make sure the pgsql-8.3 (or whatever) service descriptor is using
this same password...

    C:\> net user postgres newpassword
    The command completed successfully.

    C:\> sc config pgsql-8.3 password= mumba$$
    [SC] ChangeServiceConfig SUCCESS

    C:\> net start pgsql-8.3
    The PostgreSQL Database Server 8.3 service is starting.
    The PostgreSQL Database Server 8.3 service was started successfully.


(note on the SC CONFIG command, the spacing is critical on that
password= ... there's no space before the = and there must be a space
after it, quirky little thing)