[ADMIN] Urgent help required

2012-04-19 Thread Nagaraj Shindagi
Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not taken backup of the data. 1) how to take the data from the formatted harddisk. ? 2) how many

Re: [ADMIN] Urgent help required

2012-04-19 Thread Scott Mead
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi nagaraj.shind...@gmail.com wrote: Hi team, i am nagaraj, i am newbi in this database world. i required your help. 2 dyas back i formatted one of my client system. which is having postgresql 8.2 database that was having data. but i am not

Re: [ADMIN] Urgent help required

2012-04-19 Thread amador alvarez
Usually the standard location for data is /var/lib/pgsql/data for postgresql 8. So try to restore this directory first and underneath. Only with that you can hopefully restore the whole system assuming that if tablespaces were creates are under the standard location. I would ask others to

[ADMIN] Urgent Help required

2009-10-17 Thread Neha Patel
Hi, We are running with postgres sql 7.3.2. We were trying to create an index on a big table. The create index command ran for nearly 5 hours at which point we decided to interrupt it. Since this was interrupted, any operations attempted on the table on which the index was being created gives

Re: [ADMIN] Urgent Help required

2009-10-17 Thread Palaniappan Thiyagarajan
Drop the index first and create Palani Sent from my iPhone On Oct 17, 2009, at 7:23 PM, Neha Patel npa...@nevi-soft.commailto:npa...@nevi-soft.com wrote: Hi, We are running with postgres sql 7.3.2. We were trying to create an index on a big table. The create index command ran for nearly 5

Re: [ADMIN] Urgent Help required

2009-10-17 Thread Brian Modra
2009/10/16 Neha Patel npa...@nevi-soft.com: Hi, We are running with postgres sql 7.3.2. We were trying to create an index on a big table. The create index command ran for nearly 5 hours at which point we decided to interrupt it. Since this was interrupted, any operations attempted on the