Hello.... I was able to back up database however i have no idea how to restore it to machine.... Hope you can help me here....
Thanks...
Restore database how to?
Please provide more information, following the instructions in this FAQ entry should help:
http://forums.timetrex.com/viewtopic.php?t=89
http://forums.timetrex.com/viewtopic.php?t=89
It`s easy to backup a postgresql 8.2 DB in TT (there is a script named backup_database)
but it is hard for me to restore the same database on another machine or after reinstalling on the same machine (there is a lack of a such kind of script)
For instance:
dumping woks with:
SET PGPASSWORD=[Password from your backup_database.bat]
SET PGDATABASE=timetrex
"D:\Program Files\TimeTrex/postgresql\bin\pg_dump.exe" -d -f timetrex_database_%date%.sql -h localhost -U timetrex -p 5433
but
restore doesn`t work with:
"C:\program files\timetrex/postgresql\bin\pg_restore.exe" -d timetrex -h localhost -U timetrex -p 5433 C:\..........\timetrex_database_18.12.2008.sql
on another machine or after reinstalling on the same machine
The answer from CP is
...The systeem cannot find the path specified
There is also another problem when installing TT on another machine or after reinstalling on the same machine: the password of the new DB before restoring the old one is different and do not match.
but it is hard for me to restore the same database on another machine or after reinstalling on the same machine (there is a lack of a such kind of script)
For instance:
dumping woks with:
SET PGPASSWORD=[Password from your backup_database.bat]
SET PGDATABASE=timetrex
"D:\Program Files\TimeTrex/postgresql\bin\pg_dump.exe" -d -f timetrex_database_%date%.sql -h localhost -U timetrex -p 5433
but
restore doesn`t work with:
"C:\program files\timetrex/postgresql\bin\pg_restore.exe" -d timetrex -h localhost -U timetrex -p 5433 C:\..........\timetrex_database_18.12.2008.sql
on another machine or after reinstalling on the same machine
The answer from CP is
...The systeem cannot find the path specified
There is also another problem when installing TT on another machine or after reinstalling on the same machine: the password of the new DB before restoring the old one is different and do not match.