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
> >