Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

Home > Success Center > Web Help Desk (WHD) > Rename or drop a default empty PostgreSQL embedded database

Rename or drop a default empty PostgreSQL embedded database

Table of contents
No headers
Created by Interspire Import, last modified by MindTouch on Jun 23, 2016

Views: 25 Votes: 0 Revisions: 9

Rename/Drop default empty PostgreSQL embedded database

Windows

  1. Open cmd > enter: cd C:\Progra~1\WebHelpDesk
  2. Enter: pgsql9\bin\psql -h 127.0.0.1 -p 20293 -U whd -d template1
  3. If prompted for the database password, enter your database password and execute the following statements:
  4. ALTER DATABASE whd rename to whd_old;
  5. CREATE DATABASE (enter the password for the database without brackets);
  6. Exit psql tool: \q and press Enter.

Virtual Appliance (Linux)

  1. Open cmd > enter: cd /usr/local/webhelpdesk/
  2. Enter: sudo pgsql9/bin/psql -h 127.0.0.1 -p 20293 -U whd -d template1
  3. If prompted for the database password, enter your database password and execute the following statements:
  4. ALTER DATABASE whd rename to whd_old;
  5. CREATE DATABASE whd (enter the password for the database without brackets);
  6. Exit psql tool: \q and press Enter.
Last modified
04:46, 23 Jun 2016

Tags

Classifications

Public