<commit_before>Docker-PostgreSQL
==========

Deploy Postgresql Server on Docker,You can build postgresql docker with this dockerfile  

## create a folder for postgresql data  
```
sudo mkdir ~/pgdata  
```
## run docker backend  
```
docker run -d -p 5432:5432 -v ~/pgdata:/var/lib/pgsql/9.3:rw -e POSTGRESQL_USER=<Your username> -e POSTGRESQL_PASS=<Your password> -e POSTGRESQL_DB=<Database name> &   
e.g:  
sudo docker run -d -p 5432:5432 -v ~/pgdata:/var/lib/pgsql/9.3:rw -e POSTGRESQL_USER=demo -e POSTGRESQL_PASS=demo -e POSTGRESQL_DB=demo 'cloudcube/postgresql' &  
```

note:  
-v 指定container卷存储，container的路径要和run脚本中的POSTGRESQL_DATA一致.  
postgresql openssl未配置成功.  

<commit_msg>add how to connect postgresql<commit_after>Docker-PostgreSQL
==========

Deploy Postgresql Server on Docker,You can build postgresql docker with this dockerfile  

## create a folder for postgresql data  
```
sudo mkdir ~/pgdata  
```
## run docker backend  
```
docker run -d -p 5432:5432 -v ~/pgdata:/var/lib/pgsql/9.3:rw -e POSTGRESQL_USER=<Your username> -e POSTGRESQL_PASS=<Your password> -e POSTGRESQL_DB=<Database name> &   
e.g:  
sudo docker run -d -p 5432:5432 -v ~/pgdata:/var/lib/pgsql/9.3:rw -e POSTGRESQL_USER=demo -e POSTGRESQL_PASS=demo -e POSTGRESQL_DB=demo 'cloudcube/postgresql' &  
```
## how to use?  
```
sudo rpm -Uvh http://yum.postgresql.org/9.3/fedora/fedora-20-x86_64/pgdg-fedora93-9.3-1.noarch.rpm  
sudo yum install postgresql93  
psql -h localhost -p 5432 -U demo -W demo  

## note    
-v 指定container卷存储，container的路径要和run脚本中的POSTGRESQL_DATA一致.  
postgresql openssl未配置成功.  


{'fraction_non_alphanumeric': 0.1306532663316583, 'fraction_numerical': 0.03706030150753769, 'mean_word_length': 4.073248407643312, 'pattern_counts': {'":': 0, '<': 9, '<?xml version=': 0, '>': 9, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '2511180', 'n_tokens_mistral': 731, 'n_tokens_neox': 665, 'n_words': 148}