| From: | "Anthony E (dot) Greene" <agreene(at)pobox(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: backup |
| Date: | 2001-01-08 23:12:40 |
| Message-ID: | 20010108181240.C19618@cp5340 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Mon, 08 Jan 2001 10:38:13 Tom Lane wrote:
>Copying the entire $PGDATA directory (not only the base/ subdirectory)
>is sufficient, if and only if the database is completely idle while you
>do it --- I'd recommend stopping the postmaster to be sure. Otherwise
>you will get inconsistent files. In particular, you WILL have problems
>if $PGDATA/pg_log is out of sync with any table data file.
You will also need to insure that the version of PostgreSQL used in the
recovery process is that same as that used before the failure. The binary
files are not completely portable across versions.
--
Anthony E. Greene <agreene(at)pobox(dot)com> <http://www.pobox.com/~agreene/>
PGP Key: 0x6C94239D/7B3D BD7D 7D91 1B44 BA26 C484 A42A 60DD 6C94 239D
Chat: AOL/Yahoo: TonyG05 ICQ: 91183266
Linux. The choice of a GNU Generation. <http://www.linux.org/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-09 06:36:04 | Re: Advice on stored proc error handling versus Sybase? |
| Previous Message | Ken Corey | 2001-01-08 22:56:40 | Advice on stored proc error handling versus Sybase? |