I've been using pg_dump on a weekly basis.
It's been doing a good job for me and when my last PC' hard disk has gone
for a Burton it was quite easy to restore it...
----- Original Message -----
From: "James David Smith" <james(dot)david(dot)smith(at)gmail(dot)com>
Sent: Thursday, June 16, 2011 2:46 PM
Subject: [NOVICE] Backing Up ?
> Hi all,
> I'm using a PostgreSQL + PostGIS database for a large project at the
> moment, and would like advice on the best way to back it up incase
> something goes wrong or I delete something by accident etc...? I see
> that if I right-click on my database there is a 'Back-up' option which
> creates a back-up of the database as a compressed file, so I thought
> that this would be perfect, however I just made a minor error and
> decided to reintate my back-up using the 'right-click > restore'
> option, and it hasn't seem to do it. So I'm a bit confused now.
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-novice by date
|Next:||From: Jean-Yves F. Barbier||Date: 2011-06-17 04:12:03|
|Subject: test CHECK on command line|
|Previous:||From: James David Smith||Date: 2011-06-16 13:46:34|
|Subject: Backing Up ?|