Thread: backup of my database...

backup of my database...

From
Ze Luis
Date:
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

Re: backup of my database...

From
bangh
Date:
Sure you can, check pg_dump.

--
Banghe

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


Re: backup of my database...

From
Herbert Rabago Ambos
Date:
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
>


RE: backup of my database...

From
Nicolas Huillard
Date:
I don't understand the answer : you mean it is possible to backup (pg_dump) while users are still connected to the DB ?
Andthis 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
>


RE: backup of my database...

From
Matthew
Date:
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
> >