Letractively / accounting-123

Automatically exported from code.google.com/p/accounting-123
0 stars 3 forks source link

backups not running #8

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
I get this error msg:

PostgreSQL location
Binary name: psql

Please enter the location of the PostgreSQL executable displayed above. This 
will be in the 'bin' subdirectory of your PostgreSQL directory. If you do not 
know this contact your integrator or use the Find command to locate the file.
NOTE: You should only specify the directory in which the binary is located and 
not the path to the file itself!

What steps will reproduce the problem?
1. Click Services>Backup>Make Backup

Original issue reported on code.google.com by meesterarend on 10 May 2012 at 9:14

GoogleCodeExporter commented 8 years ago
the pgsql file are in /usr/local/cubit/pgsql/bin
can I add an link file to that location somewhere?

Original comment by meesterarend on 10 May 2012 at 9:53

GoogleCodeExporter commented 8 years ago
What path is displayed when you look it up in the db? To look it up I would do 
the following on my computer:

jean@devbox:/var/www$ psql -U postgres cubit
psql (8.4.11)
Type "help" for help.

cubit=# select decode(locat, 'base64') from psql_location;
  decode  
----------
 /usr/bin
(1 row)

Original comment by jmoggee on 11 May 2012 at 12:59

GoogleCodeExporter commented 8 years ago
This is what I have

 select decode(locat, 'base64') from psql_location;
           decode
----------------------------
 /usr/local/cubit/pgsql/bin

Original comment by meesterarend on 14 May 2012 at 11:56

GoogleCodeExporter commented 8 years ago
Can you confirm that you can run the psql binary from 
/usr/local/cubit/pgsql/bin/psql ? Also make sure that permissions have been set 
so that www-data or nobody (whichever your installation uses) can execute psql?

Original comment by jmoggee on 14 May 2012 at 1:04

GoogleCodeExporter commented 8 years ago
Setting the permissions to 777 did it once again.
Thanks

Original comment by meesterarend on 15 May 2012 at 7:42