[SQL] how to monitor the archiving process?

2005-03-02 Thread Smit
Hello, i am using postgreSQL 8.0.1. i wanted to archive the WAL files. i had set the 'archive_command' variable in the posgresql.conf file as archive_command = 'cp -i %p /mnt/server/archivedir/%f' but its not working. can anybody tell me, is there anything else which should be done and i missed

[SQL] what is maximum size of "text" datatype in postgres?

2004-09-13 Thread Smit
Hi, i wanted to know, what is maximum size of "text" datatype in postgres. It is given as "unlimited characters" in the postgres documentation. But it doesn't store characters more than 5000. The connection get lost if i tried to store more than 5000 characters. I had read somewhere on forum tha