From: Emils Klotins <emils@dot.lv>
To: pgsql-sql@postgresql.org
Subject: Backup?
Date: Tue, 27 Jun 2000 15:09:01 +0200
Message-ID: <3958C38D.19942.24191291@localhost> (raw)
Hello,
I had a look for 'backup' on the mailing list archives and strangely
enough didn't find a message containing the word in admin, general
and sql mailing lists... I am sure this must have been asked before,
but still:
Would it be possible to backup a db by just copying the dir struct
under the PG_DATA or must I absolutely use pg_dump? I am
using Postgres 7.0. The purpose of the backup is of course to have
a copy handy if eg the harddrive breaks. As I understand pg_dump
could be comparatively slower, plus it produces a text format
dumpfile, which could be kind of large in my db in future.
Thanks in advance,
Emils
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emils@dot.lv
Subject: Re: Backup?
In-Reply-To: <3958C38D.19942.24191291@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox