Saturday, October 5, 2013

[Postgresql] command line restore db on windows

SET PGPASSFILE=C:\foo\bar\PG_BACKUP\PGPASSFILE\pgpass.conf
C:\Python27>"C:\Program Files\PostgreSQL\9.3\bin\psql.exe" -U openerp db
 < "C:\Users\user\Downloads\db.dump"

No comments: