Reliably backing up a live database
От | Tanstaafl |
---|---|
Тема | Reliably backing up a live database |
Дата | |
Msg-id | 4F479996.1000301@libertytrek.org обсуждение исходный текст |
Ответы |
Re: Reliably backing up a live database
Re: Reliably backing up a live database |
Список | pgsql-novice |
Hello, I am relatively new to SQL databases in general, and very new to postgresql, so please be gentle. My question has to do with how to properly perform a dump on a live database, that I've sort of inherited. We have some developers that are assisting with making some modifications, but I want to make sure that something they told me is true... I was told by one of the developers (who admits that he is still learning postgres) that I could get a successful dump of the live database using the following command, and more importantly, that I could do this safely without stopping the database first: ./pg_dump -U postgres -Z --blobs --oids --encoding=UTF-8 dbname > dbname.sql.gz First, will that command result in a dump file that can be used to perform a full restore in event of a catastrophe (these will be uploaded to off-site storage)? Second, can this command be run safely on a running database, or should the database be stopped first? If the latter, would someone be so kind as to provide an example of the commands necessary to stop this database, perform the dump, then restart it, that I could put in a cron job? Thanks in advance for any help... Simon
В списке pgsql-novice по дате отправления: