Image crud for Postgresql in php?
От | Richard Bernstein |
---|---|
Тема | Image crud for Postgresql in php? |
Дата | |
Msg-id | yjhudg7qi4wquf251orbkll8.1592215656002@email.android.com обсуждение исходный текст |
Список | pgsql-admin |
I have been attempting to add an image crud using postgresql to my php app. I use a local copy of mysql for the admin databut wanted to use a remotely hosted copy of postgres for the images. After a lot of effort it is clear that the imagecrud I am using doesn't support being hosted in a second database. Does anyone know of a php callable image crud thatuses Postgresql? On June 8, 2020, at 22:43, Peter <pmc@citylink.dinoex.sub.org> wrote: Actually, the affair had some good side: as usual I was checking my own designs first and looking for flaws, and indeed I found one: If you do copy out the archive logs not directly to tape, but to some disk area for further processing, then there is an issue with possible loss. If you do it like the docs say, with a command like this: archive_command = 'test ! -f /mnt/server/archivedir/%f && cp %p +/mnt/server/archivedir/%f' # Unix That "cp" is usually not synchronous. So there is the possibility that this command terminates successfully, and reports exitcode zero back to the Postgres, and then the Postgres will consider that log being safely away. But the target of the copy may not yet been written to disk. If at that point a power loss happens, the log may become missing/damaged/ incomplete, while the database may or may not consider it done when restarting. Therefore, mounting such a target filesystem in all-synchronous mode might be a good idea. (UFS: "-o sync", ZFS: "set sync=always") cheerio, PMc
В списке pgsql-admin по дате отправления: