Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # open systemd service file
- sudo nano ?????/postgres.service
- # and put path to postgres data
- [Service]
- Environment=PGDATA=/mnt/ess_storage/DN_1/storage/automall/postgres_node1
- sudo systemctl enable postgresql
- sudo systemctl start postgresql
- sudo systemctl status postgresql
- sudo systemctl stop postgresql
- sudo systemctl restart postgresql
- # create database and user
- [user] sudo su - postgres
- create database car4u;
- create user car4u_app with encrypted password 'password';
- grant all privileges on database car4u to car4u_app;
- \q
- # change owner for all tables
- for table in `psql -tc "select tablename from pg_tables where schemaname = 'public';" car4u` ; do psql -c "alter table ${table} owner to car4u_app" car4u ; done
- SHOW hba_file;
- /mnt/ess_storage/DN_1/storage/automall/postgres_node1/pg_hba.conf
- SHOW config_file;
- /mnt/ess_storage/DN_1/storage/automall/postgres_node1/postgresql.conf
- sudo netstat -plunt |grep postmaster
- # creating backup file
- sudo su - postgres
- pg_dump automall > /tmp/automall.dump
- exit
- exit
- scp nano@10.9.14.110:/tmp/automall.dump /home/user/projects/automallproject/application/integration/files/
- # restore from backup
- psql -U car4u_app -d car4u < /tmp/backup_file
Add Comment
Please, Sign In to add comment