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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-novice by date

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