pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedUrgent help required
3+ messages / 3 participants
[nested] [flat]
* Urgent help required
@ 2012-04-19 17:47 Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Nagaraj Shindagi @ 2012-04-19 17:47 UTC (permalink / raw)
To: pgsql-admin
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 folders or files will be their at base folder. When we install
postgresql 8.2?
3) how to identify which folder contain which file. ?
Please help it is very urgent.
thanks and regards
--
Nagaraj V Shindagi
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Urgent help required
@ 2012-04-19 18:10 Scott Mead <scottm@openscg.com>
parent: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Scott Mead @ 2012-04-19 18:10 UTC (permalink / raw)
To: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>; +Cc: pgsql-admin
On Thu, Apr 19, 2012 at 5:47 PM, Nagaraj Shindagi <
nagaraj.shindagi@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 taken backup
> of the data.
> 1) how to take the data from the formatted harddisk. ?
>
If you have formatted your system, then your data is gone. You may have
luck with some data-recovery service.
> 2) how many folders or files will be their at base folder. When we install
> postgresql 8.2?
>
You need the PostgreSQL 'data' directory and *all *the files underneath.
> 3) how to identify which folder contain which file. ?
>
That depends on where you you downloaded postgres from and which platform
you are on.
--Scott
>
> Please help it is very urgent.
> thanks and regards
>
>
> --
> Nagaraj V Shindagi
>
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Urgent help required
@ 2012-04-19 21:54 amador alvarez <aalvarez@d2.com>
parent: Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: amador alvarez @ 2012-04-19 21:54 UTC (permalink / raw)
To: pgsql-admin
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 make sure there are no backups, sometimes there is
guy who knows...
Good luck
A.A.
On 04/19/2012 10:47 AM, Nagaraj Shindagi 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 taken
> backup of the data.
> 1) how to take the data from the formatted harddisk. ?
> 2) how many folders or files will be their at base folder. When we
> install postgresql 8.2?
> 3) how to identify which folder contain which file. ?
>
> Please help it is very urgent.
> thanks and regards
>
>
> --
> Nagaraj V Shindagi
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2012-04-19 21:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2012-04-19 17:47 Urgent help required Nagaraj Shindagi <nagaraj.shindagi@gmail.com>
2012-04-19 18:10 ` Scott Mead <scottm@openscg.com>
2012-04-19 21:54 ` amador alvarez <aalvarez@d2.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox