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

Re: automatic backup

From: "Massa, Harald Armin" <chef(at)ghum(dot)de>
To: Jefferson Bonamim - Glan Data Sistemas <jefferson(at)glandata(dot)com(dot)br>
Cc: pgadmin-support(at)postgresql(dot)org, Danilo - Glan Data <danilo(dot)a(at)glandata(dot)com(dot)br>
Subject: Re: automatic backup
Date: 2010-11-19 13:44:57
Message-ID: AANLkTinz2W+DHAmJG+QOcyU+YDD=C9HZwC5Jr8Pk3C-f@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hello Jefferson,

to answer your question:

a) PostgreSQL 8.0 was End-Of-Lived in 2007. You should start your
sales-pitch of updating to something more recent, as in PostgreSQL 8.4 or
9.0
http://www.postgresql.org/about/news.865

b) to setup an automatic backup on Windows at a client side with no local
DBA (or similiar qualified personel), your success will be better when using
pg_dump and "planned tasks".

http://www.postgresql.org/docs/9.0/static/app-pgdump.html
http://support.microsoft.com/kb/308569   (assuming XP)

In a nutshell:

create .cmd files with
pg_dump -U <username> --format=C <databasename> > dumpfilename.dmp

schedule those .cmd files to run BEFORE any file based backup of the
dumpfilename.dmp files happens

(as an exercise: create a daily different dumpfilename via script, run the
same .cmd every day)

best wishes,

Harald

On Fri, Nov 19, 2010 at 14:19, Jefferson Bonamim - Glan Data Sistemas <
jefferson(at)glandata(dot)com(dot)br> wrote:

>   Hello,
>
> My name is Jefferson and I am an user of Postgres.
>
> I use the Postgresql 8.0.15 for Windows in some clients and I have a
> question.
>
> I needed to know how to configurate the automatic backup on PG Admin 1.10.
>
>
>
> I see the FAQ, but I don’t understood anything.
>
> How do I configure this?
>
> Can you help me please?
>
>
>
> Thanks,
>
> Jefferson.
>
>
>
>
>



-- 
GHUM GmbH
Harald Armin Massa
Spielberger Straße 49
70435 Stuttgart
0173/9409607

Amtsgericht Stuttgart, HRB 734971
-
persuadere.
et programmare

In response to

  • automatic backup at 2010-11-19 13:19:30 from Jefferson Bonamim - Glan Data Sistemas

pgadmin-support by date

Next:From: Jeferson Alberto RodriguesDate: 2010-11-19 15:51:57
Subject: Re: automatic backup
Previous:From: Jefferson Bonamim - Glan Data SistemasDate: 2010-11-19 13:19:30
Subject: automatic backup

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