PGDUMP-db 9.118

dbsa@dbsa-X406UA:~$ ssh root@172.16.9.118
Last login: Mon Apr  6 13:28:04 2020 from 172.17.49.24
[root@localhost ~]# su - postgres95
Last login: Sen Apr  6 13:30:50 WIB 2020 on pts/0
-bash-4.2$
bash-4.2$ pg_dump95 -p 5533 -U yogya yotodo > yotodo.sql
-bash-4.2$ ls
backup             backup.sh             development_stop.sh  hrm_new.sql          logfile-staging  production_start.sh  staging_stop.sh
backup_edb_prd.sh  data                  dumpall.sql          logfile-development  mobile.sql       production_stop.sh   yotodo.sql
backup.log         development_start.sh  fashion_ware.sql     logfile-production   pim_prd-.sql     staging_start.sh
-bash-4.2$
[root@localhost ~]# scp -r yotodo.sql root@172.16.67.205:/home/oracle

-----------------------------------------------------------------------------------

[root@localhost postgres95]#
pg_dump93 -p 5332 -U yogya_asset adjuro_prod > adjuro_prod.sql

[root@localhost postgres95]# su - postgres95
Last login: Sen Mei 18 13:28:53 WIB 2020 on pts/0
-bash-4.2$psql95 -p 5533 -d postgres
psql95 (9.5.10)
Type "help" for help.

postgres=# drop database adjuro_test_central;
postgres=# create database adjuro_test_central;
postgres=# alter database adjuro_test_central owner to yogya;
postgres=# \q
-bash-4.2$ ls
adjuro_prod.sql    backup.sh             dumpall.sql          logfile-production  production_start.sh  trp_prd.sql
backup             data                  fashion_ware.sql     logfile-staging     production_stop.sh   yotodo.sql
backup_edb_prd.sh  development_start.sh  hrm_new.sql          mobile.sql          staging_start.sh
backup.log         development_stop.sh   logfile-development  pim_prd-.sql        staging_stop.sh
-bash-4.2$ 
-bash-4.2$ psql95 -p 5533 -U yogya -d adjuro_test_central -f adjuro_prod.sql
CREATE INDEX
CREATE INDEX
ALTER TABLE
REVOKE
psql95:adjuro_prod.sql:42012484: ERROR:  role "postgres" does not exist
psql95:adjuro_prod.sql:42012485: ERROR:  role "postgres" does not exist
GRANT
-bash-4.2$exit