FAQ |
As soon as I try to connect to my server I get a error "connect() failed- Is the postmaster running with -i option" |
Postgres by default does not open a listener socket for security reasons. It is advisable only to do these changes on a development server protected by a firewall. |
There are several ways of fixing the problem. It all depends on your Installation Version and Distribution (Redhat/Mandake) |
For version 7.2XX of postgres edit the file $PGDATA/postgresql.conf and set tcpip_socket = true |
Become Root: su - Change to postgres user: su - postgres Test the database server running: psql template1 |
/etc/rc.d/init.d/postgres start |
In your $PGDATA directory (/var/lib/pgsql/data or /var/local/lib/pgsql/data) edit the file postmaster.opts.default and add "-i" without the " and restart the server (/etc/rc.d/init.d/postgres restart) If there is no postmaster.opts.default add it in postmaster.opts |
/usr/bin/pg_ctl -o -i -D $PGDATA -p /usr/bin/postmaster start Just add "-o -i" Where $PGDATA is the location of your Data (/var/lib/pgsql/data ) |
No pg_hba.conf entry for <YOUR CLIENT IP>, user <YOUR USER NAME> |
In your PGDATA directory (/usr/lib/pgsql/data) edit your pg_hba.conf
and add a entry "host DBNAME IP_ADDRESS ADDRESS_MASK AUTHTYPE [AUTH_ARGUMENT]" eg. host pgexplorer <YOUR CLIENT IP> 255.255.255.255 trust host all <YOUR CLIENT IP> 255.255.255.255 password |
What kind of support do you provide for the tool? |
Currently we provide free email support for our registered users. Anyone must and can feel free to email suggestions for further enhancements or report problems / bugs. |
Are buyers qualified for free limited time upgrades? |
Yes for the current 1.XX version. |
What is the vision for the tool, and is there a timeline. |
What versions of PostgreSQL do you support |
|
What platfroms do you support. |
|
If you change from the 1.xx series to the 2.xx series will I need to buy a new copy or will I get a discount for the upgrade? |
|