SEO

#1 (**permalink**) 04-09-2008, 06:13 PM

pg doc recommends to use

pg_dumpall -c | gzip >backup.gz

In windows it writes whole file in uncompressed form to temporary file and
only then runs gzip.
This requires large amout of free disk space in temporary file space and
thus is not reasonable.

Which is reasonable way to backup cluster in Windows in compressed format ?

Andrus.

#2 (**permalink**) 04-09-2008, 06:14 PM

On 03.07.2007 17:18, Andrus wrote:
> Which is reasonable way to backup cluster in Windows in compressed format ?

Is the windows pg_dump different from the *nix one? If not, what is the
problem with -Fc?

--
Regards,
Hannes Dorbath

#3 (**permalink**) 04-09-2008, 06:14 PM

> Is the windows pg_dump different from the *nix one?

I my knowledge they are exactly same.

> If not, what is the problem with -Fc?

my application user = postgres user

pg_dump does not backup user account. Users, groups and and passwords are
lost.

I use pg_dumpall -g but in this case I have two backup files: one regular
backup and second contains sql scripts for user creation.

How to force pg_dump to backup users also ?

Andrus.

#4 (**permalink**) 04-09-2008, 06:14 PM

On 04.07.2007 10:42, Andrus wrote:
> I use pg_dumpall -g but in this case I have two backup files: one
> regular backup and second contains sql scripts for user creation.
>
> How to force pg_dump to backup users also ?

There is no way around that.

pg_dumpall -g
pg_dump -Fc for each DB.

--
Regards,
Hannes Dorbath

#5 (**permalink**) 04-09-2008, 06:14 PM

> There is no way around that.
>
> pg_dumpall -g
> pg_dump -Fc for each DB.

Thank you.

How to backup whole cluster so that huge temprary file containing all data
in uncompressed form is not created in Windows temporary directory (
equivalent to pg_dumpall -c | gzip >backup in Linux ) ?

Pipe in windows creates huge temprary file.

Andrus.

#6 (**permalink**) 04-09-2008, 06:15 PM

On 04.07.2007 17:14, Andrus wrote:
> How to backup whole cluster so that huge temprary file containing all
> data in uncompressed form is not created in Windows temporary directory
> ( equivalent to pg_dumpall -c | gzip >backup in Linux ) ?
>
> Pipe in windows creates huge temprary file.

pg_dumpall has lot of disadvantages compared to pg_dump -Fc, I don't see
the point why one would want that.

What I'd recommend is to use pg_dumpall -g and pg_dump -Fc on each DB.
Then get a copy of rdiff-backup for windows to create nice incremental
backups. Wrap those 3 things in a cmd script and use the task scheduler
to run it in a given interval.

--
Regards,
Hannes Dorbath

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Reasonable way to backup cluster Windows