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)
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general