Re: backup

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@xxxxxxxxxxxxxx so that your
> message can get through to the mailing list cleanly


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org