Home > mailing lists

Re: [Non-DoD Source] Re: [ADMIN] Database Error - Mailing list pgsql-admin

From	Don Seiler
Subject	Re: [Non-DoD Source] Re: [ADMIN] Database Error
Date	October 25, 2017 22:03:12
Msg-id	CAHJZqBDxciiEhrvUOD4=CvrHRgk1WiXT556XnK+Zz3xZ54MLVA@mail.gmail.com Whole thread Raw
In response to	[ADMIN] Database Error ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
List	pgsql-admin

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.ferrell.ctr@navy.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?

From: Don Seiler
Date: 25 October 2017, 20:42:03
Subject: Re: [ADMIN] Database Error

From:
Date: 25 October 2017, 22:05:58
Subject: Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3