Login PostgreSQL failure - 0.9-beta stack
|
|
The password that I selected during installation is not being accepted for login to PostgreSQL. I used administrator as the Username. The selected password did work to gain access to phpPGAdmin, although. This problem occured when I first installed WAPP. Thinking that I may have somehow typed the password incorrectly (twice) at install time, I uninstalled WAPP and re-installed it. The second time I carefully entered/recorded the password. The same problem still shows up. |
|
|
Hello JonB, the ‘administrator’ username is used to access the phpPgAdmin panel. Once you are inside you must log to a database and each database you create can have a different owner. But you also have a default “root” user which name is “postgres” that can access and create databases. So if you want to login use “postgres” as user and the password that you provide during the installation process. I hope it helps you. Cheers |
|
|
Thanks diego. Was that documented somewhere? Where should I have looked for that information? |
|
|
Well, it is the PostgreSQL standard so it is documented in the main postgresql documentation. But we should improve our documentation adding that information. Postgres user can create other users and give administrator permissions to them, so you can use the CREATE ROLE function in phpPgAdmin if you feel more comfortable with it. If you have more suggestions or ideas to improve the stack, feel free to contribute. Cheers |
|
|
Hello, |
|
|
There are two login steps with the phpPgAdmin panel. The first one is to login to reach the panel. You must insert “administrator” as the user and the password you supplied during the installation. Once you are in the panel, you have to log to the PostgreSQL database. Here the username is “postgres” and the password the one you supplied during the installation. It is the same password the two times. From now on, you can create PostgreSQL users with the panel, so next time you will be able to log, as the users you create, to the databases. But the “administrator” user to access the panel will always remain the same. Hope it helps. |
|
|
oups, sorry |
|
|
Ran into this same roadblock. Glad this post was here and recent. IMO this needs to be noted somewhere in the BitNami literature. Thanx. |

