Re: pg_dump.... pg_restore...how long does it take?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rafikoko <rako(at)wapice(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dump.... pg_restore...how long does it take?
Date: 2007-08-30 15:31:26
Message-ID: 1515.1188487886@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rafikoko <rako(at)wapice(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2007-08-30 15:34:30 Re: PostgreSQL.Org
Previous Message Alvaro Herrera 2007-08-30 15:27:02 Re: PostgreSQL.Org