installing + using pgAgent?[edited]

[ROCLASI]

Hi Thomas,

Can you post here the output of the following command:

Code: Select all

psql -U postgres -d postgres -l

This lists all the databases without parsing them.

[tgs]

Hi Robert,

Can you post here the output of the following command:

Code: Select all

psql -U postgres -d postgres -l

This lists all the databases without parsing them.

I have tried the command in the Terminal, but: -bash: psql: command not found
What exactly shall I do to get the output?

[ROCLASI]

I have tried the command in the Terminal, but: -bash: psql: command not found
What exactly shall I do to get the output?

Use the full path:

Code: Select all

/Library/PostgreSQL/9.0/bin/psql -U postgres -d postgres -l

[tgs]

Thank you once more Robert!!

Here is the output:

Code: Select all

List of databases
       Name        |  Owner   | Encoding |  Collation  |    Ctype    |   Access privileges   
-------------------+----------+----------+-------------+-------------+-----------------------
core_data         | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
i18n_data         | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
log_data          | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
postgres          | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
sample_data       | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
servoy_repository | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |
template0         | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
                   |          |          |             |             | postgres=CTc/postgres
template1         | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 | =c/postgres          +
                   |          |          |             |             | postgres=CTc/postgres
tgsproject        | postgres | UTF8     | de_DE.UTF-8 | de_DE.UTF-8 |


[ROCLASI]

Hi Thomas,

Found the issue. Here is the updated code:

Code: Select all

databases=`$pg_tools/psql $pg_host -U postgres -d postgres -l | sed -n 4,/\eof/p | grep -v rows\) | awk {'print$1'} | grep -v \| | grep -v template | grep -v postgres`

I also update the script in my first post in this thread.

[tgs]

Hi Robert,

now the script is working well as it should be!
You are the Master and helped me (and perhaps many others) a lot. All my PostgreSQL installations should now be professional backed up.

Regards,
Thomas