Submit a ticketCall us

AnnouncementsChange Is Inevitable

Get valuable help when it comes to tracking and monitoring changes. SolarWinds® Server Configuration Monitor (SCM) is designed to help you: detect, track, and receive alerts when changes occur, correlate system performance against configuration changes, compare server and application configuration against custom baselines, and verify application and system changes.

Learn more.

Home > Success Center > Web Help Desk (WHD) > WHD - Knowledgebase Articles > 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: 1,177 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