Submit a ticketCall us

Systems Monitoring for Dummies
Our new eBook will teach you the fundamentals and help you create monitors and alerts that are effective, meaningful, and actionable. Monitoring is more than a checkbox on your to-do list. This free eBook will give you practical advice to help you succeed in all aspects of monitoring – discovery, alerting, remediation, and troubleshooting. Don’t miss out on this indispensable resource for newbies, experienced IT pros, and everyone in between. Register 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: 43 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

Tags

Classifications

Public