On going from postgres 9.1 to 9.2, it says that the data bases need to be upgraded so on giving the upgrade command I give and get the following
$ sudo service postgresql upgrade Stopping postgresql service: [ OK ] Upgrading database: [FAILED] See /var/lib/pgsql9/pgupgrade.log for details.
The contents of the log file
Performing Consistency Checks ----------------------------- Checking current, bin, and data directories ok Checking cluster versions ok connection to database failed: fe_sendauth: no password supplied could not connect to old postmaster started with the command: "/usr/lib64/pgsql/postgresql-9.1/bin/pg_ctl" -w -l "pg_upgrade_server.log" -D "/var/lib/pgsql9/data-old" -o "-p 5432 -b -c listen_addresses='' -c unix_socket_permissions=0700 -c unix_socket_directory='/var/lib/pgsql9'" start Failure, exiting
I used the postgres with password enable something like this
pg_connect("host=localhost port=5432 dbname=pgdbname user=postgres password=postgrespassword");
yum updated my system and fell into this. Can you even suggest a way in which I can revert back everything then it will be great!