Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 ...



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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group