Thread: backup

Hi
i would like to know if i can use the database and in the same time make a
backup without stop the database?
Is it the backup very good or not?
can i program the backup?
Thanks

Hi Florian,

You can do it with pg_dump or pg_dumpall, if the you don't shut the
database, some mewly added data will not be int the backup...


Cheers!

WIm

Florian Litot wrote:

> Hi
> i would like to know if i can use the database and in the same time
> make a backup without stop the database?
> Is it the backup very good or not?
> can i program the backup?
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>

Hi Florian !

You can use pg_dump and pg_dumpall while the databases is 'running'. You can
also easily change e.g. your field definitions and datatypes by editing the
dump files. Very fast and very good also for moving databases from one
machine to another.

What do you mean by programming the backup ? If you want to time your backups
you can use a scheduled cronjob to do it and maybe another cronjob for
exporting the dumps to a backup machine with rsync ...

BR,

aarni

On Wednesday 11 September 2002 03:34 pm, you wrote:
> Hi
> i would like to know if i can use the database and in the same time make a
> backup without stop the database?
> Is it the backup very good or not?
> can i program the backup?
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly