05 2022
$ sudo -u postgres pg_dump ${TARGET_DB} | nkf -w8 | sed 's/EUC_JP/UTF8/g' > ${TARGET_DB}-utf8.txt
$ sudo -u postgres createuser "${USERNAME}"
$ sudo -u postgres psql template1 template1=# CREATE DATABASE ${TARGET_DB} WITH OWNER "${USERNAME}"; CREATE DATABASE # \q
$ sudo -u postgres psql "${TARGET_DB}" < ${TARGET_DB}-utf8.txt
update: 2022/05/25 10:17 | path: /pub/software/postgresql
update: 2022/05/25 08:12 | path: /pub/software/googlechrome
update: 2022/05/24 18:03 | path: /pub/goods/roomba
DAITEI's blogDAITEI's blog