RE: backup of my database...

Everything I have read indicates that there is no need to take down the
database server before doing a backup.  This is true regardless of the
number of connected users and what they are working on at the time.  In
fact pg_dump fails unless postmaster is running.  The only reason you
would want to stop the server is if you backed up from the filesystem
using tar.

> -----Original Message-----
> From:    Nicolas Huillard [SMTP:nhuillard@ghs.fr]
> Sent:    Thursday, May 04, 2000 3:29 AM
> To:    pgsql-admin@postgresql.org
> Subject:    RE: [ADMIN] backup of my database...
>
> I don't understand the answer : you mean it is possible to backup
> (pg_dump) while users are still connected to the DB ? And this should
> be available only for version 7 ? Not versions 6.5.x ?
>
> Nicolas Huillard
>
> -----Message d'origine-----
> De:    Herbert Rabago Ambos [SMTP:herbert@hindang.msuiit.edu.ph]
> Date:    jeudi 4 mai 2000 10:02
> À:    Ze Luis
> Cc:    pgsql-admin@postgresql.org
> Objet:    Re: [ADMIN] backup of my database...
>
>
> What version are you using.... and yes it's possible if you're using
> version 7.
>
> herbert
>
> On Wed, 3 May 2000, Ze Luis wrote:
>
> > how do i do backup of my databases in Postgresql. Must i terminate
> the
> > postmaster process or is it possible make backup with my web site
> > running and users conecteds ???
> >
> > Thank's
> >