[ADMIN] take a file system backup from /data folder

2006-12-11 Thread yogesh
hi to all i try lot to get the data back from my /data folder but i am fail to get it back i give the ftp site address from where u download the backup.tar file this file contain zipped /data folder so plase any one help me is there any way to get data back from this /data folder the o.s vers

Re: [ADMIN] Recovery plan for DRDB setup - recovery tool

2006-12-11 Thread Simon Riggs
On Thu, 2006-12-07 at 09:36 +, Morten Andersen wrote: > Our initial tests also shows that the failovers are problem free. But > we > would like to have a plan for how to handle the case where a failover > fails. With respect to DRBD, you'd need to look at how that works specifically since it i

Re: [ADMIN] how to recover database back from /data folder [ Possibly Recovered ]

2006-12-11 Thread Rajesh Kumar Mallah
Hi List , I restored the filesystem backup tar and ran postgres 7.3.8 on the data folder. there was no problem at all. DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/postgres" using argv[0] DEBUG: invoking IpcMemoryCreate(size=1466368) DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/

Re: [ADMIN] how to recover database back from /data folder [ Possibly

2006-12-11 Thread Andy Shellam (Mailing Lists)
I think the above messages support the fact that the database was shutdown properly before the filesystem level backup. Can anyone kindly confirm it ? "LOG: database system is ready" Says it all - if it hadn't been, you'd have gotten "LOG: database system was not shut-down cleanly, recoveri

Re: [ADMIN] how to recover database back from /data folder [ Possibly Recovered ]

2006-12-11 Thread Shoaib Mir
All looks according to the logs to me... --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/11/06, Rajesh Kumar Mallah <[EMAIL PROTECTED]> wrote: Hi List , I restored the filesystem backup tar and ran postgres 7.3.8 on the data folder. there was no problem at all. DEBUG: FindE

Re: [ADMIN] how to recover database back from /data folder [ Possibly Recovered ]

2006-12-11 Thread Shoaib Mir
I meant "all looks *good* according to the logs" :) --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/11/06, Shoaib Mir <[EMAIL PROTECTED]> wrote: All looks according to the logs to me... --- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/11/06, Rajesh Kumar Mall

Re: [ADMIN] how to recover database back from /data folder [ Recovered ]

2006-12-11 Thread Rajesh Kumar Mallah
On 12/11/06, Shoaib Mir <[EMAIL PROTECTED]> wrote: I meant "all looks *good* according to the logs" :) thanks everyone. regds mallah. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [ADMIN] Should duplicate indexes on same column and same tablebe allowed?

2006-12-11 Thread Simon Riggs
On Sat, 2006-12-09 at 12:46 -0500, Tom Lane wrote: > "Rajesh Kumar Mallah" <[EMAIL PROTECTED]> writes: > > Suppose an index get corrupted. And you need create a new index > > with exact specs and then drop the old index. Is it better to > > have a performing corrupted index or not have it at all an

[ADMIN] Simple Unload

2006-12-11 Thread Naomi Walker
From time to time, I need to unload rows to a delimited file, specifically with a "where" clause. I've cobbled a script together to do this, but it seems like a reasonable utility to support. Sort of a pg_dump on steroids.. Have I missed the simple way to do this? Would someone consider adding su

Re: [ADMIN] Simple Unload

2006-12-11 Thread Bricklen Anderson
Naomi Walker wrote: From time to time, I need to unload rows to a delimited file, specifically with a "where" clause. I've cobbled a script together to do this, but it seems like a reasonable utility to support. Sort of a pg_dump on steroids.. Have I missed the simple way to do this? Would some