Re: pg_dump.... pg_restore...how long does it take? - Mailing list pgsql-general

From Tom Lane
Subject Re: pg_dump.... pg_restore...how long does it take?
Date
Msg-id 1515.1188487886@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump.... pg_restore...how long does it take?  (rafikoko <rako@wapice.com>)
List pgsql-general
rafikoko <rako@wapice.com> writes:
> Could you please suggest me other compination of parameters for pg_dump, so
> that it dumps complete database (inluding functions, triggers, procedures,
> operators, sequences, tables, views etc. and obviously data)?
> It doesn't have to be stored in .tar archive. Moreover I'd like to inform
> that I work in Windows environment.

If you don't have a very specific reason for using -Ft, don't --- the
-Fc and plain-sql-script alternatives are much more commonly used and
hence better debugged.  -Ft also has some other problems like a need
for extra temporary files.

            regards, tom lane

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: What kind of locks does vacuum process hold on the db?
Next
From: Tom Lane
Date:
Subject: Re: Autovacuum not vacuuming pg_largeobject