Home : Products : UDG1000 : How to restore UDG1000 Backup
Q14193 - INFO: How to restore UDG1000 Backup

Note: Restore must be performed by Hach IIM Tech Support, unless admin user is created, see Q14197

IIM Tech Support: See Internal PWD Article for UDG1000 db password. 

To restore database backup (backup is performed in UDG under System>Settings), use the following command :

1. Close the UDG1000 program.

2. Shutdown Hach UDG1000 Service.

3. Use pgAdmin III tool to Drop/Delete udg1K database.  pgAdmin III tool is a free Utility from postgres and can be downloaded from http://www.pgadmin.org/download/windows.php  or google it. 

4. Create a new udg1K database by right clicking on Databases and choosing New Database...  Set Owner to postgres.

5. Unzip your backup. By default backup are placed in C:\ProgramData\Hach Company\UDG\Backups. They are named UDG_Backup_YYYYMMDD_HHMMSS.zip (EX: UDG_Backup_20140325_021751.zip). The backup contains a file called udg1k.backup.  This the file that must be restored with the subsequent commands.

6. Open up a command prompt.  Change the directory to the location for the postgres restore program (pg_restore.exe).  

EX: CD C:\Program Files (x86)\PostgreSQL\9.2\bin

7. Execute the restore command.

pg_restore -U postgres -p 56298 -d udg1k "C:\ProgramData\Hach Company\UDG\Backups\udg1k.backup"

Where -U is the User and -p is the port number.
The program will next ask you for the UDG1000 db password (for user postgres). Type that in.

NOTE: Depending on the size of your back it could take some time to restore. Be patient, it is pretty slow. 

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help us improve this article...
What did you think of this article?


Tell us why you rated the content this way. (optional)
Approved Comments...
No user comments available for this article.
Created on 3/25/2014 5:14 PM.
Last Modified on 1/31/2017 7:13 AM.
Last Modified by Ryan Rhoten.
Article has been viewed 4406 times.
Rated 8 out of 10 based on 3 votes.
Print Article
Email Article