badtheperfect.blogg.se - Windows default admin password

Line to pg_hba.conf and then sudo -u postgres psql (assuming your PostgreSQL server runs as user postgres) to get an interactive psql session without using a password. On unix systems it's more secure to prepend a local all all peer This might require you to set yourself as the owner of the file.

To edit it you'll have to use the security tab to give yourself read/write permissions (via a UAC prompt). By default it'll be %PROGRAMFILES%\PostgreSQL\9.3\data.

Edit pg_hba.conf again and set the auth mode back to md5.

ALTER USER postgres PASSWORD 'mynewpassword'.

Connect with psql or PgAdmin or whatever.

In the Services control panel restart the PostgreSQL service.

Edit pg_hba.conf, setting the auth mode to trust instead of the default md5.

Otherwise, treat it the same as if you lost/forgot the password rather than never knowing it: If you used an unattended installer script, the password will be in the script or associated config file. From there click on 'Troubleshooting' and then 'System image restore'. Step Three: This will bring you into the Advanced Option menu. You should usually only use it to change the password then restore the configuration back to the auth mode you were using before. Step Two: When booted up hold down your 'shift' key and click on the restart button on the bottom right of your screen. If you set trust mode that allows superusers like user postgres (or all users) to connect, they get total control of your PostgreSQL and can probably run shell commands too.

Anyone who can connect to the PostgreSQL server can control it.