so i tried to do a
/usr/local/pgsql.old/bin/postgres -D /usr/local/pgsql.old/data start
LOG: database system was shut down at 2013-06-19 08:10:51 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
it got stuck there ^^
the i tried to
so when following the instructions of pg_upgrade
If your installation directory is not version-specific, e.g.
/usr/local/pgsql, it is necessary to move the current PostgreSQL install
directory so it does not interfere with the new PostgreSQL installation.
Once the current PostgreSQL server is
so after trying i advance just a little bit but when running pg_upgrade for a
check or upgrade
i get:
pg_control values:
First log file ID after reset:0
First log file segment after reset: 2
pg_control version number:922
Catalog version number: 201204301
so i'm running ubuntu 12.04 with pg8.3.2 installed on it, i want to upgrade
to 9.2.4 using the pg_upgrade. i've followed this steps:
1) download postgres9.2.4
2)configure it and compile it
3) make and install the pg_upgrade and pg_upgrade_support utilities from the
pg9.2.4 contrib folder
4) init