630 pg_dump -h 127.0.0.1 -U zzzzzzzzzzzzz -p 5432 -d ttttt --inserts > cosmic_fi.dump
641 pg_restore -U zzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
642 pg_restore -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
643 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
721 cd /var/lib/pgsql/11/data/
730 vim pg_hba.conf
731 vi pg_hba.conf
733 vi pg_hba.conf
743 history|egrep pg
744 pg_dump -h 127.0.0.1 -U zzzzzzzzzzzzz -p 5432 -d ttttt --inserts >1117.sql
750 cp -a pg12.tar.gz 12/
753 tar xf pg12.tar.gz
777 /usr/pgsql-12/bin/postgresql-12-setup initdb
785 find / -name pg_hba.conf
786 egrep -v "^(#|$)" /var/lib/pgsql/11/data/pg_hba.conf
787 egrep -v "^(#|$)" /var/lib/pgsql/12/data/pg_hba.conf
788 vim /var/lib/pgsql/12/data/pg_hba.conf
789 vi /var/lib/pgsql/12/data/pg_hba.conf
792 vi /var/lib/pgsql/12/data/pg_hba.conf
794 vi /var/lib/pgsql/12/data/pg_hba.conf
796 vi /var/lib/pgsql/12/data/pg_hba.conf
803 \rm pg12.tar.gz
804 history|egrep pg
806 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v ./1117.sql
812 cd /var/lib/pgsql/11/data/
818 cd /var/lib/pgsql/11/data/
820 cd /var/lib/pgsql/12/data/
827 history|egrep pg
829 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
833 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
835 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --no-owner --role postgres -d ttttt -v /root/cosmic_fi.dump
839 ps aux|egrep pgloader
852 pg_dump -U zzzzzzzzzzzzz -h 127.0.0.1 -p 5432 -d ttttt > ttttt_old.sql
857 tar xf ttttt_pgsql_1227_new.tar.gz
858 pg_restore -h127.0.0.1 -Uzzzzzzzzzzzzz --role zzzzzzzzzzzzz -d ttttt -v /root/ttttt_pgsql_1227_new.sql
859 psql -h 127.0.0.1 -U zzzzzzzzzzzzz -d ttttt -c "SET ROLE zzzzzzzzzzzzz;" -f /root/ttttt_pgsql_1227_new.sql
862 head ttttt_pgsql_1227_new.sql
863 head -1000 ttttt_pgsql_1227_new.sql
866 tar xf ttttt_pgsql20240105.tar.gz
869 pg_dump -U zzzzzzzzzzzzz -h 127.0.0.1 -p 5432 -d ttttt > ttttt_old.sql
870 pg_dump -U zzzzzzzzzzzzz -h 127.0.0.1 -p 5432 -d ttttt > ttttt0105old.sql
871 #psql -h 127.0.0.1 -U zzzzzzzzzzzzz -d ttttt -c "SET ROLE zzzzzzzzzzzzz;" -f /root/ttttt_pgsql_1227_new.sql
873 psql -h 127.0.0.1 -U zzzzzzzzzzzzz -d ttttt -c "SET ROLE zzzzzzzzzzzzz;" -f /root/ttttt_pgsql20240105.sql