- #Ubuntu postgresql web admin install#
- #Ubuntu postgresql web admin update#
- #Ubuntu postgresql web admin software#
- #Ubuntu postgresql web admin password#
data_directory, hba_file, etc), connections and authentication (e.g. This file is the main configuration file that handles many important part such as postgre file locations (e.g. vi/vim, nano, gedit, etc.) and make sure the file contains this line below: We’re going to edit the authentication method by open this file using your own favourite editor (e.g. The pg_hba.conf is used for authentication methods. We’re going to change those 2 configuration files.īut, before you do that, I suggest you to make a copy (backup) of the original files such as cp -v pg_hba.conf pg_ You will see there 2 important files named pg_hba.conf and nf.
#Ubuntu postgresql web admin password#
So i give unix password and postgresql password just like the following:įirst, don’t forget to switch to user su to your postgreql /etc/postgreql//main and I suggest you to check the files cd ls -al It has no password at all (unix password and postgresql password).
The unix user postgres is a root user (database administrator) for PostgreSQL. You can check this by using command finger like the following:
Setup root (database administrator) user ‘postgres’īy default, if you’ve passed the postgreSQL installation, the installer has created a unix user postgres for you. Now, you can check the installation version and dependency package using the commands as you can see from this below picture: Waiting for the process to be done by the system, just like the following picture:
#Ubuntu postgresql web admin install#
#Ubuntu postgresql web admin update#
#Ubuntu postgresql web admin software#
Whatever the case, PPAs provide update for our favourite software at a much quicker rate than Ubuntu itself. A PPA ( Personal Package Archive) is a collection of software not included in Ubuntu by default. For example on this case, I want to install postgreSQL 9 in my new Ubuntu 11.04, but by default Ubuntu 11.04 repository use PostgreSQL 8, so typically I have to wait for the next Ubuntu version for postgreSQL 9 (it is wasting my time, right ?).ĭon’t worry, this is where PPAs come in. This software is stored in a repository, which is a collection of Ubuntu’s software to be downloaded quickly and easily :bd.īut, users typically have to wait for a new version of Ubuntu to try out new software.
Rather than going to the web to download a package, it’s usually better bet to check the Ubuntu Software Center for any program we might want to install. Installing software on Ubuntu is different than on Mac or Windows I’d rather say it’s better :-). Originally PPAs were limited to programmers and testers, but Canonical has opened PPAs to everyone in late 2007. PPA is repository provided by Canonical (the company behind Ubuntu), that allows developers and enthusiasts to offer up-to-date versions of software to all Ubuntu users. The solution for this problem is PPA ( Personal Package Archives). Unfortunately, at the time of this note, the default version of PostgreSQL in Ubuntu 11.04 ( Natty Narwhal) is still 8.4.8. But, I have to install again all of my development tools from the beginning. So, I was choosing Ubuntu 11.04 ( Natty Narwhal) instead of Ubuntu 10.04 ( Lucid Lynx).
So, without thinking too much, I’ve decided to backup all of the data to my PC’s harddisk, then performed low level format from my PC.Īfter finished, I had an idea to gave that harddisk new OS. I thought that maybe the harddisk had some bad sector in it. I was glad, because at least i knew that the motherboard is still working :-). Yupi, It was working (ye…ye.ye.ye.ye.:-D).