Shutting down pgsql

Поиск
Список
Период
Сортировка
Искать

Shutting down pgsql

От:
Mark Warner <hammerhed@theitspecialists.net>
Дата:
Greetings,

    Is it possible, advisable, or terribly bad to shutdown a pgsql 
database with the do.maintenance script running? I have a 12gb db with 
about 780 tables that has been running maintenance now for approximately 
67 hours, and it is beginning to seriously degrade the performance of 
the application that drives. I am running on debian linux testing, with 
pgsql 7.3.4.

    So I am wondering if it is possible and advisable to either kill the 
task, or shut down the database in order to do some work on it.

Thanks,
Mark Warner.

Re: Shutting down pgsql

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Mark Warner  writes:
>     Is it possible, advisable, or terribly bad to shutdown a pgsql 
> database with the do.maintenance script running?

You didn't say exactly what that script is doing ... but in general
PG queries can be shut down safely.  What I'd do is kill the client
program running the script and then send SIGINT to the backend it's
connected to.  Shutting down the whole database is the hard way.

			regards, tom lane
FAQ