Re: [Gnumed-devel] Problems using gm-backup_database on debian, newest gnumed server/client

[Karsten Hilbert]

Hello Marc,

> mpfh, should have read the manpage of su carefully ;-),

It's a hairy beast.

> but the problem
> with the ' and " is a real one, because in ' the variable names will not
> be expanded, so the port number ist not passed to psql, see error message
> 
> etc/cron.daily/gnumed-server:
> 
> /usr/lib/postgresql/9.0/bin/psql: Diese Option benötigt ein Argument --
> »p«
> Versuchen Sie »psql --help« für weitere Informationen.

Thanks !  I've been pondering that one for a while but
haven't had the time to fully investigate it.

> I corrected the script and pgpass file
> 
> as you suggested and tata...! it's working. thx.
> 
> The line in gm-backup_database now is:
> 
> if ! su -c "psql -t -l -p ${GM_PORT}" -l postgres | grep -q 
> "^[[:space:]]*${GM_DATABASE}" ; then

Fixed starting with 0.9.5, thanks !

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346