Skip site navigation (1) Skip section navigation (2)

help

From: "Stephen Hardman" <support(at)crystal(dot)com(dot)au>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: help
Date: 2001-01-16 14:44:36
Message-ID: 012401c07fca$d95324c0$a42f15cb@crystal.com.au (view raw or flat)
Thread:
Lists: pgsql-novice
hi i have a database it was running but i ignored it so yes i deserve to die
it was running fine but now it chews all cpu through postmaster is there a
way to delete the information contained in tables
 +------------------+----------------------------------+----------+
 |  Owner           |             Relation             |   Type   |
 +------------------+----------------------------------+----------+
 | ispdb            | acl                              | table    |
 | ispdb            | acl_adminname_key                | index    |
 | ispdb            | actions                          | table    |
 | ispdb            | actions_pkey                     | index    |
 | ispdb            | actionsall_key                   | index    |
 | ispdb            | bringups                         | table    |
 | ispdb            | bringups_by_userid               | index    |
 | ispdb            | bringups_pkey                    | index    |
 | ispdb            | gst                              | table    |
 | ispdb            | gst_pkey                         | index    |
 | ispdb            | invoice                          | table    |
 | ispdb            | invoice_pkey                     | index    |
 | ispdb            | joinrequest                      | table    |
 | ispdb            | joinrequest_pkey                 | index    |
 | ispdb            | logins                           | table    |
 | ispdb            | logins_pkey                      | index    |
 | ispdb            | mailalias                        | table    |
 | ispdb            | mailalias_alias_key              | index    |
 | ispdb            | mailalias_pkey                   | index    |
 | ispdb            | maxnums                          | table    |
 | ispdb            | netservers                       | table    |
 | ispdb            | onlineusers                      | table    |
 | ispdb            | plantype                         | table    |
 | ispdb            | plantype_pkey                    | index    |
 | ispdb            | prepaidhours                     | table    |
 | ispdb            | prepaidhours_pkey                | index    |
 | ispdb            | retiredusers                     | table    |
 | ispdb            | retiredusers_pkey                | index    |
 | ispdb            | supservices                      | table    |
 | ispdb            | supservices_pkey                 | index    |
 | ispdb            | usagesummary                     | table    |
 | ispdb            | usagesummary_pkey                | index    |
 | ispdb            | userbilling                      | table    |
 | ispdb            | userbilling_pkey                 | index    |
 | ispdb            | userprofile                      | table    |
 | ispdb            | userprofile_pkey                 | index    |
 | ispdb            | userprofile_username_key         | index    |
 +------------------+----------------------------------+----------+
to remove all the info in the big nes
i know i am a idiot but trying to learn
thanks
stephen hardman



Responses

  • Re: help at 2001-01-19 04:32:27 from rob

pgsql-novice by date

Next:From: Orlando Eloy GentilDate: 2001-01-16 15:28:15
Subject: Re: Unix Scripts linking with Postgres
Previous:From: TamsinDate: 2001-01-16 12:19:32
Subject: RE: What am I doing wrong?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group