MVP vehicles stock web application / copy from quickbooks

Develop an MVP to add cars in our stock from the Autoscout publication to maindomain. We'll also display it on the mobile application using Firebase.

We can replicate everything from the Quickbooks project's web and database server and modify it as per our requirements. We have also extensively used templates.

Procedure to copy a project.

Create a separate project in cloud.

Take snapshot 

Transfer snap to new project so you can reconfigure it and start with development. 

Greate new servers from snap now and transfer it back. 

Ok, now i need update all names of folders and add project and necessary reposetories. 

- Remove backups from filesystem and update backup scripts 
    - crontab
    - /home/backup, /var/www/, 

- Add code to GIT. 
    - Remove old git from folders 
            rm -rf .git so you can use this code in new repository. 
    - create first repository. 

- Start cluster from copy and Remove old db from citus

Start the cluster

# this user has access to sockets in /var/run/postgresql

sudo su - postgres

# include path to postgres binaries

export PATH=$PATH:/usr/lib/postgresql/15/bin

Modify my PATH so that the changes are available in every Terminal session!!!

So, you could add in in your profile. ( postgres user )


15  citus  citus_logfile


pg_ctl -D citus -o "-p 9700" -l citus_logfile start

vim pg_hba.conf

host    all             all             65.109.xx.xx/32       trust

pg_ctl -D citus -o "-p 9700" -l citus_logfile restart
vim /etc/pgbouncer/userlist.txt 

Don’t forget to add user and password to the userlist file.

psql -p 9700

postgres=# \l

                                                  List of databases

   Name    |   Owner   | Encoding |   Collate   |    Ctype    | ICU Locale | Locale Provider |   Access privileges   


 postgres  | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | 

 quickbook | quickbook | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | 

 template0 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =c/postgres          +

           |           |          |             |             |            |                 | postgres=CTc/postgres

 template1 | postgres  | UTF8     | en_US.UTF-8 | en_US.UTF-8 |            | libc            | =c/postgres          +

           |           |          |             |             |            |                 | postgres=CTc/postgres

DROP DATABASE quickbook;

  1. python migrate

python makemigrations vehiclemerks
python migrate vehiclemerks

Ready.. Next create crawlers to copy our offers in stock application.