Re: [ADMIN] Blob error after backup and restore

Yes , my command is pg_dump -Ft -b test > test.tar And the result is test.tar which is 5.5 Gb. . Sorry for my miss typing. What's wrong with my database? Thanks Amrit Thailand -- http://www.chaiyo.com äªâÂàÁÅì

[ADMIN] Blob error after backup and restore [database > 5.5 Gb.]

I have postgresql data [7.4.3] on fedora 3 which has the size of more than 5 Gb. and also contains blob for reporting. I use the command pg_dump -Ft -b homc > homc.tar test.tar > 5.5 Gb. after I try to restore it in another server which has the same environment [via nfs] and use the command

Re: [ADMIN] Blob error after backup and restore [database > 5.5 Gb.]

for more than 1 1/2 year without any problem include the blob , but just for a couple of weeks ago the backup database has no blob and I cannot create and save a new blob data . Is that because the database is quite big [5.5 Gb] or not? Amrit Thailand "Amrit Angsusingh" writes: a

Re: [ADMIN] how to protect root access database

There is no way to completely prevent those root to acces the database , because root by the meaning is the person to totally control all of the activities in this server include the database. I suggest you to seperate such an important database from those root by the hardware. Amrit i hav

[ADMIN] DBmirror and 64 bit mechine

expected error occur from the couple. Thanks. Amrit Angsusingh -- http://www.chaiyo.com - ??? ... ---(end of broadcast)--- TIP 3: Have

[ADMIN] DBmirror from 64 bit to 32 bit

? Thanks. Amrit Angsusingh -- http://www.chaiyo.com - ??? ... ---(end of broadcast)--- TIP 4: Have you searched our list archives