| From: | Prasanna Srinivasan Venkatasubramanian <to(dot)srini(at)gmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Backup database and logs |
| Date: | 2005-01-17 06:19:32 |
| Message-ID: | 7362d3630501162219715c580@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Hi all,
I want to take a backup of the database and the transaction logs of
the postgresql data. I am using postgresql 7.4.6. I would be happy if
any of u can answer the following questions..
1. Is there a way to do an incremental backup? I did a search in
google only to find that it is due in
7.3.(http://archives.postgresql.org/pgsql-admin/2002-07/msg00367.php)
Is it already been implemented? If so, how to use that?
2. How to backup the data using a sql query? I found that the db can
be backed-up using pg_dump or by doing a copy of the db directory. I
would like to do that from a SQL query instead, like the BACKUP query
of MS SQL Server.
3. Is there a way to backup the transaction logs? Does backing up the
log file solve the problem?
Thanks a lot!
Prasanna.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | KÖPFERL Robert | 2005-01-17 10:47:26 | Re: N/A |
| Previous Message | Afton & Ray Still | 2005-01-17 05:05:43 | Re: postgresql8 for windowsXP |