I've just downloaded pgadmin from :
and I've installed it :
rpm -ivh pgdg-centos92-9.2-6.noarch.rpm
How do I open it? where can I find it or do I need some additional steps?
That rpm just contains the files for adding the postgresql 9.2 repo to CentOS. You will need to download and install the relevant package. A bit of digging suggests that the package you want is pgadmin3_92 so
will install the programs for you to run.