"PostgreSQL 9.1.2 on x86_64-unknown-linux-gnu, compiled by gcc-4.4.real (Debian 4.4.5-8) 4.4.5, 64-bit"
is working in Debian 6.0 Squeeze
It contains 12 databases accessed by 100 users from internet.
md5 password authentication method is used.
Total size of all database compressed backup files in custom format is 10 GB.
I need time range type, so I'm looking for a way to upgrade to 9.3 or 9.4
I installed Postgers 9.3 as parallel in same server.
How to move databases, user names and passwords from 9.1 to 9.3 ?
I found instructions in
http://no0p.github.io/postgresql/2014/03/29/upgrading-pg-ubuntu.html
will this work in Debian Squeeze also ?
This uses pg_upgrade which requires access to 9.1 database during upgrade.
How to upgrade so that old database read access is possible during upgrade ?
Is is possible to create pipe using old psql to new psql or other idea ?
Database access can swithed off at nights for some time is this helps.