Re: export everything to text file - Mailing list pgsql-novice

From Josh Berkus
Subject Re: export everything to text file
Date
Msg-id web-824888@davinci.ethosmedia.com
Whole thread Raw
In response to export everything to text file  (Jim Lanford <jlsql@lanford.com>)
List 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



pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: Installing tsearch
Next
From: John Taylor
Date:
Subject: Encrypting text in postgresql