Is it possible to compare postgresql database in Redgate SQL Compare tool.
or Any other recommend tool for postgresql database compare tool.
No, Redgate just has comparison tools for SQL Server and Oracle. You could try PostgresCompare, which is an analogous tool to SQL Compare.