Re:How to move from Amazon RDS to a dedicated PostgreSQL server
by pjungwir on Wednesday May 25, 2016 @09:49AM
(#11769718)
Since we're talking about Ubuntu, I would use the Ubuntu tools. They make it very easy to maintain several Postgres clusters side-by-side, e.g. /var/lib/postgresql/9.4/main vs /var/lib/postgresql/9.5/main. You can also control which binaries you use with the PGCLUSTER variable, like this:
PGCLUSTER=9.4/main pg_dump foo
PGCLUSTER=9.5/main pg_dump foo
initdb is part of standard PostgreSQL utilities/tools[1] for initializing your PostgreSQL server that's why I suggested using it. On the other hand, I don't see any reference to pg_createcluster command in the official PostgreSQL documentation. So I don't know why you think using a non-standard PostgreSQL tool (in place of a standard one i.e. initdb) is the right way of initializing a PostgreSQL database cluster.
[1] https://www.postgresql.org/docs/9.5/static/reference-server....