Thread: backup of my database...
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
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
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 >
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 >
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 > >