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

Re: Backing Up ?

From: "Oliveiros d'Azevedo Cristina" <oliveiros(dot)cristina(at)marktest(dot)pt>
To: "James David Smith" <james(dot)david(dot)smith(at)gmail(dot)com>,<pgsql-novice(at)postgresql(dot)org>
Subject: Re: Backing Up ?
Date: 2011-06-16 13:56:00
Message-ID: D4AC363F105344BE95510686AC75979B@marktestcr.marktest.pt (view raw or flat)
Thread:
Lists: pgsql-novice
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 


In response to

  • Backing Up ? at 2011-06-16 13:46:34 from James David Smith

pgsql-novice by date

Next:From: Jean-Yves F. BarbierDate: 2011-06-17 04:12:03
Subject: test CHECK on command line
Previous:From: James David SmithDate: 2011-06-16 13:46:34
Subject: Backing Up ?

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