Now we know mysql is not free anymore, at least for the newest
version. One more reason to learn PostgreSQL. Why PostgreSQL and not the
other? Find the reason yourself, I'm not your advisor. But here's the
hint for you:
So you get the binary file, then use terminal to give execution permission to that file, and execute it by using ./[filename.bin] command. The graphic installation window will appear. Choose where you will store the program, wherever is fine as long as you have permission to write on them. Then the next step is to insert the postgre password. That's just normal form, so fill up and don't let them blank. They will never make your computer explode right before your eyes. Then wait 'til the installation is completed. You can either way check or uncheck the option to launch bitnami, whichever is fine.
Once you close the installation window, enter your installation directory from terminal. Execute ./ctlscript.sh start to starting apache and postgre services. Then run your web browser, and enter 127.0.0.1/phppgadmin. Remember, don't use localhost cause that will make you unable to access phppgadmin. Once the tiny window with two form appear, fill the upper with "administrator" and the lower with password you specify before at installation progress. Then you will find yourself at phppgadmin homepage.
Click PostgreSQL on left pane, and fill the username with postgresql and password with the password you use before. And here you can manage your PostgreSQL. Easy right? Yeah I think so, and this is just the intro for installing the harder thing, that's pgadmin, the application for managing postgre graphically too, without web dependent and with many more feature than PHPPgAdmin. Just wait, that's for another post.
- PostgreSQL support inherit function which can't be done by using MySQL
- If you used to using LAMPP, there are LAPP BitNami that use Postgres
- Web interface for managing postgre is colorful. See yourself and tell your friend how you adore them, and I bet you will be called freak.
So you get the binary file, then use terminal to give execution permission to that file, and execute it by using ./[filename.bin] command. The graphic installation window will appear. Choose where you will store the program, wherever is fine as long as you have permission to write on them. Then the next step is to insert the postgre password. That's just normal form, so fill up and don't let them blank. They will never make your computer explode right before your eyes. Then wait 'til the installation is completed. You can either way check or uncheck the option to launch bitnami, whichever is fine.
Once you close the installation window, enter your installation directory from terminal. Execute ./ctlscript.sh start to starting apache and postgre services. Then run your web browser, and enter 127.0.0.1/phppgadmin. Remember, don't use localhost cause that will make you unable to access phppgadmin. Once the tiny window with two form appear, fill the upper with "administrator" and the lower with password you specify before at installation progress. Then you will find yourself at phppgadmin homepage.
Click PostgreSQL on left pane, and fill the username with postgresql and password with the password you use before. And here you can manage your PostgreSQL. Easy right? Yeah I think so, and this is just the intro for installing the harder thing, that's pgadmin, the application for managing postgre graphically too, without web dependent and with many more feature than PHPPgAdmin. Just wait, that's for another post.
Comments
Post a Comment