---
name: "sisu_postgresql"
section: "1"
platform: "linux"
package: "sisu-postgresql"
version: "0.68.0-1"
release: "Debian 5.0 (Lenny)"
platforms: ["linux"]
url: "https://new.carta.tech/sisu_postgresql"
---

# sisu\_postgresql(1)

package to install what sisu needs to to populate a postgresql database (postgresql dependency component)

## NAME

sisu - package to install what sisu needs to to populate a postgresql database (postgresql dependency component)

## SYNOPSIS

sisu -Dv \[filename/wildcard \] sisu -Dv \[instruction\]

## SISU - SEARCH,

RALPH AMISSAH

## 1. POSTGRESQL

## 1.1 NAME

**SiSU** - Structured information, Serialized Units - a document publishing system, postgresql dependency package

## 1.2 DESCRIPTION

Information related to using postgresql with sisu (and related to the sisu\_postgresql dependency package, which is a dummy package to install dependencies needed for **SiSU** to populate a postgresql database, this being part of **SiSU** - man sisu).

## 1.3 SYNOPSIS

  sisu -D  \[instruction\]  \[filename/wildcard  if  required\]

  sisu -D --pg --\[instruction\]  \[filename/wildcard  if  required\]

## 1.4 COMMANDS

Mappings to two databases are provided by default, postgresql and sqlite, the same commands are used within sisu to construct and populate databases however -d (lowercase) denotes sqlite and -D (uppercase) denotes postgresql, alternatively --sqlite or --pgsql may be used

**-D or --pgsql** may be used interchangeably.

## 1.4.1 CREATE AND DESTROY DATABASE

- **--pgsql --createall**

   initial  step,  creates  required  relations  (tables,  indexes)  in  existing  (postgresql)  database  (a  database  should  be  created manually  and  given  the  same  name  as  working  directory,  as requested)  (rb.dbi)

- **sisu -D --createdb**

   creates  database  where  no  database  existed  before

- **sisu -D --create**

   creates  database  tables  where  no  database  tables  existed before

- **sisu -D --Dropall**

   destroys  database  (including  all  its  content)!  kills  data and  drops  tables,  indexes  and  database  associated  with  a given  directory  (and  directories  of  the  same  name).

- **sisu -D --recreate**

   destroys  existing  database  and  builds  a  new  empty  database  structure

## 1.4.2 IMPORT AND REMOVE DOCUMENTS

- **sisu -D --import -v \[filename/wildcard\]**

  populates database with the contents of the file. Imports documents(s) specified to a postgresql database (at an object level).

- **sisu -D --update -v \[filename/wildcard\]**

  updates file contents in database

- **sisu -D --remove -v \[filename/wildcard\]**

  removes specified document from postgresql database.

## DOCUMENT INFORMATION (METADATA)

## METADATA

Document Manifest @ \<http://sisudoc.org/sisu\_manual/sisu\_postgresql/sisu\_manifest.html\>

**Dublin Core** (DC)

*DC tags included with this document are provided here.*

DC Title: *SiSU - Search*

DC Creator: *Ralph Amissah*

DC Rights: *Copyright (C) Ralph Amissah 2007, part of SiSU documentation, License GPL* 3

DC Type: *information*

DC Date created: *2002-08-28*

DC Date issued: *2002-08-28*

DC Date available: *2002-08-28*

DC Date modified: *2007-09-16*

DC Date: *2007-09-16*

**Version Information**

Sourcefile: *sisu\_postgresql.sst*

Filetype: *SiSU text 0.58*

Sourcefile Digest, MD5(sisu\_postgresql.sst)= *9010e85001c50e30ba2ab69f9097825a*

Skin\_Digest: MD5(skin\_sisu\_manual.rb)= *20fc43cf3eb6590bc3399a1aef65c5a9*

**Generated**

Document (metaverse) last generated: *Sat Sep 29 17:05:38 +0100 2007*

Generated by: *SiSU* *0.59.1* of 2007w39/2 (2007-09-25)

Ruby version: *ruby 1.8.6 (2007-06-07 patchlevel 36)  \[i486-linux\]*

- Other versions of this document:

  - manifest: \<http://www.jus.uio.no/sisu/sisu\_postgresql/sisu\_manifest.html\>

  - html: \<http://www.jus.uio.no/sisu/sisu\_postgresql/toc.html\>

  - pdf: \<http://www.jus.uio.no/sisu/sisu\_postgresql/portrait.pdf\>

  - pdf: \<http://www.jus.uio.no/sisu/sisu\_postgresql/landscape.pdf\>

  - at: \<http://www.jus.uio.no/sisu\>

  - \* Generated by: SiSU 0.59.1 of 2007w39/2 (2007-09-25)

  - \* Ruby version: ruby 1.8.6 (2007-06-07 patchlevel 36) \[i486-linux\]

  - \* Last Generated on: Sat Sep 29 17:05:39 +0100 2007

  - \* SiSU http://www.jus.uio.no/sisu