12 March 2016

steps

  1. list existing databases

         $ sudo -u postgres psql -l
    
         # check database encoding UTF8
    
  2. create postgresql user ckan_default

         $ sudo -u postgres createuser -S -D -R -P ckan_default
    
  3. create postgresql database

         $ sudo -u postgres createdb -O ckan_default ckan_default -E utf-8
    


blog comments powered by Disqus