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

Поиск
Список
Период
Сортировка
От Don Seiler
Тема Re: [Non-DoD Source] Re: [ADMIN] Database Error
Дата
Msg-id CAHJZqBDxciiEhrvUOD4=CvrHRgk1WiXT556XnK+Zz3xZ54MLVA@mail.gmail.com
обсуждение исходный текст
Ответ на [ADMIN] Database Error  ("Ferrell, Denise D CTR NSWCDD, H11" <denise.ferrell.ctr@navy.mil>)
Список 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?

--
Don Seiler
www.seiler.us

В списке pgsql-admin по дате отправления:

Предыдущее
От: Don Seiler
Дата:
Сообщение: Re: [ADMIN] Database Error
Следующее
От:
Дата:
Сообщение: Re: [ADMIN] Migrate from Oracle 12g to PostgreSQL 9.3