Skip site navigation (1) Skip section navigation (2)

Re: pg_dump in stand alone backend

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: Ulrich Wisser <ulrich(dot)wisser(at)relevanttraffic(dot)se>
Subject: Re: pg_dump in stand alone backend
Date: 2004-08-23 14:24:05
Message-ID: 4129FE05.5020402@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-general
Ulrich Wisser wrote:

> Hi,
> 
> I would like to stop the postmaster every night and run
> 
> vacuum
> pg_dump
> reindex
> 
> in the stand alone backend.
> 
> Vacuum and reindex seem to be quite easy, as I can setup a small script 
> with both commands. But what about pg_dump. That seems "somewhat" more 
> complex.

Explain what exactly you are trying to do, why do you have to stop
the postmaster ? If you request is due only to forbid the access then
you can replace the pg_hba.conf with a "void" one and replace it again
at the end of operations.

BTW vacuum, pg_dump, reindex are operations that can be performed
with the server up and running.

Regards
Gaetano Mendola




In response to

Responses

pgsql-general by date

Next:From: Bruce MomjianDate: 2004-08-23 14:41:10
Subject: Re: Unsupported 3rd-party solutions (Was: Few questions
Previous:From: Gaetano MendolaDate: 2004-08-23 14:19:34
Subject: Re: Connection to a PG 8.0 Beta 1 win32 server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group