Re: [Non-DoD Source] Re: Database Error

Don't reply off-list, you'll get better help if you keep the list involved.

On Wed, Oct 25, 2017 at 10:46 AM, Ferrell, Denise D CTR NSWCDD, H11 <
denise(dot)ferrell(dot)ctr(at)navy(dot)mil> wrote:

> Can you provide info on restarting in single user mode?
>

https://www.postgresql.org/docs/9.3/static/app-postgres.html, look for the
--single parameter. Not sure if there's a way to do it with pg_ctl, I don't
see one.

> I would assume the following in psql will work - vacuum -all -U <username>

Just run as postgres (superuser) in psql: vacuum freeze analyze verbose;

If you size your maintenance_work_mem appropriately, it should run well.
How big is your database?

--
Don Seiler
www.seiler.us