Re: backup

From: Aarni Ruuhimäki / Megative Tmi / KYMI(dot)com <aarni(dot)ruuhimaki(at)kymi(dot)com>
To: Florian Litot <flitot(at)besancon(dot)sema(dot)slb(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: backup
Date: 2002-09-16 20:11:36
Message-ID: 20020916201425.RZSC28788.fep06.tmt.tele.fi@there
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

  • backup at 2002-09-11 12:34:58 from Florian Litot

Browse pgsql-novice by date

  From Date Subject
Next Message Oliver Elphick 2002-09-16 20:18:24 Re: SIGHUP postmaster
Previous Message Tom Lane 2002-09-16 17:44:14 Re: Postgres storing time in strange manner