Re: export everything to text file

From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: Jim Lanford <jlsql(at)lanford(dot)com>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: export everything to text file
Date: 2002-03-12 05:28:26
Message-ID: web-824888@davinci.ethosmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Jim,

> I had an sys admin recommend that I export my critical DB's to
> atext file before the tape does it's auto backup (dump)
> That way I don't have to stop the PostgreSQL each night for 30 mins.
>
> What is this called. What might it be called in the index of a book
> like:
> PostgreSQL Essential Reference
> or
> Beginning DB with PostgreSQL

Look up pg_dump and pg_dumpall in either book, under "command line
utilities."

-Josh

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message John Taylor 2002-03-12 14:37:16 Encrypting text in postgresql
Previous Message Tom Lane 2002-03-12 01:53:15 Re: Installing tsearch