Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group