Wtx ~ Wt Extension Library
WtxLib
Main Page
Related Pages
Modules
Namespaces
Classes
Files
Create a new database or copy an existing database
// sudo -u postgres psql -c 'create database test;'
// 'grant all privileges on database test to username;
//
// to copy a database in to another database;
// 1. close any open applications on the source database
// 2. execute the following as 'root' user;
// a. serveradmin@lsus1:projects/warehouse$ sudo -u postgres psql
// b. [sudo] password for serveradmin:
// c. psql (9.5.19)
// d. Type "help" for help.
// e. postgres=# create database warehouse_1 with template warehouse;
//
// this will copy in its entirety with all permissions the source database
// to the destination database.
//
Generated on Sat Apr 10 2021 05:56:08 for Wtx ~ Wt Extension Library by
1.8.11