[SQL] what is maximum size of "text" datatype in postgres?
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 that its max limit is 8 bytes, and we can increase it to 32 bytes. Do any one know how to increse it? or do anyone know any other way to solve this problem. Thanks, Smita ___ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
[SQL] how to monitor the archiving process?
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 it out? and also how to monitor the archiving process? Thanks in advance, Smita Send instant messages to your online friends http://uk.messenger.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
