Database maintainance in PGSQL

[Maregowda R]

Sir, Please send me how to maintain the database. Thanking you Maregowda R

[Support]

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

[ramesh, g.]

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

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268608.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

--
G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540

[Verus Open Source Support]

Hi,
Its speeds up the database response.

On Thursday 09 February 2012 02:32 PM, ramesh, g. [via NewGenLib] wrote:

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

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268608.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

--
G. Ramesh
Librarian
Vikas College of Engg & Tech.
NUNNA - 521 212
Vijayawada Rural
Krishna Dist., A.P.
Cell: 9441527540

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7268628.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

... [show rest of quote]

[pedroparkero]

Good day! Thanks for this tip.
But what frequency do you recommend that we do our database maintenance?

[pedroparkero]

Also, when you mean "close all the programs on the server first", do you mean the server computer or do I have to close the running RunNGLServer.bat? Thanks.

[Verus Open Source Support]

Close the running RunNGLServer.bat

On Saturday 11 February 2012 02:58 PM, pedroparkero [via NewGenLib] wrote:

Also, when you mean "close all the programs on the server first", do you mean the server computer or do I have to close the running RunNGLServer.bat? Thanks.

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7275646.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML

[Verus Open Source Support]

Once in a month.

On Saturday 11 February 2012 02:54 PM, pedroparkero [via NewGenLib] wrote:

Good day! Thanks for this tip.
But what frequency do you recommend that we do our database maintenance?

---

If you reply to this email, your message will be added to the discussion below:

http://newgenlib.2944635.n2.nabble.com/Database-maintainance-in-PGSQL-tp7268191p7275643.html

To start a new topic under NewGenLib, email [hidden email]
To unsubscribe from NewGenLib, click here.
NAML