So I have to use pg_dump command:
In WIndows XP:
in the command window type in:
c:\Program Files\PostgreSQL\8.4\bin\pg_dump -U table_name DATABASE_name > backup_file_path_and_name;
Type in user password when needed
In Ubuntu:
Locate the psql command, usually it will be in the following directory: in /usr/bin:
Type in the following command in terminal:
cd /usr/bin;
psql -f backup_file_path_and_name DATABASE_name;
waiting for the process to finish.
No comments:
Post a Comment