Home > mailing lists

Thread: Shell Script for Vacuum

Shell Script for Vacuum

From

Manish Kediyal

Date:

29 July 2013, 07:17:35

Hi,

I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.

It would be a great help if anyone could provide me a Shell Script to vacuum all DB's

Thanks and Regards

Manish Kediyal

Re: Shell Script for Vacuum

From

raghu ram

Date:

29 July 2013, 07:26:56

On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal <kediyal.manish@gmail.com> wrote:

Hi,

I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum all DB's

You can perform vacuum for all databases available in PostgreSQL Instance using "vacuumdb" utility and Command as follows:

/opt/PostgreSQL/9.2/bin/vacuumdb -a -z -v >> /tmp/vacuumanalyze.log 2>> /tmp/vacuumanalyze.log

Thanks & Regards

Raghu Ram

Re: Shell Script for Vacuum

From

Manish Kediyal

Date:

29 July 2013, 07:37:20

Thanks Raghu,

Is there a shell script for it, i wanna scheduled that through cron.

Thanks

Manish

On Mon, Jul 29, 2013 at 12:56 PM, raghu ram <raghuchennuru@gmail.com> wrote:

On Mon, Jul 29, 2013 at 12:47 PM, Manish Kediyal <kediyal.manish@gmail.com> wrote:
Hi,

I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum all DB's

You can perform vacuum for all databases available in PostgreSQL Instance using "vacuumdb" utility and Command as follows:

/opt/PostgreSQL/9.2/bin/vacuumdb -a -z -v >> /tmp/vacuumanalyze.log 2>> /tmp/vacuumanalyze.log

Thanks & Regards
Raghu Ram

Re: Shell Script for Vacuum

From

raghu ram

Date:

29 July 2013, 08:04:58

On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal <kediyal.manish@gmail.com> wrote:

Thanks Raghu,

Is there a shell script for it, i wanna scheduled that through cron.

You can create below Script for scheduling purpose:

#!/bin/bash

PGHOME=/opt/PostgreSQL/9.2/bin

LOG=/Backup/cron-script-logs

LOGFILE=vacuum_analyze_`date +"%Y-%m-%d-%T"`.log

$PGHOME/vacuumdb -a -z -v >> $LOG/$LOGFILE 2>> $LOG/$LOGFILE

Thanks & Regards

Raghu Ram

Re: Shell Script for Vacuum

From

Manish Kediyal

Date:

29 July 2013, 08:08:21

Thanks Raghu,

On Mon, Jul 29, 2013 at 1:34 PM, raghu ram <raghuchennuru@gmail.com> wrote:

On Mon, Jul 29, 2013 at 1:07 PM, Manish Kediyal <kediyal.manish@gmail.com> wrote:
Thanks Raghu,

Is there a shell script for it, i wanna scheduled that through cron.

You can create below Script for scheduling purpose:

#!/bin/bash
PGHOME=/opt/PostgreSQL/9.2/bin
LOG=/Backup/cron-script-logs
LOGFILE=vacuum_analyze_`date +"%Y-%m-%d-%T"`.log

$PGHOME/vacuumdb -a -z -v >> $LOG/$LOGFILE 2>> $LOG/$LOGFILE

Thanks & Regards
Raghu Ram

Re: Shell Script for Vacuum

From

Thomas Kellerer

Date:

29 July 2013, 16:31:57

Manish Kediyal wrote on 29.07.2013 09:17:
> I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.
> It would be a great help if anyone could provide me a Shell Script to vacuum all DB's
>

Is there a specific reason you don't want to use auto-vacuum or tune it to suit your needs?

Re: Shell Script for Vacuum

From

Manish Kediyal

Date:

30 July 2013, 04:41:28

Hi Thomas,

I am aware of of tht above 9.0 thr is default auto-vacuuming.............but I just want to tune according to my needs......

On Mon, Jul 29, 2013 at 10:01 PM, Thomas Kellerer <spam_eater@gmx.net> wrote:

Manish Kediyal wrote on 29.07.2013 09:17:

I have various DB in my DB cluster, i want to vacuum all DB's using a shell script...... scheduling via cron.
It would be a great help if anyone could provide me a Shell Script to vacuum all DB's

Is there a specific reason you don't want to use auto-vacuum or tune it to suit your needs?

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Re: Shell Script for Vacuum

From

rajivmehta0201

Date:

22 November 2014, 03:36:10

Hi,

I am running this script but it giving error.

vacuumdb: could not connect to database postgres: could not connect to
server: No such file or directory
    Is the server running locally and accepting
    connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Can you please help me on this?




--
View this message in context: http://postgresql.nabble.com/Shell-Script-for-Vacuum-tp5765414p5827854.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

Re: Shell Script for Vacuum

From

Raghavendra

Date:

22 November 2014, 11:50:03

On Fri, Nov 21, 2014 at 4:23 PM, rajivmehta0201 <rajivmehta0201@gmail.com> wrote:

Hi,

I am running this script but it giving error.

vacuumdb: could not connect to database postgres: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Can you please help me on this?

Check Postgres Server running or not ?

If running, check on which port its running ?

Accordingly edit the script and place below environment variables, then call the script.

PGUSER=postgres

PGPORT=5432 ## Give the port on which your server running

---

Regards,

Raghavendra

EnterpriseDB Corporation

Blog: http://raghavt.blogspot.com/

Re: Shell Script for Vacuum

From

Craig James

Date:

22 November 2014, 17:51:28

On Fri, Nov 21, 2014 at 5:23 AM, rajivmehta0201 <rajivmehta0201@gmail.com> wrote:

Hi,

I am running this script but it giving error.

vacuumdb: could not connect to database postgres: could not connect to
server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Can you please help me on this?

Try using the server's name rather than "localhost" or the default, for example:

psql -U postgres -h myservername

If that works, it means your pg_hba.conf isn't configured correctly for "localhost".

Craig

--
View this message in context: http://postgresql.nabble.com/Shell-Script-for-Vacuum-tp5765414p5827854.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

---------------------------------
Craig A. James

Chief Technology Officer

eMolecules, Inc.

---------------------------------