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:
Posts (Atom)
Sync multiple git repo at once
Use the following command in Linux will do the job: ls -d RepoNames* | xargs -I{} git -C {} pull
-
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 ...
-
To count the number lines of files / stdout in Linux, we uses "wc -l" to achieve. In Windows, we use the following instead: find...