I installed PostgreSQL version 9.2 on Windows 7 64 bit. I then installed PostSqlForms. I start psql (PostgreSQL) and it works - it is running. Then I start psf (PostSqlForms). I have the correct host, port, username and password. The first "psf - message" I get is "This database does not contain the pfm_tables. You can run SQL command, but you cannot use or design forms or reports. Hint" Use 'SQL -> Instal pfm_tables' or "SQL -> Install example database...'" I have done both and yet I get the following error message: "Starting psql has failed:
couldn't execute "psql.exe": no such file or directory
No connection with psql."
There is no help in the PostSqlForms Help file and nothing on any forums that I can find, including this one.
This there any help out there on this?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you Willem.
It of course worked. You will probably be seeing more of me on this forum if I choose this tool for the front end for my postgreSQL db.
Thank you again for your prompt and helpful reply.
Cindy
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Since there are no topics yet, I thought this should be a good one to start.
I installed PostgreSQL version 9.2 on Windows 7 64 bit. I then installed PostSqlForms. I start psql (PostgreSQL) and it works - it is running. Then I start psf (PostSqlForms). I have the correct host, port, username and password. The first "psf - message" I get is "This database does not contain the pfm_tables. You can run SQL command, but you cannot use or design forms or reports. Hint" Use 'SQL -> Instal pfm_tables' or "SQL -> Install example database...'" I have done both and yet I get the following error message: "Starting psql has failed:
couldn't execute "psql.exe": no such file or directory
No connection with psql."
There is no help in the PostSqlForms Help file and nothing on any forums that I can find, including this one.
This there any help out there on this?
Hello Cindy,
This means that PostSqlForms cannot find the psql.exe executable.
You can solve this by changing the option 'psql' as follows.
In the main window of PostSqlForms open the options dialogue with
Tools -> Options.
Then go to Tab 'PostgreSQL' and change option 'psql' to the fully qualified path of psql.exe. It is probably something like:
C:/Program Files/PostgreSQL/9.2/bin/psql.exe
That should do the trick.
Best regards,
Willem Herremans
Thank you Willem.
It of course worked. You will probably be seeing more of me on this forum if I choose this tool for the front end for my postgreSQL db.
Thank you again for your prompt and helpful reply.
Cindy