Is there a concept of Redo log files in postgres.?

From: "Somasekhar Bangalore" <sbangalore(at)zensutra(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Is there a concept of Redo log files in postgres.?
Date: 2003-09-29 13:22:23
Message-ID: BF493B193A334743AA9EF48945E69C1346A751@exchange.india.zensutra.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I wanted to know like in oracle there is a concept of redo log files meant for backup and recovery. Is the same concept present in postgres.I have gone thru the documentation .it says backup can be taken thru 2 approaches
1.SQL Dump
2.File System level backup.

for SQL Dump command is ----> pg_dump dbname > outfile
for file system level backup ----> tar -cf backup.tar /usr/local/pgsql/data.

the second method is not practical cos we need to shut down the database server to make use of the tar.

Is there any other method's to back up data and restore data incase of media failure.?

thanks in advance

Somasekhar Bangalore

Browse pgsql-admin by date

  From Date Subject
Next Message Jodi Kanter 2003-09-29 14:25:31 new script
Previous Message Matej Puntar 2003-09-29 12:21:02 Re: ODBC Driver