A version of localtos3.php adapted for PostgreSQL made with the help of ChatGPT

[DavidCamejo]

This is a raw version that has not been reviewed or corrected. The idea is that together we can create a fully functional final version.
I'm new to Github. This is the easiest way to share the file:
https://cloud.brasdrive.com.br/s/f3cReWoRGAxaDMH

Explanation of the Adaptations Made
Connection to PostgreSQL:

All database connections and queries were changed from MySQL to PostgreSQL using pg_connect, pg_query, and related functions.
Backup and Restore Commands:

The backup and restore commands were changed to use pg_dump and psql instead of mysqldump and mysql.
SQL Queries:

The SQL queries were adapted to use PostgreSQL syntax, including double quotes for identifiers and specific functions like EXTRACT(EPOCH FROM ...).
Execution Options:

The dry-run, update-db, and delete-local options were kept as they were in the original script.
S3 Compatibility:

The configuration and use of AWS S3 for file synchronization were maintained.
This script should be executed in the Docker environment of Nextcloud to ensure that all dependencies and specific configurations are available. Be sure to make a full backup before running it in your production environment.

[szelga]

I've made a version utilizing PDO, so theoretically it could be adapted to a "universal" script. still needs some work on SQL scripts to see, if there are some flavor-independent options (mostly considering time functions in MySQL and PostgreSQL).

[szelga]

here it is:

localtos3_pg.php.txt

tested on a real (albeit small) NextCloud docker installation.

[szelga]

had issues with OnlyOffice previews after that, had to turn them off. not sure if this is due to migration or wonky OnlyOffice integration settings.

[mrAceT]

When I find the time I'll take a look at your work, thanks for sharing

[mrAceT]

May I assume this ticket can be closed with the inclusion of the work done by @mreho :

https://github.com/mrAceT/nextcloud-S3-local-S3-migration/blob/main/localtos3-postgres.php

?

[DavidCamejo]

Hi. This is another attempt at creating something functional. It's a bit more polished. Also with the help of AI.
https://github.com/DavidCamejo/nextcloud-local-to-s3-migration-tool-postgresql-edition
*** YET NOT TESTED ***

[mrAceT]

Ow wow, that looks like a complete rebuild!

Have you taken a look at the work of what @mreho did for PostgreSQL support? I have merged this into this project.

More info: #19

[DavidCamejo]

I'll take a look at it. It looks like it works well.