SELECT t.table_schema,
t.table_name
FROM information_schema.tables t
INNER JOIN information_schema.columns c
ON c.table_name = t.table_name
AND c.table_schema = t.table_schema
WHERE c.column_name = 'user_ipad_id'
AND t.table_schema NOT IN ( 'information_schema', 'pg_catalog' )
AND t.table_type = 'BASE TABLE'
ORDER BY t.table_schema;

une mine d'or

Sauvegarde POSTGRESQL
A voir

GUI pour POstgresl 100% via navigateur. A installer sur un serveur

pg_basebackup

Une alternative au backup des BDD Postgresql

Pour savoir quelles sont les dates de fin de vie des version Postgresql :

End Of Life (EOL) dates

Version Current minor Supported First release date EOL date
9.6 9.6.2 Yes September 2016 September 2021
9.5 9.5.6 Yes January 2016 January 2021
9.4 9.4.11 Yes December 2014 December 2019
9.3 9.3.16 Yes September 2013 September 2018
9.2 9.2.20 Yes September 2012 September 2017
9.1 9.1.24 No September 2011 September 2016

Replication Postgresql avec 9.4 => possibilité de spécifier une BDD