Re: [ADMIN] pg_dump

2005-10-09 Thread Luca Ferrari
Nirav Parikh's cat, on 10/10/2005 7.30, walking on the keyboard wrote: Hi, I am trying to write cronjob so it will backup database everynight on another machine. Currently is doing it on the same machine with this script. 20 13 * * * pg_dump -F c -f /root/database.pgdump database How can

[ADMIN] character problem

2005-10-09 Thread Luca Ferrari
Hi, I've got a postgres installation which is accessed by users thru a set of perl CGIs. Unlickily, when the user enters some characters in a description (string) field, like "èòéàùì", the string is stored in the database with other characters instead of those digited by the user. It seems as

[ADMIN] pg_dump

2005-10-09 Thread Nirav Parikh
Hi,   I am trying to write cronjob so it will backup database everynight on another machine. Currently is doing it on the same machine with this script.   20 13 * * * pg_dump -F c -f /root/database.pgdump database   How can I send it to different machine. Machine IP address is 192.168.1.13