To fix this edit /usr/share/phppgadmin/conf/Īnd change : $conf = true Trying to login with user : postgres and password : created above might give the error : If that does not work then create a separate symlink, e.g. If it shows Forbidden then try to change the permissions of the directory /usr/share/phppgadmin. Now open the url "localhost/phppgadmin" in your browser. If the symlink does not exist then it can be created by issuing the following command $ ln -s /usr/share/phppgadmin /var/www/phppgadmin PhppgadminĪfter installing phppgadmin there should be symlink /var/www/phppgadmin which would point to /usr/share/phppgadmin Password : Whatever you entered in the previous step.Īfter clicking OK it should connect and there should be an option on the left window pane to manage the databases. Go to File > Add Server and fill in the details To run pgadmin check the gnome/kde menu or just run pgadmin3 from terminal. Pgadmin is a gui tool to administer and manage postgresql databases etc. To create a database the following command can be run from the terminal $ sudo -u postgres createdb mydb Pgadmin Type 'q' and hit enter to quit.Īfter installation the postgres password of postgresql can be changed like this : Now psql will ask for a new password twice. Now to change the password type 'password postgres ' $ sudo -u postgres psql This will start the postgresql shell/console. Type the following in the terminal $ sudo -u postgres psql First of all setup the password of the user 'postgres' $ sudo apt-get install postgresql phppgadmin pgadmin3Īfter installation some configuration needs to be done. Postgresql, phpPGAdmin and pgadmin 3 can be installed from synaptic.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |