We may need to reset the password for postgres user before we are able to login to that account. We will have to login with this user in order to perform various database activities such as accessing database, taking and restoring backups, starting/stopping server etc. Installation of PostgreSQL will automatically create a Unix/Ubuntu user, named postgres. Sudo apt-get install postgresql-9.3 pgadmin3
Install PostgreSQL 9.3 using aptitude sudo apt-get update. Replace the codename in the below command with the one you got from above command and run: sudo sh -c 'echo "deb codename-pgdg main" > /etc/apt//postgresql.list' It is the codename of your Ubuntu release. Run the following command and note down the output. Setup key: wget -quiet -O - | sudo apt-key add. Sudo apt-get -y install python-software-propertiesīefore installing PostgreSQL 9.3, we have to add the PostgreSQL repository where the packages are located. Open Terminal and execute the following commands: sudo apt-get update PostgreSQL 9.4 is also available, click here to know how to install it on Ubuntu Let’s see how to install PostgreSQL 9.3 Server and PGAdmin3 on a clean Ubuntu OS in detail! Linux works differently and there are some manual work involved like, ‘changing repositories’, ‘installing dependencies’, etc When it comes to Linux, people, especially newbies, find it difficult to install PostgreSQL because there is no all-in-on e one-click installer available. Installing PostgreSQL in Windows OS is much easier since PostgreSQL provides pre-packaged setup files for Windows. PostgreSQL is one among the leading open source RDBMS available for Windows, Linux and many other platforms.
0 kommentar(er)
