Re: Backing Up ?

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...

Best,
Oliveiros

----- Original Message -----
From: "James David Smith" <james(dot)david(dot)smith(at)gmail(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
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.
>
> Thanks
>
> James
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice