Friday, December 9, 2011

postgres Backup and restore commands



postgres restore

C:/Program Files/PostgreSQL/8.4/bin\pg_restore.exe --host localhost --port 5432 --username postgres --dbname kanyakumari --verbose "D:\MySQL_From_SivaGanesh_HDD1\kanyakumari.backup"

Backup
C:/Program Files/PostgreSQL/8.4/bin\pg_dump.exe --host localhost --port 5432 --username postgres --format custom --verbose --file "D:\MySQL_From_SivaGanesh_HDD1\kanyakumari.backup_dist03.backup" --schema dist03 kanyakumari

Backup
C:/Program Files/PostgreSQL/8.4/bin\pg_dump.exe --host localhost --port 5432 --username postgres --format custom --blobs --verbose --file "D:\MySQL_From_SivaGanesh_HDD1\kanyakumari.backup_dist03.backup" kanyakumari

No comments:

Post a Comment