project setup with R sir - chingching project setup

 Database .yml mein jo bhi name daloge woh application.yml mein bhi set karoge


Note :: database.yml aur application.yml mein change krna hoga



database import -

i have to import new database which is given by rinku – that is local database

1. first the file given by rinku – download that

2. cut paste that to the normal folder of chingching

3. change the database name in application.rb and database.yml -

........................................................................................................................................

In database.yml -

database: 'chingchingbyakon_dev1' , test - database: 'ChingChing_test1'

........................................................................................................................................

in application.yml - development - database: 'chingchingbyakon_dev1', test - database: 'ChingChing_test1', production: ‘chingchingbyakon_dev1’

........................................................................................................................................

4. $ rake db:create - create the database

5. import the database –

sql file r sir ne mujhe bheji hai wheen se uska name milega mujhe

psql -U postgres `database_name` < sqlfilename

Ex: psql -U postgres chingchingbyakon_dev1 < local_data_25_05_2022.sql


note ::

is command par error de raha tha -

psql: FATAL: Peer authentication failed for user "postgres"


is error ko solve karne ke liye r sir ne command chalaye -

sudo nano /etc/postgresql/11/main/pg_hba.conf

sudo service postgresql restart

psql -U postgres chingchingbyakon_dev1 < local_data_25_05_2022.sql


note – ismein pehle postgres ko restart karna hoga


.............................................................................................................................................


check karna ki postgres ka name kya hai -


$ psql -U root -

error - psql: error: FATAL: Peer authentication failed for user "root"


$ psql -U postgres -

error - psql: error: FATAL: Peer authentication failed for user "postgres"


$ postgresql -v

postgresql: command not found


$ sudo nano /etc/po

polkit-1/ popularity-contest.conf postgresql/ postgresql-common/




$ sudo nano /etc/postgresql

postgresql/ postgresql-common/


$ sudo nano /etc/postgresql/1

11/ 13/


$ sudo nano /etc/postgresql/11/main/

conf.d/ environment pg_ctl.conf pg_hba.conf pg_ident.conf postgresql.conf start.conf


$ sudo nano /etc/postgresql/11/main/p

pg_ctl.conf pg_hba.conf pg_ident.conf postgresql.conf


$ sudo nano /etc/postgresql/11/main/pg_hba.conf

[sudo] password for user:


$ sudo apt-get --purge remove postgresql postgresql-*



$ sudo nano /etc/


$ sudo nano /etc/p


sudo nano /etc/po


sudo apt-get update







note -

r sir ne saari branch dekheen - $ git branch -a

meri branch account_deleted thi





note -

r sir ne database.yml mujhe bheji

r sir ne application.yml mujhe bheji

r sir ne postman ka database import karne ke liye mujhe link bheja

sql file



How to set the Postgres name ::


Use this link -





Comments

Popular posts from this blog

Rails 7 Features :: Comparison with Rails 6 and Rails 5