Hi All,
I have no Postgres knowledge. I am trying to find out if it would be possible to Snapshot a Postgres database for a
PostgreSQL user who has a mixed environment and takes Snapshot copies of all his other databases.
What we would normally do for a database Snapshot in other database environments is to write a script which places
the database into a hot backup mode, takes the Snapshot, and then brings the database back into normal operational
mode.
I have talked to a couple of PostgreQL DBAs and I understand that, while there are hot backups with pg_dump, there is
no hot backup mode that the database can be placed into in Postgres. Can I get confirmation of this?
Assuming the answer to the above is "no", one DBA I talked to mentioned that Postgres writes to a buffer(?) or log(?)
before the disk. So is it possible to just simply Snapshot the database on the fly? How does Postgres handle a
situation where server running the database crashes? How does it handle error recovery? This would be similar to
taking a snapshot on the fly....
If anyone can help me out here, it would be appreciated!
Cheers,
Rowena
st1\:* {BEHAVIOR: url(#ieooui)
}
@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; mso-header-margin: .5in; mso-footer-margin: .5in; mso-paper-source: 0; }
P.MsoNormal {FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
LI.MsoNormal {FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
DIV.MsoNormal {FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"; mso-style-parent: ""; mso-pagination: widow-orphan; mso-fareast-font-family: "Times New Roman"
}
A:link {COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlink {COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
A:visited {COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
SPAN.MsoHyperlinkFollowed {COLOR: blue; TEXT-DECORATION: underline; text-underline: single
}
DIV.Section1 {page: Section1
}
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Rowena Samuel Network Appliance, Inc.
Systems Engineer 201 City Centre Drive, Suite 900
Tel 905.804.1099 x3053 Mississauga, Ontario L5B 2T4
Cell 416.400.2060
Email rowena@netapp.com www.netapp.com
"I always wanted to be somebody, but now I realize I should have been more specific." - Lily Tomlin