Friday, June 10, 2016
Backup and Restore with PostgreSQL
Enter psql
DOS> psql -U user database_name
DOS> psql database_name (if no password defined)
Drop DB
DOS> dropdb database_name
PSQL# drop database database_name
Create DB
DOS> createdb database_name
PSQL# create database database_name
Dump DB
DOS> pg_dump database_name > file_name
Restore from Dump
DOS> psql -U user -d database_name -f file_name
Subscribe to:
Post Comments (Atom)
Upgrade nodejs in conda (from v18 to v26)
If your conda env is nodejs v18, doing a conda install nodejs=26 is likely to create a lot of conflict. Consider remove those conflicting p...
-
When Office2003 couldn't find file SKU011.CAB: regedit -> [HKEY_LOCAL_MACHINE] -> [SOFTWARE] -> [Microsoft] -> [Office] -...
-
The resolution can be changed by editing the BlueStack's registry: HKLM\SOFTWARE\BlueStacks\Guests\Android\FrameBuffer\0\Height and ...
-
Suppose you got a file in Big5 containing some HKSCS characters (e.g. 深水埗, 赤鱲角, etc). When your environment (Ref: Charset.defaultCharset( ) ...
No comments:
Post a Comment