Re: Database maintainance in PGSQL
Posted by
ramesh, g. on
Feb 09, 2012; 9:02am
URL: http://ngl.70.s1.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268628.html
WHAT IS THE USE OF MAINTAINING DATABASE?
On Thu, Feb 9, 2012 at 2:22 PM, Support [via NewGenLib]
<[hidden email]> wrote:
Close all the programs on the Server first
1. Go to Pgadmin3 (Also login...Connect)
2. Select newgenlib database, right click and select maintenance
3. Select Vacuum (Selected by default), Full (Need to be selected by you), Analyse (Selected by default)
4. Click on "OK" and wait for the done button
--
G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540