Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 11 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