Backup/restore Postgresql via linha de comando

Importar e Exportar Postgresql

 

--- LINUX

 

PGPASSWORD="postgrizza" pg_restore --host localhost --port 5432 --username "idealizza" --dbname "portalhm" portalnova.custom

export PGPASSWORD="j5@9#b3q475f" && pg_dump -Fc -x -T log -h localhost -U postgres tee_finance -f teenow.custom

 

--- WINDOWS

 

C:\Program Files\PostgreSQL\pg94\bin\pg_restore.exe --host localhost --port 5432 --username "postgres" --dbname "teenow" --no-password  --no-owner --no-privileges --verbose "C:\Users\hfeli\Desktop\teenow.custom"