When you have installed the PostgreSQL server, you can configure users and privileges and restore the databases.

1. Click the Windows Start button, and start the pgAdmin3 program.
2. In the toolbar, click the New Server Registration button.

   The New Server Registration window opens.

3. On the Properties tab, enter the following information, and click OK:
   • Name: Any name, such as Matan or Local
   • Host: IP address of PostgreSQL server, which can also be localhost.
   • Port: 5432
   • Maintenance DB: postgres
   • Username: postg
   • Password: Leave empty

   If the connection fails, it means that the PostgreSQL server is not running or the IP address is incorrect.

4. Double-click Servers, and expand the content of Server Groups.
5. Create a new user:
   • Under Local, right-click on Login Roles, and click New Login Role.

     The New Login Role window opens.

   • On the Properties tab, enter the role name efi.
   • On the Definition tab, enter the password m4t4nsql.
   • Click OK.
6. Set up the databases:
   • Under Local, right-click on Databases, and click New Database.

     The New Database window opens.

   • On the Properties tab, enter the following information and click OK:
     • Name: matan_local (Matan front-end computer) or matan (Fiery XF server computer)
     • Owner: efi
7. Restore the database from the backup files:
   • Under Local, right-click on matan_local (Matan front-end computer) or matan (Fiery XF server computer), and click Restore.

     The Restore database window opens.

   • Under Filename, click the … button, and browse to the matan_local_psql.backup (Matan front-end computer) or matan_psql.backup (Fiery XF server computer) file.
   • Under Rolename, select postgres.
   • Click the Restore Options #1 tab.
   • Under Section, select Pre-data, Data and Post-data and click Restore.
   • Click Done.