![]() We will now move to the next section of this document and see, how to install PostgreSQL and pgadmin III in Windows 7. If you have any queries and or suggestions, please use our comment section. That is all for now about how to install PostgreSQL and pgadmin3 in Ubuntu. We will use this tool often to manage PostgreSQL in the upcoming tutorials. You can start pgadmin III from Application > Programming > pgadmin III. The following pictorial is taken while running the above command. The installation process starts and after asking once "Do you want to continue?" it continues. Run the following command to install pgadmin3. Install pgAdmin III - GUI to manage PostgreSQL ![]() ![]() To exit the PostgreSQL command prompt, type Contrl+D. Now run the following command to be prompted to supply a password for "postgres" database role. The following pictorial is taken after we ran the above command. For doing so, run the following command, which will take you to the PostgreSQL command line. The first thing you need to do after you successfully installed PostgreSQL, is to change the password for the "postgres" user. The default user for PostgreSQL is "postgres". The following pictorial is taken while installing PostgreSQL in Ubuntu.Ĭhange the PostgreSQL postgres user password The installation process also installs PostgreSQL client. As soon as the installation is finished, it will take you to the command prompt again. ![]() Only once it asks you "Do you want to continue?". The installation process is not much interactive. It will ask for administrative password and then proceed with the installation. ![]() Start terminal window in your Ubuntu system and execute the following command : Make sure that you have an internet connection enabled and you have administrative privileges. We are installing PostgreSQL on Ubuntu Linux. For demonstration purpose, we have used Ubuntu Linux and Windows 7. This document discusses detail installation process of PostgreSQL on Linux and Windows. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |