[OPEN-ILS-DEV] cstore problem

[Rene Paquin]

I just noticed that comparing my tables to those of Dan's it appears
that the table reporter was not installed.  Can i add it in manually
somehow?

================================
Rene Paquin, MCSE
Library Network Administrator
Wilfrid Laurier University
Waterloo, Ontario, Canada
(519)884-0710 x3795
rpaquin at wlu.ca
**********************************************

>>> rpaquin at wlu.ca 05/15/07 8:48 AM >>>
When I run \dt I get this...

evergreen-# \dt
            List of relations
 Schema |     Name     | Type  |  Owner   
--------+--------------+-------+----------
 public | pg_ts_cfg    | table | postgres
 public | pg_ts_cfgmap | table | postgres
 public | pg_ts_dict   | table | postgres
 public | pg_ts_parser | table | postgres
(4 rows)

When I run \dn I get the following results:

evergreen=# \dn
        List of schemas
        Name        |   Owner   
--------------------+-----------
 action             | evergreen
 actor              | evergreen
 asset              | evergreen
 auditor            | evergreen
 authority          | evergreen
 biblio             | evergreen
 config             | evergreen
 container          | evergreen
 information_schema | postgres
 metabib            | evergreen
 money              | evergreen
 offline            | evergreen
 permission         | evergreen
 pg_catalog         | postgres
 pg_toast           | postgres
 public             | postgres
 stats              | evergreen
(17 rows)



================================
Rene Paquin, MCSE
Library Network Administrator
Wilfrid Laurier University
Waterloo, Ontario, Canada
(519)884-0710 x3795
rpaquin at wlu.ca
**********************************************

>>> don.mcmorris at gmail.com 05/15/07 2:15 AM >>>
My bad guys! \z is privileges.  Instead, run \dt.  According to the
manual, this should show the tables.

--Don

On 5/15/07, Hennie Rautenbach <hennie at sabinet.co.za> wrote:
> Don McMorris wrote:
> > First, I want to make sure the PostgreSQL server is functioning
right
> > and that the evergreen database is populated properly.  To do this:
> > root# su postgres -c "psql -h tamarak -p 5432 -U evergreen
evergreen"
> > evergreen> \z
> > evergreen> \q
> > root#
> Thought I'd do the same:
>
> opensrf at leo:~$ psql -h leo.sabinet.co.za -p 5432 -U postgres evergreen
> Password for user postgres:
> Welcome to psql 8.1.8, the PostgreSQL interactive terminal.
>
> Type:  \copyright for distribution terms
>        \h for help with SQL commands
>        \? for help with psql commands
>        \g or terminate with semicolon to execute query
>        \q to quit
>
> SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
>
> evergreen=# \z
>     Access privileges for database "evergreen"
>  Schema |     Name     | Type  | Access privileges
> --------+--------------+-------+-------------------
>  public | pg_ts_cfg    | table |
>  public | pg_ts_cfgmap | table |
>  public | pg_ts_dict   | table |
>  public | pg_ts_parser | table |
> (4 rows)
>
> evergreen=# \q
> opensrf at leo:~$
>
> Hennie
>
>
>
--------------------------------------------------------------------------------
>
> This transmission is for the intended addressee only and is
confidential
> information. If you have received this transmission in error, please
> delete it and notify the sender. The contents of this e-mail are the
> opinion of the writer only and are not endorsed by Sabinet Online
> Limited unless expressly stated otherwise.
>
--------------------------------------------------------------------------------
>