| From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: fatal error on 8.1 server |
| Date: | 2006-11-27 20:22:19 |
| Message-ID: | 456B48FB.7070906@amsoftwaredesign.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Alvaro Herrera wrote:
> Stop the postmaster, start a standalone backend, and issue a
> database-wide VACUUM on database postgres.
>
>
Just in case anyone is interested I did get it up and running with no
damage to the system.
It took well over a year for it to reach the 1 million threshold mark.
This is on a very very busy Postfix email server that does lookups
against at table for things like relay hosts etc.
It took awhile for me to piece together everything I needed from the
docs, I found the info about starting a standalone backend in the
reindex docs.
--
Tony Caduto
AM Software Design
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql
Your best bet for Postgresql Administration
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Ribe | 2006-11-27 20:34:11 | Re: IS it a good practice to use SERIAL as Primary Key? |
| Previous Message | Joshua D. Drake | 2006-11-27 20:08:36 | Re: IS it a good practice to use SERIAL as Primary Key? |