![]() On a default Windows installation you must specify a database name and you have the option to change the hostname, the username, and the password. Or create a user with login permissions using PgAdmin tool. So you can try login with postgres user: psql -U postgresĪnd enter the password used while installing. To change the password of a PostgreSQL account, you will need to do it from within PostgreSQL. ![]() (Version 11,12 I have tested).įrom cmd in windows will ask for the password of User (Logged in) which might not be available. The passwd command is used to change the password of a Linux user account. Remove "postgres" and reinstall PostgreSQL Solution 2īy Default, the user is 'postgres' and the password is the one which you enter while installing the database. Thus, to add a password, we must first login and connect as the postgres user. There under "Local Users and Groups" you can see all users created for your system. For most systems, the default Postgres user is postgres and a password is not required for authentication. Go to Control Panel -> Administrative Tools -> Computer Management. There is no default password on Windows - the install will ask you during the wizard to create one.
0 Comments
Leave a Reply. |