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
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
---(end of
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,