pressureVessel in Google Cloud
gcloud compute scp E:/index.js prokura@development-server-ubuntu-16:/home/prokura/
gcloud compute scp --recurse E:/test prokura@development-server-ubuntu-16:/home/prokura/
gcloud compute scp prokura@development-server-ubuntu-16:/home/prokura/test/index.js E:/test
gcloud compute scp --recurse prokura@development-server-ubuntu-16:/home/prokura/test E:/
selected django framework for backend
Packgae
Version
python
3.6.4
Django
2.1.1
django-cors-headers
2.4.0
djangorestframework
3.8.2
conda
4.4.10
Packgae
Version
react
3.6.4
export to a file in local
pg_dump -U nic vesseldb > dbexport.pgsql
gcloud compute scp dbexport.pgsql prokura@development-server-ubuntu-16:/home/prokura/db_import
enter password on prompt
prokura
sudo apt-get install postgresql postgresql-contrib
switch over to postgres account
sudo -i -u postgres
createuser --interactive
type the username as calcgen
create the db with dbname same as rolename
sudo -i -u postgres
createdb calcgen
add the user as linux user
sudo -i -u calcgen
psql
createdb vesseldb
\q
log into new db as calcgen
set the password for calcgen
alter user username with encrypted password ' password' ;
export only table data from specific table
pg_dump --data-only -U username --table=tablename sourcedb > data.sql
psql -U username databasename < data.sql