Backing up postgresql databases
| От | Peter Schuller |
|---|---|
| Тема | Backing up postgresql databases |
| Дата | |
| Msg-id | 20010317223923.X441@prometheus обсуждение исходный текст |
| Ответы |
RE: Backing up postgresql databases
|
| Список | pgsql-admin |
Hello, How do people normally backup up postgresql databases? The obviously safe solution is to shut down the database during backup, but is Postgresql storage such that it's safe to backup a running DB? I.e., is the database guaranteed to be in a consistent state after restoration? I'm talking a standard backup procedure now; say a tar -czvf. So that assuming certain procedures during storage, it should be possible to guarantee this (although it wouldn't be easy). The questions is, does Postgresql do that? I'm sceptical :) Thanks! -- / Peter Schuller, InfiDyne Technologies HB PGP userID: 0x5584BD98 or 'Peter Schuller <peter.schuller@infidyne.com>' Key retrival: Send an E-Mail to getpgpkey@scode.infidyne.com E-Mail: peter.schuller@infidyne.com Web: http://scode.infidyne.com
В списке pgsql-admin по дате отправления: