How to install and run postgresql in conda

install-and-start-postgresql-in-conda-locally

This gist I write, because I couldn't find step by step instructions 
how to install and start postgresql locally and not globally in the
operating system (which would require sudo).

I hope, this will help especially people new to postgresql!

####################################
# create conda environment
####################################

conda create --name myenv

# enter the environment
conda activate myenv

####################################
# install postgresql via conda
####################################

conda install -y -c conda-forge postgresql

####################################
# create a base database locally
####################################

initdb -D mylocal_db

##############################
# now start the server modus/instance of postgres
##############################

pg_ctl -D mylocal_db -l logfile start

## waiting for server to start.... done
## server started

# now the server is up


####################################
# create a non-superuser (more safety!)
####################################

createuser --encrypted --pwprompt mynonsuperuser
# asks for name and password

####################################
# using this super user, create inner database inside the base database
####################################

createdb --owner=mynonsuperuser myinner_db


####################################
# in this point, if you run some program,
# you connect you program with this inner database
# e.g. Django 
####################################

# in django (Python) e.g. you do

nano <mysite>/settings.py # or instead of nano your favorite editor!

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.postgresql',
        'NAME': 'myinner_db',
        'USER': 'mynonsuperuser',
        'PASSWORD': '<mynonsuperuserpassword>',
        'HOST': 'localhost',
        'PORT': '',
    }
}




# and it is available for django
# so that you can do

##############################
# do with the connected program further steps
##############################

# first install psycopg2
# because django requires this for handling postgresql
conda install -c anaconda psycopg2

# then now you can do:
python manage.py migrate
# to fully integreate the postgresql into your django website

# and to be able to use database, you also need to create a superuser
python manage.py createsuperuser --username name 



################################
# stop running postgres instance under ubuntu
################################

# monitor whether a postgres instance/server is running or not
ps aux | grep postgres
# if none is running, you will se one line - which is from your grep search!
# ending with: grep --color=auto postgres
# ignore this line!
# if an instance of postgresql server is running, then several
# processes are runnng
# you can kill the server by the first number of the leading line!

kill <number>

# e.g.

# username  2673  0.0  0.0  14760   512 pts/11   S+   07:34   0:00 grep --color=auto postgres
# username 30550  0.0  0.0 179144 18996 ?        S    Jun13   0:01 /home/username/miniconda3/envs/django/bin/postgres -D mylocal_db
# username 30552  0.0  0.0 179276  4756 ?        Ss   Jun13   0:00 postgres: checkpointer process   
# username 30553  0.0  0.0 179144  5216 ?        Ss   Jun13   0:01 postgres: writer process   
# username 30554  0.0  0.0 179144  8464 ?        Ss   Jun13   0:01 postgres: wal writer process   
# username 30555  0.0  0.0 179700  5792 ?        Ss   Jun13   0:01 postgres: autovacuum launcher process   
# username 30556  0.0  0.0  34228  3416 ?        Ss   Jun13   0:03 postgres: stats collector process  

# then # 2673 is just the 'grep --color=auto postgres' so ignore
# the line ending with 'postgres -D /path/to/mylocal_db' is the leading line!
# take first number occuring in this line (PID - process ID number):
kill 30550


####################################
# run postgres as non-server in background
####################################

postgres -D db_djangogirls & # runs postgres
# press RET (return) to send it to background!

# you can stop and switch to server mode by
# following 'stop running postgres instance under ubuntu'

##############################
# stop non-server or server modus/instance of postgres
##############################

ps aux | grep postgres # see detailed instructions below (under 'stop running postgres instance under ubuntu')!
kill <process ID> # to stop postgres




Have fun with your completely locally running - more safe - postgresql!!!