<h1 id="install-postgresql-in-ubuntu-2004">Install PostgreSQL  in Ubuntu 20.04</h1>
<h2 id="update-system">update system</h2>
<pre><code class="lang-bash">sudo apt-get update
</code></pre>
<h2 id="install-postgresql">install postgreSQL</h2>
<pre><code class="lang-bash">sudo apt install postgresql postgresql-contrib
</code></pre>
<h2 id="open-postgresql">open postgreSQL</h2>
<pre><code class="lang-bash">sudo -i -u postgres psql
</code></pre>
<h2 id="close">close</h2>
<pre><code class="lang-bash"> \q
</code></pre>
<h2 id="create-new-user">create new user</h2>
<pre><code class="lang-bash">sudo -u postgres createuser --interactive
</code></pre>
<h2 id="create-new-database">create new database</h2>
<pre><code class="lang-bash">sudo -u postgres createdb sammy
</code></pre>
<h2 id="add-the-new-user-in-ubuntu-2004">add the new user in ubuntu 20.04</h2>
<pre><code class="lang-bash">sudo adduser sammy
</code></pre>
<h2 id="change-user-password">change user password</h2>
<pre><code class="lang-bash">sudo -u postgres psql

ALTER USER samy PASSWORD <span class="hljs-string">'myPassword'</span>;

\q
</code></pre>


# Install PostgreSQL  in Ubuntu 20.04

## update system
```bash
sudo apt-get update
```

## install postgreSQL
```bash
sudo apt install postgresql postgresql-contrib
```

## open postgreSQL
```bash
sudo -i -u postgres psql
```

## close
```bash
 \q
```

## create new user
```bash
sudo -u postgres createuser --interactive
```

## create new database
```bash
sudo -u postgres createdb sammy
```

## add the new user in ubuntu 20.04
```bash
sudo adduser sammy
```

## change user password
```bash
sudo -u postgres psql

ALTER USER samy PASSWORD 'myPassword';

\q
```



Install PostgreSQL in Ubuntu 20.04

The amazing open source projects and some other useful references

Resources

Resources

Install PostgreSQL in Ubuntu 20.04

Install PostgreSQL in Ubuntu 20.04

update system

install postgreSQL

open postgreSQL

close

create new user

create new database

add the new user in ubuntu 20.04

change user password