|
1
|
<!--
|
|
2
|
* '$RCSfile$'
|
|
3
|
* Purpose: web page describing how to manually run database scripts
|
|
4
|
* Copyright: 2008 Regents of the University of California and the
|
|
5
|
* National Center for Ecological Analysis and Synthesis
|
|
6
|
* Authors: Michael Daigle
|
|
7
|
*
|
|
8
|
* '$Author: daigle $'
|
|
9
|
* '$Date: 2008-11-19 16:48:24 -0800 (Wed, 19 Nov 2008) $'
|
|
10
|
* '$Revision: 4597 $'
|
|
11
|
*
|
|
12
|
*
|
|
13
|
-->
|
|
14
|
|
|
15
|
<!DOCTYPE html PUBLIC "-//W3C//DTD html 4.0//EN">
|
|
16
|
<html>
|
|
17
|
|
|
18
|
<head>
|
|
19
|
<title>How to Manually Run Database Scripts</title>
|
|
20
|
<link rel="stylesheet" type="text/css" href="./common.css">
|
|
21
|
<link rel="stylesheet" type="text/css" href="./default.css">
|
|
22
|
</head>
|
|
23
|
|
|
24
|
<body>
|
|
25
|
|
|
26
|
<table class="tabledefault" width="100%">
|
|
27
|
<tr><td rowspan="2"><img src="./images/KNBLogo.gif"></td>
|
|
28
|
<td colspan="7">
|
|
29
|
<div class="title">How to Manually Run Database Scripts</div>
|
|
30
|
</td>
|
|
31
|
</tr>
|
|
32
|
<tr>
|
|
33
|
<td><a href="/" class="toollink"> KNB Home </a></td>
|
|
34
|
<td><a href="/data.html" class="toollink"> Data </a></td>
|
|
35
|
<td><a href="/people.html" class="toollink"> People </a></td>
|
|
36
|
<td><a href="/informatics" class="toollink"> Informatics </a></td>
|
|
37
|
<td><a href="/biodiversity" class="toollink"> Biocomplexity </a></td>
|
|
38
|
<td><a href="/education" class="toollink"> Education </a></td>
|
|
39
|
<td><a href="/software" class="toollink"> Software </a></td>
|
|
40
|
</tr>
|
|
41
|
</table>
|
|
42
|
<hr>
|
|
43
|
|
|
44
|
<div class="header1">Table of Contents</div>
|
|
45
|
<div class="toc">
|
|
46
|
<div class="toc1"><a href="#Overview">Overview</a></div>
|
|
47
|
<div class="toc1"><a href="#Postgres">PostgreSQL</a></div>
|
|
48
|
<div class="toc2"><a href="#Linux">Linux</a></div>
|
|
49
|
</div>
|
|
50
|
|
|
51
|
<a name="Overview"></a><div class="header1">Overview</div>
|
|
52
|
<p>Sometimes it will be necessary to run a database script
|
|
53
|
manually. The following sections describe how.</p>
|
|
54
|
|
|
55
|
<a name="Postgres"></a><div class="header1">PostgreSQL</div>
|
|
56
|
<a name="Linux"></a><div class="header2">Linux</div>
|
|
57
|
<p>At the command line, you can run:</p>
|
|
58
|
<div class="code">psql -U metacat -W -h localhost metacat < <script-name></div>
|
|
59
|
<p>where <script-name> is the name of the script you want
|
|
60
|
to run. This assumes that your database and username are metacat.
|
|
61
|
You should adjust accordingly for different user or database names.</p>
|
|
62
|
|
|
63
|
|
|
64
|
</body>
|
|
65
|
</html>
|
