Re: Database versus filesystem for storing images

Поиск
Список
Период
Сортировка
От Jorge Godoy
Тема Re: Database versus filesystem for storing images
Дата
Msg-id 87irfli31c.fsf@gmail.com
обсуждение исходный текст
Ответ на Re: Database versus filesystem for storing images  (John McCawley <nospam@hardgeus.com>)
Список pgsql-general
John McCawley <nospam@hardgeus.com> writes:

> This is a web app, so in my example all of the images live on a web server,
> and our data lives on a separate database server.  We have a completely
> duplicated setup offsite, and mirror images of every server at the backup
> site.  Every night we use rsync to duplicate everything offsite.  Also, a cron
> job pg_dumps every night and copies the dump over to the backup DB server.
>
> And before anybody gives me any guff, our office is in New Orleans, and we
> went through Katrina with less than an hour of downtime, and without losing
> anything.  So there ;)

Anyway, you have no guarantee that all your images exist on file and that all
existing files have a corresponding entry in your database.

--
Jorge Godoy      <jgodoy@gmail.com>

В списке pgsql-general по дате отправления:

Предыдущее
От: "Jeremy Haile"
Дата:
Сообщение: Re: vacuum v. vacuumdb
Следующее
От: Jorge Godoy
Дата:
Сообщение: Re: Database versus filesystem for storing images