At the time of writing, I’m using Ubuntu 9.04 and Postgresql 8.3.
To start installing Postgresql, just type below apt-get command in the terminal:
sudo apt-get install postgresql-8.3
Then you need to change the default Postgresql user named postgres. To do so, you need to login as postgres Ubuntu user. Type the following command to login into Postgres console as postgres user.
sudo -u postgres psql postgres
This will get you into Postgresql console. In order to change the default postgres password, type below in the terminal:
/password postgres
Postgresql console will ask you to enter the new password twice. To quit from the Postgresql console type the following:
/q
This change requires your Postgresql server to be restarted. Type the following command:
sudo /etc/init.d/postgresql-8.3 restart
To make your life easier when working with Postgresql, you might want to install the GUI-client called pgadmin-III. In the terminal, type the following:
sudo apt-get install pgadmin3
Once pgadmin-III is installed, you should be able to see the pgadminIII menu in your Ubuntu main menu as shown below.
One Comment
Please change “/” to “\” in the Postgres console commands.
2 Trackbacks/Pingbacks
[...] be using Postgresql 8.3. To learn more on how to install Postgresql in Ubuntu, you can go here. Also, in Postgresql, create a login-role named adempiere and create a database named adempiere. [...]
[...] 8.3 verwenden. Um mehr darüber,zu erfahren, wie man Postgresql unter Ubuntu installieren kann, schauen Sie hier. In PostgreSQL erstellen Sie eine Login-Rolle namens adempiere und erstellen eine Datenbank mit [...]