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

• pg_dump in stand alone backend at 2004-08-23 07:50:51 from Ulrich Wisser

Responses

• Re: pg_dump in stand alone backend at 2004-08-24 08:27:31 from Ulrich Wisser

pgsql-general by date

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