Postgrees sql parole

[agrise1]

Dodiet padomu analfabētam!

Atkārtoti instalējot Postgrees sql, prasa lietotājvārdu un paroli, kurus esmu pazaudējis!

Kā rīkoties?

Paldies, ja kāds atsauksies!

[prusaks]

OS neesi pateicis, bet *nix sistēmai tas notiek sekojoši:

psql -d template1

ALTER USER postgres WITH PASSWORD ‘new_password’;

q

Postgres ir laba dokumentācija: https://www.postgresql.org/docs/9.2/static/index.html

Ja ir jautājumi, tad tur visticamākais arī būs atbildes.

[agrise1]

Man, diemžēl, ir vista un xp otram kompim

[m2tv]

Kur tad visi krutie speci pazuduši?

Delete the postgres user, and it will accept any password if you reinstall it:

*click on Start and go to Programs -> Accessories -> Command Prompt

*If you are on Vista, rightclick and choose “Run as Administrator”.

A black box should appear. Type ‘net user postgres /delete’ (without the quotes) and press enter.

The user is now deleted and you can (re)install PostgreSQL.

or

Go to C:Program FilesPostgreSQL8.xdata, move the pg_hba file to your Desktop and open it with notepad.

*Scroll to the bottom and change all md5 to trust. Save and close the file.

*Move the file back to the data folder.

*Restart the PostgreSQL service: Control Panel -> Administrative Tools -> Services

[akms47]

Pamēģini: https://forums.devshed.com/postgresql-help-21/postgresql-password-lost-where-can-i-find-it-544841.html

[Autors]

Ieraksti