Re: Loss of table structure on 7.3.19

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Paul B(dot) Anderson" <paul(dot)a(at)pnlassociates(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Loss of table structure on 7.3.19
Date: 2009-09-17 16:41:47
Message-ID: 20463.1253205707@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Paul B. Anderson" <paul(dot)a(at)pnlassociates(dot)com> writes:
> To clarify what a plain "vacuum" is, if you have an initdb data area,
> <a1> and the database listening on port <p1>,

> Is this sufficient,

> export PGDATA=<a1>
> export PGPORT=<p1>
> vacuumdb --all --analyze

> running as user postgres (on Linux)?

The --analyze isn't really necessary, but yeah that should do it.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message u235sentinel 2009-09-17 18:06:02 problems compiling postgres 8.3.7 on Solaris 10 64 bit with openssl
Previous Message Ron Mayer 2009-09-17 15:36:20 Re: hardware information