pg_upgrade help

2018-04-18 Thread Akshay Ballarpure
Hi all, I need help on pg_upgrade from 8.4 to 9.4 version. Appreciate urgent response. Installed both version and stopped it. Do i need to run both version or only one 8.4 or 9.4 . Both should run on 50432 ? -bash-4.2$ id uid=26(postgres) gid=26(postgres) groups=26(postgres) context=unconfined

RE: Data migration from postgres 8.4 to 9.4

2018-04-17 Thread Akshay Ballarpure
Thank you for detailed info. much appreciated. May i know how to install pg_upgrade ? With Best Regards Akshay From: "Albin, Lloyd P" To: Akshay Ballarpure Date: 04/16/2018 08:38 PM Subject:RE: Data migration from postgres 8.4 to 9.4 Akshay , There are severa

Data migration from postgres 8.4 to 9.4

2018-04-16 Thread Akshay Ballarpure
Hello, I need help in using postgresql 8.4 data in postgres 9.4 version. Do I need to run any tool to achieve the same? Steps i followed is ran postgresql 8.4 and 9.4, copied data from 8.4 instance to 9.4 and try to start postgresql 9.4 but no luck, getting below error. [root@ms-esmon esm-dat

DB corruption

2018-03-23 Thread Akshay Ballarpure
Hi, I have a query on DB corruption. Is there any way to recover from it without losing data ? Starting postgresql service: [ OK ] psql: FATAL: index "pg_authid_rolname_index" contains unexpected zero page at block 0 HINT: Please REINDEX it. psql: FATAL: "base/11564" is not a valid data director