How To Install Postgre. SQL 9. 4 And php. Pg. Admin On Ubuntu 1. Introduction. Postgre.
XAMPP is an easy to install Apache distribution containing MariaDB, PHP, and Perl. Just download and start the installer. It's that easy. XAMPP for Windows 5.5.34, 5. Today I just wanted to document here the quickest and easiest way of setting your Solaris box as a DHCP client. 1. Create the /etc/hostname. file. OpenSSH is a free opensource version of the SSH connectivity tools. OpenSSH encrypts all traffic (including passwords) to effectively eliminate eavesdropping. Solaris Network Install from Linux. I was able to successfully install Solaris 8 on my SPARCstation 10 using my Red Hat 7.3 Linux machine as a boot server.
![Add_Install_Client Solaris 10 Add_Install_Client Solaris 10](http://www.ibm.com/developerworks/websphere/library/techarticles/1012_storey/images/fig12.jpg)
Introduction PostgreSQL is a powerful, open-source object-relational database system. It runs under all major operating systems, including Linux, UNIX (AIX. Here are my notes applicable for Solaris 10. First of all install latest patches – a lot of related things fixed (but new bugs may appear :)) Synchronize the system. Setting up a Sun Solaris Server to receive its IP address from a DHCP Server is fairly straight forward and is infact just a matter of setting up files on your.
SQL is a powerful, open- source object- relational database system. It runs under all major operating systems, including Linux, UNIX (AIX, BSD, HP- UX, SGI IRIX, Mac OS, Solaris, Tru. Windows OS. Postgre. SQL 9. 4 has been released last week with major enhancements, fixes, and features. Read what is new in Postgre. SQL 9. 4 here . In this handy tutorial, let us see how to install Postgre.
SQL 9. 4 on Ubuntu 1. Install Postgre. SQLPostgre. SQL is available in the default repositories. So enter the following command from the Terminal to install it.
If you’re looking for other versions, add the Postgre. SQL repository, and install it as shown below. On Ubuntu 1. 4. 1. Create the file /etc/apt/sources. Add a line for the repository: deb http: //apt. On Ubuntu 1. 4. 0.
![Add_Install_Client Solaris 10 Add_Install_Client Solaris 10](https://dw1.s81c.com/developerworks/mydeveloperworks/blogs/nfrsblog/resource/BLOGS_UPLOADED_IMAGES/Atria.jpg)
On Ubuntu 1. 2. 0. Import the repository signing key: wget - -quiet - O - https: //www. ACCC4. CF8. asc. sudo apt- key add - Update the package lists: sudo apt- get update. Then install the required version.
Access Postgre. SQL command prompt The default database name and database user are “postgres” . Switch to postgres user to perform postgresql related operations: sudo - u postgres psql postgres. Sample Output: psql (9.
Type "help" for help. To exit from posgresql prompt, type \q in the psql prompt return back to the Terminal. Set “postgres” user password. Login to postgresql prompt,sudo - u postgres psql postgres.
Enter new password. Enter it again. postgres=# \q. To install Postgre. SQL Adminpack, enter the command in postgresql prompt: postgres=# CREATE EXTENSION adminpack. CREATE EXTENSIONCreate New User and Database For example, let us create a new user called “senthil” with password “ubuntu” , and database called “mydb” .
D - A - P senthil. O senthil mydb. Delete Users and Databases. To delete the database, switch to postgres user: sudo - u postgres psql postgres. Enter command: $ drop database < database- name> To delete a user, enter the following command: $ drop user < user- name> Configure Postgre. SQL- MD5 Authentication MD5 authenticationrequires the client to supply an MD5- encrypted password for authentication. To do that, edit /etc/postgresql/9.
Add or Modify the lines as shown below[..]. TYPE DATABASE USER ADDRESS METHOD. Unix domain socket connections only.
IPv. 4 local connections. IPv. 6 local connections. Restart postgresql service to apply the changes: sudo service postgresql restart. Configure Postgre. SQL- Configure TCP/IP By default, TCP/IP connection is disabled, so that the users from another computers can’t access postgresql. To allow to connect users from another computers, Edit file /etc/postgresql/9. Find the lines: [..].
Uncomment both lines, and set the IP address of your postgresql server or set ‘*’ to listen from all clients as shown below: listen_addresses = '*'. Restart postgresql service to save changes: sudo service postgresql restart. Manage Postgre. SQL with php. Pg. Adminphp. Pg. Admin is a web- based administration utility written in PHP for managing Posgre. SQL. php. Pg. Admin is available in default repositories.
So, Install php. Pg. Admin using command: sudo apt- get install phppgadmin By default, you can access phppgadmin using http: //localhost/phppgadmin from your local system only. To access remote systems, do the following. Edit file /etc/apache. Comment the following line: [..].
Uncomment the following line to make phppgadmin from all systems. Edit /etc/apache. Add the following line: Include /etc/apache. Then, restart apache service.
Configure php. Pg. Admin Edit file /etc/phppgadmin/config. Most of these options are self- explanatory. Read them carefully to know why do you change these values. Find the following line: $conf['servers'][0]['host'] = ''; Change it as shown below: $conf['servers'][0]['host'] = 'localhost'; And find the line: $conf['extra_login_security'] = true; Change the value to false : $conf['extra_login_security'] = false; Find the line: $conf['owned_only'] = false; Set the value as true .
Save and close the file. Restart postgresql service and Apache services.
Now open your browser and navigate to http: //ip- address/phppgadmin . You will see the following screen. Login with users that you’ve created earlier. I already have created a user called “senthil” with password “ubuntu” before, so I log in with user “senthil”.
Now, you will access the phppgadmin dashboard. Log in with postgres user: That’s it.
Now you’ll able to create, delete and alter databases graphically using phppgadmin easily. Cheers! Share this Article: 0.